We help IT Professionals succeed at work.

Oracle Database Tunning

egovernment
egovernment asked
on
How I can do Oracle Database Tunning by SQL Plus ?
Comment
Watch Question

Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
First, it's unusual that you really need to tune a "database" - instead you tune queries and pl/sql routines.

You can use auto trace to capture statistics about queries.  You can generate explain plans.

You can invoke extended tracing or profiling packages.

If you actually do need to make a change at the database level instead of to the code, you can issue alter system statements to adjust initialization parameters with spfiles.  If you use old style pfiles then you'll need to do that with a text editor at the os level and sql*plus isn't really involved
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
SQL*Plus is simply a client-server connection tool, one of several interfaces to the database you wish to examine.  And to echo Sean from above, the big picture is important to keep in mind.  With the more recent versions (10g, 11g) the emphasis has moved from statistical ratios to wait events:  finding what takes the longest to complete, and try to improve it.

There are many tutorials and guides on tuning here in EE; on the Oracle site; and so forth.

My parting thought is to make use of the built-in tuning provided by the Optimizer, by keeping your tables and indexes analyzed as appropriate. HTH

Commented:
The first question you should ask is

"Does my database needs tuning or not" If Yes Then
"Is the SQL and PL/SQL optimized" is Yes Then

"Is there enough memory allocated to various pools" if Yes Then

and so forth....

Commented:
BTW.  the answer by sdstuber above is perfect!! I am just repeating what he/she already said!!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.