OraFAQ Forum: Server Administration » what is server PSEUDO?

Home » RDBMS Server » Server Administration » what is server PSEUDO? (oracle 9i windows server 2003)

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

what is server PSEUDO? [message #353634]

Tue, 14 October 2008 07:35

Haler
Messages: 71
Registered: October 2004

Member

Hello,

1) what's server type=PSEUDO in V$session?
2) How to find if session is active where status in v$session is inactive?

Thanks a lot.

Report message to a moderator

Re: what is server PSEUDO? [message #353641 is a reply to message #353634]

Tue, 14 October 2008 07:53

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

Senior Member
Account Moderator

1) Session from connection pool or killed session for instance.
2) if a session is inactive it is not active

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353653 is a reply to message #353641]

Tue, 14 October 2008 08:44

Haler
Messages: 71
Registered: October 2004

Member

Hello,

attached file containing the results of sessions.
You see that many sessions are inactive while people work!

Attachment: Nouveau Document texte.txt
(Size: 47.55KB, Downloaded 1252 times)

Report message to a moderator

Re: what is server PSEUDO? [message #353661 is a reply to message #353653]

Tue, 14 October 2008 09:02

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

Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/125924/352237/102589/#msg_352237

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353670 is a reply to message #353661]

Tue, 14 October 2008 09:19

Haler
Messages: 71
Registered: October 2004

Member

Hello Michel.
We are at merchants tire and nobody works?

Report message to a moderator

Re: what is server PSEUDO? [message #353683 is a reply to message #353670]

Tue, 14 October 2008 11:07

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

Senior Member
Account Moderator

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353779 is a reply to message #353683]

Wed, 15 October 2008 01:51

Haler
Messages: 71
Registered: October 2004

Member

Hello Michel,

I understand that a session is inactive
if there is no sql query,
but
how is it possible to have no query
, at a given time ,
with over 100 users?

Report message to a moderator

Re: what is server PSEUDO? [message #353795 is a reply to message #353779]

Wed, 15 October 2008 02:48

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

Senior Member
Account Moderator

Many and many and many reasons.
For instance, queries are short to execute but network and application server are long to answer.
Or all your users are drunk and don't see that the answer is on their screen, or it is snap time.

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353805 is a reply to message #353795]

Wed, 15 October 2008 03:04

Haler
Messages: 71
Registered: October 2004

Member

Hello Michel,

Thank you for reply.
another question:
is there a query that possibly learn the latest user access?

Report message to a moderator

Re: what is server PSEUDO? [message #353813 is a reply to message #353805]

Wed, 15 October 2008 03:46

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

Senior Member
Account Moderator

What do you mean "latest user access"?
Latest active time?
Latest accessed objects?
Latest modified objects?
Latest statement?

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353822 is a reply to message #353813]

Wed, 15 October 2008 04:45

Haler
Messages: 71
Registered: October 2004

Member

Latest active time and lastest statement at this time.
Regards

Report message to a moderator

Re: what is server PSEUDO? [message #353824 is a reply to message #353822]

Wed, 15 October 2008 04:49

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

Senior Member
Account Moderator

Latest active time: v$session.last_call_et
Latest statement: join sql_id or prev_sql_id with v$sql but it does not work each time.

Regards
Michel

Report message to a moderator

Re: what is server PSEUDO? [message #353831 is a reply to message #353824]

Wed, 15 October 2008 05:00

Haler
Messages: 71
Registered: October 2004

Member

thank you for your patience and answers.

Report message to a moderator

Previous Topic:	Tracking table creation
Next Topic:	MAXIMUM sessions and processes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:05:24 CDT 2024