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

How will you monitor the space allocation ?

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

How to implement the multiple control files for an existing database ?

When Does DBWR write to the database?

How many Dispatcher Processes are created?

What is the use of Oracle Control File?

What is meant by Redo Log file mirrorring ? How it can be achieved?

what is the role of archiever

What do Redo Log Buffers contain?

What are Oracle Schema Objects?

How will you force database to use particular rollback segment?

How the space utilisation takes place within rollback segments?

For more Oracle Architecture Interview Questions Click Here