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 the function of ARCH?

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

What is an Oracle SYSTEM tablespace and when is it Created?

What are the two types of Server Configurations?

What is User Process?

What is the function of Lock (LCKn) Process?

What do Redo Log Buffers contain?

What are disadvanteges of having raw devices ?

What is hit ratio ?

What is Database Buffers ?

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

When Does DBWR write to the database?

For more Oracle Architecture Interview Questions Click Here