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 meant by free extent ?

How to find the SGA Size

What is Dedicated Server Configuration?

How many Dispatcher Processes are created?

Teradata: How can we know the indexed column in a table?

What is the role of PCTFREE parameter is Storage clause ?

What is PGA?

Which parameter in Storage clause will reduce no. of rows per block?

What is dictionary cache ?

What is Shared Pool?

What Does DBWR do?

What are the functions of SMON?

For more Oracle Architecture Interview Questions Click Here