Home » RDBMS Server » Server Administration » Insertion Taking a Large time
Insertion Taking a Large time [message #182985] Wed, 19 July 2006 02:06 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi,
how to tune the Insertion of data that is takking a larger time.

What is the method to monitor and tune inserting data.

Thanks And Regards
Dinesh
Re: Insertion Taking a Large time [message #183110 is a reply to message #182985] Wed, 19 July 2006 06:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need provide atleast ***some*** information.
Generally, presence of index will slowdown the insert.
depending on the method you use, you may want to look into direct load insert or using nologging options.
If this is multi user environment and many users are concurrently inserting to the same table, look into freelists.
Again, please provide useful information. Else it will be a wild goose chase.
Re: Insertion Taking a Large time [message #183927 is a reply to message #182985] Mon, 24 July 2006 07:33 Go to previous message
jerrysun
Messages: 3
Registered: June 2006
Location: China
Junior Member
hi,I think you can take a view of the v$session_wait when you insert, it will make you know what the session wait for.
Previous Topic: how to find tablespace space information?
Next Topic: Two questions
Goto Forum:
  


Current Time: Tue Dec 03 16:05:30 CST 2024