Session Status [message #428666] |
Thu, 29 October 2009 06:52  |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
Hi all,
Im creating index which is running for a long time in SQLPLUS session .
When i checked the status of the session from SQLPLUS session using
select sid,serial#,username,status from v$session
where status='ACTIVE' and username is not null
/
I could not see the status of session (where index is running) in SQLPLUS session.
So can i assume the session has expired or still active ?
Thanks
|
|
|
|
|
|
|
Re: Session Status [message #428671 is a reply to message #428670] |
Thu, 29 October 2009 07:22   |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
But how to check the status of the session which is running for long time and i could not
find the session status using
select sid,serial#,username,status from v$session
where status='ACTIVE' and username is not null
/
Regards,
|
|
|
|
|
|
|
|
Re: Session Status [message #431674 is a reply to message #428674] |
Thu, 19 November 2009 01:39   |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
Hi,
Statistics were running for a long time (more than 2 hr).I was monitoring the status
of the ACTIVE session using v$session using another session.Quite after a long time,
i could see the ACTIVE session disappeared but the session is still running (session cursor is blinking).
What to assume during this scenario?
Regards,
|
|
|
|
Re: Session Status [message #431685 is a reply to message #431679] |
Thu, 19 November 2009 02:22   |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
yes michel;
How to find out the time duration of my ACTIVE session that could sustain?
Because i could see my ACTIVE session get disappeared after running for a long time.
Regards,
|
|
|
|
|
|
|
|