Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Idle time
Hi Mark ,
But in 95/100 cases the command is "UNKNOWN" whenever the status is "sniped" .
The "Select" entry in the command column occurs very infrequently . I have not seen any other entries in the command column.
shreepad
To: ORACLE-L_at_fatcity.com AT INTERNET_at_CCMAIL cc: (bcc: Shreepad Vaidya/EMEA/ALLTELCORP)
If I understand your question - the commmand column relates to the
last
command that the user sent to the database - therefore the select
entry
would mean the last statement sent to the database by that user was a
select
statement.
HTH Mark
-----Original Message-----
Vaidya
Sent: Tuesday, April 24, 2001 01:56
To: Multiple recipients of list ORACLE-L
Hi,
That is precisely what i thought.
The reason I am putting this question is in the OEM Top sessions the command is "select" , instead of "UNKNOWN " .
But the command shows "select" .What does that mean ?.
shreepad
To: ORACLE-L_at_fatcity.com AT INTERNET_at_CCMAIL cc: (bcc: Shreepad Vaidya/EMEA/ALLTELCORP)
Idle means the database didnt have to do anything to service this session, basically, they didn't run any sql
hth
connor
"Some days you're the pigeon, some days you're the statue"
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc_at_yahoo.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: Shreepad.Vaidya_at_alltel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: Shreepad.Vaidya_at_alltel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 24 2001 - 12:24:23 CDT
![]() |
![]() |