Home » RDBMS Server » Server Administration » Monitoring Parallel Execution (9i,HPUX)
Monitoring Parallel Execution [message #335090] Sun, 20 July 2008 23:27 Go to next message
blagadag
Messages: 3
Registered: July 2008
Location: Manila, Philippines
Junior Member
Hi,

Just started working as an Oracle DBA for barely a month now.

I'm running a "create index COM_TRXN_IDX5... PARALLEL (DEGREE 5 INSTANCES 1)" script with multiple partitions via parallel execution.

I reckon since I invoked the DDL with parallelism, there will be several sessions that will be created aside from the session that actually invoked the said DDL.

My question is, is there a way for me to view these sessions?

Thanks in advance.
Re: Monitoring Parallel Execution [message #335091 is a reply to message #335090] Sun, 20 July 2008 23:30 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> is there a way for me to view these sessions?
SELECT * FRON V$SESSION;
Re: Monitoring Parallel Execution [message #335101 is a reply to message #335091] Mon, 21 July 2008 00:29 Go to previous messageGo to next message
blagadag
Messages: 3
Registered: July 2008
Location: Manila, Philippines
Junior Member

Can I limit the query on V$SESSION to the particular sessions handling the said DDL? I'm running the script in a multi-user environment where other users are also performing parallel executions.

Thanks.

Re: Monitoring Parallel Execution [message #335108 is a reply to message #335101] Mon, 21 July 2008 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you want to know which slave sessions/processes execute your statement? Query v$px_session, the coordinator is your session.

Regards
Michel
Re: Monitoring Parallel Execution [message #335119 is a reply to message #335108] Mon, 21 July 2008 01:34 Go to previous message
blagadag
Messages: 3
Registered: July 2008
Location: Manila, Philippines
Junior Member
Yup, that's what I meant Smile

Thanks Michel!

[Updated on: Mon, 21 July 2008 01:43]

Report message to a moderator

Previous Topic: Database check
Next Topic: Resource limit
Goto Forum:
  


Current Time: Wed Dec 07 12:22:36 CST 2016

Total time taken to generate the page: 0.12017 seconds