Home » RDBMS Server » Performance Tuning » very slow on insert (oracle 9i)
very slow on insert [message #548643] Fri, 23 March 2012 13:29 Go to next message
Messages: 1
Registered: March 2012
Location: Nepal
Junior Member
Dear All,
we are using oracle 9i on AIX Server.
When Customer were accessing the database, accidently power was shut down.
we restarted the Server,and Oracle database. all resumed successfully.
However while doing "Payments by the customer" it takes a lot of time to insert even a single payment record on database.The database is Live and our customer are very much frustated, Any idea would be appreciable.

Thank You,

[Updated on: Fri, 23 March 2012 13:32]

Report message to a moderator

Re: very slow on insert [message #548646 is a reply to message #548643] Fri, 23 March 2012 13:49 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can start with:
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning

You can also have a look at Database Performance Tuning Guide.

Previous Topic: How to find Local and global indexes on Particular Table
Next Topic: Ugly View Not Cooperating
Goto Forum:

Current Time: Wed Aug 23 08:39:36 CDT 2017

Total time taken to generate the page: 0.09458 seconds