Re: SGA Help......

In article <4gaf7k$80i_at_isoit109.bbn.hp.com>, "V.N.Saravana Vijayan" <vijay> writes:
>Hi DBA's,
>
> I am just begining DBA(!!-) . I am getting this error
> when I am trying to do DML operation[
> 2000 SQL stmts I am executing one by one,
> commiting only each 16th SQL stmt].
>
> ORA-04031 Unable to allocate 744 bytes of shared
> memory("unknown object","sga heap","library cache")>!
> THANKX IN ADVANCE.
Vijayan,

Try the following in sequence, after each commit;

'alter system flush shared_pool;'
'alter system checkpoint;'
'alter system switch logfiles;' -- not needed if a test db.

Hope this helps.

Vikram.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426