| Performance tuning commands [message #176200] |
Wed, 07 June 2006 05:48  |
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
|
Member |
|
|
Hy
we are using oracle 8i clients and database system with d2k in front hand. Problem is server performance is too much slow as we handle large amount of data. Other than query optimizations methods i need some DBA commands that will work on server so that we can boost up the performance of server. currently we use ANALYZE and REBUILD INDEX command to tune up our server. Server confg. is P4 with double processor and 4 GB RAM and oracle 8i database with 30 clients.
Vikas
|
|
|
|
| Re: Performance tuning commands [message #176212 is a reply to message #176200] |
Wed, 07 June 2006 06:31  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>ther than query optimizations methods i need some DBA commands
eh?
No usefull information provided.
I have no idea how to proceed further.
Please read the sticky.
>>currently we use ANALYZE and REBUILD INDEX co
use DBMS_STATS instead of analyze.
Just Rebuilding indexes may or may not help anything with performance.
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
