Home » RDBMS Server » Performance Tuning » Diff Between Utlxplp.sql and Utlxpls.sql Scripts
Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152597] Sat, 24 December 2005 08:55 Go to next message
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
Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152598 is a reply to message #152597] Sat, 24 December 2005 09:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
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?


Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152623 is a reply to message #152598] Sun, 25 December 2005 10:37 Go to previous messageGo to next message
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
Re: Diff Between Utlxplp.sql and Utlxpls.sql Scripts [message #152884 is a reply to message #152597] Tue, 27 December 2005 08:07 Go to previous message
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.
Previous Topic: spfile tunning help!!!
Next Topic: query waits
Goto Forum:
  


Current Time: Mon Nov 28 03:11:05 CST 2022