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 functionality of SYSTEM table space ?

How the log writer writes the data into database

What are the components of SGA?

Why query fails sometimes ?

What is meant by free extent ?

What is the maximum size of a oracle9i database?

What is Cursor?

When Does DBWR write to the database?

Diference between Oracle 9i and 10G.

• What is oracle Architecture?

What is use of Rollback Segments In Database ?

What is the significance of having storage clause ?

For more Oracle Architecture Interview Questions Click Here