Home » RDBMS Server » Server Administration » what is server PSEUDO? (oracle 9i windows server 2003)
what is server PSEUDO? [message #353634] Tue, 14 October 2008 07:35 Go to next message
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.
Re: what is server PSEUDO? [message #353641 is a reply to message #353634] Tue, 14 October 2008 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: what is server PSEUDO? [message #353653 is a reply to message #353641] Tue, 14 October 2008 08:44 Go to previous messageGo to next message
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!
Re: what is server PSEUDO? [message #353661 is a reply to message #353653] Tue, 14 October 2008 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/125924/352237/102589/#msg_352237

Regards
Michel
Re: what is server PSEUDO? [message #353670 is a reply to message #353661] Tue, 14 October 2008 09:19 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
Hello Michel.
We are at merchants tire and nobody works?
Re: what is server PSEUDO? [message #353683 is a reply to message #353670] Tue, 14 October 2008 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Question

Regards
Michel
Re: what is server PSEUDO? [message #353779 is a reply to message #353683] Wed, 15 October 2008 01:51 Go to previous messageGo to next message
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?
Re: what is server PSEUDO? [message #353795 is a reply to message #353779] Wed, 15 October 2008 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: what is server PSEUDO? [message #353805 is a reply to message #353795] Wed, 15 October 2008 03:04 Go to previous messageGo to next message
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?
Re: what is server PSEUDO? [message #353813 is a reply to message #353805] Wed, 15 October 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What do you mean "latest user access"?
Latest active time?
Latest accessed objects?
Latest modified objects?
Latest statement?

Regards
Michel
Re: what is server PSEUDO? [message #353822 is a reply to message #353813] Wed, 15 October 2008 04:45 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
Latest active time and lastest statement at this time.
Regards
Re: what is server PSEUDO? [message #353824 is a reply to message #353822] Wed, 15 October 2008 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: what is server PSEUDO? [message #353831 is a reply to message #353824] Wed, 15 October 2008 05:00 Go to previous message
Haler
Messages: 71
Registered: October 2004
Member
thank you for your patience and answers.
Previous Topic: Tracking table creation
Next Topic: MAXIMUM sessions and processes
Goto Forum:
  


Current Time: Fri Nov 29 17:56:07 CST 2024