Urgent tunning [message #65238] |
Sat, 26 June 2004 23:55 |
gary
Messages: 35 Registered: January 2001
|
Member |
|
|
How can I tuning my database under oracle and improve the database performance and getting faster for all users.
ANy procedure and steps to follow under oracle or need some external third party program.
Pls help
thanks
My email: wwmg@netvigator.com
|
|
|
Re: Urgent tunning [message #65243 is a reply to message #65238] |
Fri, 02 July 2004 08:35 |
Satish Shrikhande
Messages: 167 Registered: October 2001
|
Senior Member |
|
|
-- Analyze all your tables .
Analyze table table_name compute statistics ;
-- Check for Long running SQL in the Database
-- Use Explain plan to get execution plan
-- Check for Indexes .
-- Use PL/SQL programs wherever you can It helps a lot ..
Good luck
|
|
|
Re: Urgent tunning [message #65244 is a reply to message #65243] |
Sat, 03 July 2004 05:09 |
gary
Messages: 35 Registered: January 2001
|
Member |
|
|
Dear satish,
Thanks for your reply.
-- Check for Long running SQL in the Database
-- Use Explain plan to get execution plan
-- Check for Indexes .
> what is the explain plan to get excution plan
> how to check indexes as well.
> Also, any third party or command can tunning the database more smooth and run
faster as well.
thanks
gary
|
|
|