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 is Database Buffers ?

What is Shared Pool?

1.Explain the three levels with the help og a diagram.

What is function of RECO?

• What is oracle Architecture?

How to define Data Block size in Oracle?

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

What is hit ratio ?

How will you monitor rollback segment status ?

What is a Multi-threaded Server Configuration?

What is an Oracle Data Dictionary?

How will you create multiple rollback segments in a database ?

For more Oracle Architecture Interview Questions Click Here