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

Report message to a moderator

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: 68716
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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Find a correct value for PGA_AGGREGATE_TARGET
Next Topic: query tuning using explain plan
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 01:49:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.