How to find the current session sid

Question Posted / cspriyadba

Answers were Sorted based on User's Feedback

How to find the current session sid..

Answer / cspriyadba

select sid from v$mystat where rownum=1;

Is This Answer Correct ?

21 Yes

1 No

How to find the current session sid..

Answer / guest

select distinct sid from v$mystat

Is This Answer Correct ?

2 Yes

0 No

How to find the current session sid..

Answer / umair anwar

select username,sid,serial# from v$session

Is This Answer Correct ?

13 Yes

14 No

More Oracle Architecture Interview Questions

What are the two types of Server Configurations?

What is the maximum size of a row in oracle 9i?

How to find the current session sid

What does LGWR do?

What are the consideration at tehe migration of Oracle 9i to 10G.

How the space utilisation takes place within rollback segments?

List the Optional Flexible Architecture (OFA) of Oracle database ?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

What is User Process?

How many Dispatcher Processes are created?

what is ORACLE MEMORY STRUCTURES

How will you swap objects into a different table space for an existing database?

For more Oracle Architecture Interview Questions Click Here