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 Oracle Schema Objects?

What does LGWR do?

Can a Tablespace hold objects from different Schemes in Oracle?

How can we plan storage for very large tables ?

What is meant by redo log buffer ?

What is the maximum size of a oracle9i database?

List the factors that can affect the accuracy of the estimations ?

What is the OPTIMAL parameter ?

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 the role of archiever

What is Cursor?

What is an oracle database schema?

For more Oracle Architecture Interview Questions Click Here