Home » SQL & PL/SQL » SQL & PL/SQL » SQL Tuning Made Easy in 10g
SQL Tuning Made Easy in 10g [message #231342] Mon, 16 April 2007 11:04 Go to next message
KrishnaBoppana
Messages: 12
Registered: March 2007
Location: Boston, MA
Junior Member
Oracle 10g comes with new PL/SQL package - DBMS_SQLTUNE which can be used to tune SQL statements.

Krishna Boppana

[Updated on: Sun, 27 January 2008 09:24] by Moderator

Report message to a moderator

Re: SQL Tuning Made Easy in 10g [message #231421 is a reply to message #231342] Tue, 17 April 2007 00:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Sure. And with 10g you also don't need a DBA anymore.
Re: SQL Tuning Made Easy in 10g [message #231432 is a reply to message #231421] Tue, 17 April 2007 01:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
And with 10g you also don't need a DBA anymore.?
Really, Frank .

I don't agree.

if you read Mr. Tom kyte reply... i hope you change your point of view about "DBA" need in 10g.
Let me ask you 4 questions -- then you tell me what the future of the DBA is:

question 1:  Have you been told you will be managing fewer applications running against 
your databases?  that is, is your company retiring applications -- desupporting them and 
not replacing them with something else?  

OR

are you finding that every month brings yet another application in addition to the ones 
your already had to manage?

question 2: Have you been told to give back all of the disk you no longer need since your 
databases are getting smaller and smaller?

OR

have you been ordering more disk since they are growing and growing?


question 3: Have you been dropping users and not creating new ones?  That is, has the 
base of users dependent on your databases been GROWING?

OR

has it been shrinking?


question 4: The big question.  When was the last time someone said to you "hey, its ok if 
the database is down frequently and for long periods.  performance isn't really important 
either. "


http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:14039738984108

Regards
Taj
Re: SQL Tuning Made Easy in 10g [message #231468 is a reply to message #231432] Tue, 17 April 2007 03:43 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
hm...
Re: SQL Tuning Made Easy in 10g [message #231497 is a reply to message #231468] Tue, 17 April 2007 05:20 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Laughing
Re: SQL Tuning Made Easy in 10g [message #231504 is a reply to message #231468] Tue, 17 April 2007 05:53 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Frank wrote on Tue, 17 April 2007 10:43
hm...

http://www.orafaq.com/forum/fa/449/0/

MHE
Re: SQL Tuning Made Easy in 10g [message #231525 is a reply to message #231504] Tue, 17 April 2007 07:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Hundreds and hundreds of thousands of blistering barnacles!.
Smile
Previous Topic: how to avoid control characters in the data
Next Topic: Better PL/SQL
Goto Forum:
  


Current Time: Sat Dec 03 18:06:54 CST 2016

Total time taken to generate the page: 0.11591 seconds