OraFAQ Forum: Server Administration » Insertion Taking a Large time

Home » RDBMS Server » Server Administration » Insertion Taking a Large time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insertion Taking a Large time [message #182985]

Wed, 19 July 2006 02:06

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

Report message to a moderator

Re: Insertion Taking a Large time [message #183110 is a reply to message #182985]

Wed, 19 July 2006 06:46

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Insertion Taking a Large time [message #183927 is a reply to message #182985]

Mon, 24 July 2006 07:33

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.

Report message to a moderator

Previous Topic:	how to find tablespace space information?
Next Topic:	Two questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:25:26 CDT 2024