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 advantage of having disk shadowing/ Mirroring ?

What constitute an ORACLE Instance?

what is ORACLE MEMORY STRUCTURES

What is an Oracle Rollback Segment?

What is Database Buffers ?

What is the role of PCTFREE parameter is Storage clause ?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

How to define Data Block size in Oracle?

How will you force database to use particular rollback segment?

What is meant by free extent ?

What is meant by recursive hints ?

how oracle will recognise its space is 100gb if 100gb is allocated for it...

For more Oracle Architecture Interview Questions Click Here