Home » RDBMS Server » Performance Tuning » Urgent tunning
Urgent tunning [message #65238] Sat, 26 June 2004 23:55 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Index maintenance
Next Topic: redo log contetnion
Goto Forum:
  


Current Time: Wed Feb 21 12:44:00 CST 2024