OraFAQ Forum: Server Administration » Monitoring Parallel Execution

Home » RDBMS Server » Server Administration » Monitoring Parallel Execution (9i,HPUX)

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

Monitoring Parallel Execution [message #335090]

Sun, 20 July 2008 23:27

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.

Report message to a moderator

Re: Monitoring Parallel Execution [message #335091 is a reply to message #335090]

Sun, 20 July 2008 23:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> is there a way for me to view these sessions?
SELECT * FRON V$SESSION;

Report message to a moderator

Re: Monitoring Parallel Execution [message #335101 is a reply to message #335091]

Mon, 21 July 2008 00:29

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.

Report message to a moderator

Re: Monitoring Parallel Execution [message #335108 is a reply to message #335101]

Mon, 21 July 2008 01:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Monitoring Parallel Execution [message #335119 is a reply to message #335108]

Mon, 21 July 2008 01:34

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:35:24 CST 2024