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
dahalbibek
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,
Bibek

[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: 57612
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.

Regards
Michel
Previous Topic: On which columns to apply index
Next Topic: Query Tuning
Goto Forum:
  


Current Time: Sat Apr 19 10:36:50 CDT 2014

Total time taken to generate the page: 0.12332 seconds