OraFAQ Forum: Performance Tuning » Diff Between Utlxplp.sql and Utlxpls.sql Scripts

Home » RDBMS Server » Performance Tuning » Diff Between Utlxplp.sql and Utlxpls.sql Scripts

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

Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152597]

Sat, 24 December 2005 08:55

krajkumar
Messages: 2
Registered: December 2005
Location: Bangalore-India

Junior Member

Hi all,

Could anyone explain me about the diff between utlxplp.sql and utlxpls.sql scripts. I know one works serial and other parallel.

What are Parallel and Serial?
How does it works?

Please Let me know in detail.

Thanks in Advance
Raaj

Report message to a moderator

Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152598 is a reply to message #152597]

Sat, 24 December 2005 09:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You asked the same question in CDOS and got response from many including Connor McDonald. None of those responses help you?

Report message to a moderator

Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152623 is a reply to message #152598]

Sun, 25 December 2005 10:37

krajkumar
Messages: 2
Registered: December 2005
Location: Bangalore-India

Junior Member

Hi Mahesh,
What they said are highly technical to me. I can't follow up. If possible let me know in details, as i am a newbie to Oracle9i DBA.

Thanks
Rajkumar.K

Report message to a moderator

Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152884 is a reply to message #152597]

Tue, 27 December 2005 08:07

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

Senior Member

If you are new to it, then it really won't matter which one you use to start with. Just pick one and go with it. You can read the scripts themselves, at the top of each it tells you what they do. If you are using 10gR1 or up, then just go with utlxplp.

Report message to a moderator

Previous Topic:	spfile tunning help!!!
Next Topic:	query waits

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 07:34:53 CST 2024