OraFAQ Forum: Performance Tuning » Columns of v$ sessions

Home » RDBMS Server » Performance Tuning » Columns of v$ sessions_event. (oracle 10.1.0.2.0 - windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Columns of v$ sessions_event. [message #476988]

Mon, 27 September 2010 12:10

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Need you are help....

The column's name SID (ID of the session) of v$session_event, shows 154 to 169. But there is no other user connected.
please tell me the reason?

Thanks in advance

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476989 is a reply to message #476988]

Mon, 27 September 2010 12:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476991 is a reply to message #476989]

Mon, 27 September 2010 12:18

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post the result of the followings (and post it formatted as explained in the link posted by BlackSwan):

select sid, username, status, type from v$session order by 1;
select * from v$session_event order by 1;

Regards
Michel

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476992 is a reply to message #476989]

Mon, 27 September 2010 12:23

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Blackswan,

What do u mean by posting this answer all the time? (I hope u don't know anything about oracle)
please stay away from my posts....plz

I'm asking to Mickel and Mahesh Rajendran.

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476993 is a reply to message #476992]

Mon, 27 September 2010 12:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When you do not following Posting Guidelines, I will reminder you to do so!

By the way "u" is not a member of this forum.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476994 is a reply to message #476993]

Mon, 27 September 2010 12:41

muktha_22
Messages: 527
Registered: December 2009

Senior Member

HI Michel,

Thanks and the answer for the above question is not required to past the screenshot, as the column by default having the values from the views v$session_event and v$session_wait also.

Hi Blackswan,

Then how to call u (Only u can understand if I call u as YOU)?
please don't make fun of any one, as we all are respecting u all and you are Forums.

Sorry if I hurt u lot more than enough (Yes, u deserve it).

Thanks

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476995 is a reply to message #476994]

Mon, 27 September 2010 12:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

If you choose to ignore Posting Guidelines & requests for information, then we can choose to not answer your questions until you do so.

Report message to a moderator

Re: Columns of v$ sessions_event. [message #476996 is a reply to message #476994]

Mon, 27 September 2010 12:50

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Thanks and the answer for the above question is not required to past the screenshot

And so? Does this change my answer? No! I require these information to answer you so post them.

Quote:

please don't make fun of any one, as we all are respecting u all and you are Forums.

STOP THIS and follow the guide.
You HAVE NOT to discuss that. You HAVE to follow the guide.
And NO MORE USE "U" as EXPLICITLY stated in the guide.
Respect us and post correctly.

Regards
Michel

Report message to a moderator

Previous Topic:	Insert into table slows down query
Next Topic:	Query Tunning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 22:38:44 CDT 2024