OraFAQ Forum: Performance Tuning » insert took a lnog time.

Home » RDBMS Server » Performance Tuning » insert took a lnog time. (sun 10g)

Wed, 02 April 2008 08:54

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

Wed, 02 April 2008 08:56

Michel Cadot
Messages: 68737
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

Wed, 02 April 2008 08:58

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

Wed, 02 April 2008 21:21

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: Thu Feb 13 02:34:14 CST 2025