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 free extents are managed in Ver 6.0 and Ver 7.0 ?

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

What are the uses of Oracle Rollback Segment?

How will you monitor rollback segment status ?

How the space utilisation takes place within rollback segments?

What is the role of PCTFREE parameter is Storage clause ?

Can a Tablespace hold objects from different Schemes in Oracle?

What is the function of Redo Log in Oracle?

What is Dedicated Server Configuration?

What is Cursor?

How can we plan storage for very large tables ?

What is the function of Dispatcher (Dnnn)?

For more Oracle Architecture Interview Questions Click Here