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

Can a Tablespace hold objects from different Schemes in Oracle?

What is a Parallel Server option in ORACLE?

What is function of RECO?

What is a Rollback segment entry ?

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

What is the OPTIMAL parameter ?

What are functions of PMON?

What is Shared Pool?

What is dictionary cache ?

What is a Multi-threaded Server Configuration?

What is an Oracle Data Dictionary?

What is meant by recursive hints ?

For more Oracle Architecture Interview Questions Click Here