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: 68658
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: On which columns to apply index
Next Topic: Query Tuning
Goto Forum:

Current Time: Sun May 26 06:23:28 CDT 2024