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

Why query fails sometimes ?

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

What is Server Process?

What are functions of PMON?

When Does DBWR write to the database?

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

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

What are the uses of Oracle Rollback Segment?

What is the role of PCTFREE parameter is Storage clause ?

List the factors that can affect the accuracy of the estimations ?

what is the role of archiever

How will you monitor the space allocation ?

For more Oracle Architecture Interview Questions Click Here