Home » RDBMS Server » Performance Tuning » import table having 30000000 rows (oracle9i,red hat linux rhel3, having only one processor,ram 1gb)
import table having 30000000 rows [message #409409] Mon, 22 June 2009 08:18 Go to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
i have to import a table having 30000000 rows.
when i import it gets stuck. my server hardware configuration is
processor- 3.00 ghz(single)
ram- 1 gb
hard disk- 160 gb

what can i do now.
please help me.
Re: import table having 30000000 rows [message #409417 is a reply to message #409409] Mon, 22 June 2009 08:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set buffer to the highest value than your RAM allows you without swapping (that is little given 1GB ram).

Drop the index before and recreate them after import.

Regards
Michel
Re: import table having 30000000 rows [message #409502 is a reply to message #409409] Mon, 22 June 2009 23:27 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
how i can set database buffer more than 1 gb.
please send me the syntax.
Re: import table having 30000000 rows [message #409550 is a reply to message #409502] Tue, 23 June 2009 01:41 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As your total RMA is 1G, it is useless and even worst to set buffer to 1G or more.
Buffer must fit inside available memory.

Regards
Michel
Previous Topic: performance problem with query
Next Topic: Parallel and First_rows Hints
Goto Forum:
  


Current Time: Sun Dec 04 22:32:11 CST 2016

Total time taken to generate the page: 0.13039 seconds