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 to implement the multiple control files for an existing database ?

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

What is an oracle database schema?

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

Name the ORACLE Background Process?

What is dictionary cache ?

What is meant by recursive hints ?

List the Optional Flexible Architecture (OFA) of Oracle database ?

When Does DBWR write to the database?

What is the maximum size of a oracle9i database?

What are the functions of SMON?

What is the functionality of SYSTEM table space ?

For more Oracle Architecture Interview Questions Click Here