Home » RDBMS Server » Enterprise Manager » Reg : Pausing a query
icon7.gif  Reg : Pausing a query [message #154923] Wed, 11 January 2006 06:20 Go to next message
vivek_g_r
Messages: 15
Registered: May 2005
Junior Member
Hi,

Is there any possibility to pause a query which is happening in a server.

Thanks & Regards

R.Vivekanandaan

Razz
Re: Reg : Pausing a query [message #155125 is a reply to message #154923] Thu, 12 January 2006 08:41 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Get the process id from v$process and suspend it with oradebug.

SELECT pid FROM v$process WHERE ...
ORADEBUG SETORAPID ...
ORADEBUG SUSPEND


Re: Reg : Pausing a query [message #155562 is a reply to message #154923] Tue, 17 January 2006 04:40 Go to previous message
vivek_g_r
Messages: 15
Registered: May 2005
Junior Member
Hi,

Could u explain in detail as i'm new to this area.

Thanks & Regards

R.Vivek
Previous Topic: User-Defined Metrics
Next Topic: export from HP-unix and import on solaris
Goto Forum:
  


Current Time: Thu Mar 28 09:14:50 CDT 2024