OraFAQ Forum: Enterprise Manager » Reg : Pausing a query

Home » RDBMS Server » Enterprise Manager » Reg : Pausing a query

Wed, 11 January 2006 06:20

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

Thu, 12 January 2006 08:41

Frank Naude
Messages: 4596
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

Tue, 17 January 2006 04:40

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: Wed Sep 03 02:10:28 CDT 2025