OraFAQ Forum: Server Administration » Error: Out Of Memory

Home » RDBMS Server » Server Administration » Error: Out Of Memory

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

Error: Out Of Memory [message #154763]

Tue, 10 January 2006 07:34

saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad

Junior Member

Hi,

I have created Oracle 8i on my machine(Win xp) and i am trying to load data using Toad(Database --> Import --> Table Data)into their respective tables, it was loading fine for a while, but now when i am importing the data into the tables iam getting an error in Toad: Out Of Memory.
There is huge data that i am trying to import using toad.

Below are the details i have done after installing the Oracle 8i.

create tablespace ss_data
datafile 'C:\oracle\oradata\oracle\ss\ss_data_1.dbf'
size 500m
autoextend on
next 100m maxsize 2000m
extent management local;

CREATE USER ss IDENTIFIED BY ss
DEFAULT TABLESPACE ss_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON ss_DATA
QUOTA UNLIMITED ON TEMP;

GRANT CREATE SESSION TO SS;

GRANT "RESOURCE" TO SS;
ALTER USER "SS" DEFAULT ROLE "RESOURCE";

Then i have started loading the Data into above ss schema.

My System Config:
2 GB RAM; 70GB and Win XP Pro.

Please help me in detail, It is Very Urgent...

Thanks for your time,
Saritha

Report message to a moderator

Re: Error: Out Of Memory [message #154786 is a reply to message #154763]

Tue, 10 January 2006 10:13

saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad

Junior Member

Table space i am using.

NAME MBYTES USED FREE PCT_USED
------------------------------ ---------- ----------
SS_DATA 500 413 87 82.6

Below are the details of two segment_names i am using...
There are still lot more data i need to import but i am not able to do .....

HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT MAX_EXTENT
------------ ---------- ---------- ---------- -------------- ----
9 15728640 1920 30 65536 2147483645
3073 167772160 20480 91 65536 2147483645

SGA CACHE STATISTICS
********************
SQL Cache Hit rate = 99.98
Dict Cache Hit rate = 90.43
Buffer Cache Hit rate = 97.44
Redo Log space requests = 0

INIT.ORA SETTING
****************
Shared Pool Size = 31457280 Bytes
DB Block Buffer = 5620 Blocks
Log Buffer = 32768 Bytes

Do i need to increse the SGA or the table Space...Please help me
If SGA how do i increase it,please guide me in detail.Its very urgent waiting for the soutions.

Report message to a moderator

Re: Error: Out Of Memory [message #155342 is a reply to message #154786]

Sat, 14 January 2006 01:33

orausern
Messages: 826
Registered: December 2005

Senior Member

try increasing the sga size..u can do it by modifying the init.ora parameters..

e.g. set parameter shared_pool_size = 500000000 (500 mb)
perhaps u can also set
pga_aggregate_target = 314572800 (dont know for sure that in 8i pga_aggregate_target was there there or not..) if not then set #sort_area_size = 10485760 #10M
#sort_area_retained_size = 1048576 #1M

before doing any changes, note the existing values and if not useful, you can revert back to the original values..

Report message to a moderator

Previous Topic:	please confirm
Next Topic:	upgradation of oracle9i(32 bit ) to oracle 9i(64 bit)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 16:55:34 CST 2025