Home » RDBMS Server » Performance Tuning » insert took a lnog time. (sun 10g)
insert took a lnog time. [message #310818] Wed, 02 April 2008 08:54 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
hello

i have problems

when i do a few inserts to my tables
its wait 5 mintues and after that its run?
why?

thanks
Re: insert took a lnog time. [message #310819 is a reply to message #310818] Wed, 02 April 2008 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Because it was tired and needed a rest before completing the work.

Regards
Michel
Re: insert took a lnog time. [message #310820 is a reply to message #310819] Wed, 02 April 2008 08:58 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
Laughing
Re: insert took a lnog time. [message #310938 is a reply to message #310820] Wed, 02 April 2008 21:21 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try performing a SQL TRACE and run the trace file through TKPROF.
Previous Topic: Find a correct value for PGA_AGGREGATE_TARGET
Next Topic: query tuning using explain plan
Goto Forum:
  


Current Time: Wed Dec 04 19:49:04 CST 2024