OraFAQ Forum: Server Administration » Regarding V$session

Home » RDBMS Server » Server Administration » Regarding V$session_longops

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

Regarding V$session_longops [message #168902]

Mon, 24 April 2006 01:50

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

During a import that is taking around 1 minute i checked V$session_longops.

But it is not showing the information about that.

If i want to know the progress of import which view other than V$session_longops i have to look?

Also my test db is in noarchivelog mode.

I tried to make an online databbase full backup using RMAN.

That operation failed and i checked the V$session_longops.

Information about the failed process is stored in that.

Please clarify my doubts about the V$session_longops.

Thanks in Advance
Salih km Cool

Report message to a moderator

Re: Regarding V$session_longops [message #169036 is a reply to message #168902]

Mon, 24 April 2006 15:13

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

For longer operations...I don't know the exact cutoff, but one minute wouldn't be long enough.

I believe that you can set some of the info displayed in this view, like client and module, from the dbms_application_info package.

SET_SESSION_LONGOPS Procedure
Sets a row in the V$SESSION_LONGOPS table

Report message to a moderator

Re: Regarding V$session_longops [message #169083 is a reply to message #169036]

Tue, 25 April 2006 00:37

kmsalih
Messages: 197
Registered: March 2006

Senior Member

what is the purpose of dbms_application_info.SET_SESSION_LONGOPS Procedure?

Thanks
Salih Km

Report message to a moderator

Previous Topic:	sqlnet.ora
Next Topic:	How to execute .sql file on oracle server startup.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:28:13 CDT 2024