Looks like you maybe out of memory.


-----Original Message-----
From: Amin Adatia
[mailto:oracledba-ezmlmshield-x88063672.[Email address protected]
Sent: Monday, April 30, 2007 10:37 AM
To: LazyDBA Discussion
Subject: Re: SGA again

And what do the error codes actually mean?

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Mir Aijaz A "
<oracledba-ezmlmshield-x33088206.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 4:03 AM
Subject: SGA again


> my sga looks like the following
>
> SQL> show sga
>
> Total System Global Area 1611738096 bytes
> Fixed Size 457712 bytes
> Variable Size 1442840576 bytes
> Database Buffers 167772160 bytes
> Redo Buffers 667648 bytes
>
> sort_area_retained_size integer
524288
> sort_area_size integer
> 524288
> pga_aggregate_target big integer
> 54525952
> processes integer
> 600
> i am getting ora-12500 and ora-4030 errors. server configuration is as
> follows
>
> OS Name: Microsoft(R) Windows(R) Server 2003,
Standard
> Edition
> Total Physical Memory: 3,583 MB
> Available Physical Memory: 2,498 MB
> Virtual Memory: Max Size: 3,422 MB
> Virtual Memory: Available: 2,509 MB
> Virtual Memory: In Use: 913 MB
>
> do anyone have any clue what could be the reason for these errors
>
> Regards
> aijaz
>
>
>
> DISCLAIMER:
> Notice : This e-mail and any attachments may contain information which
is
> confidential to the addressee and may also be privileged. If you are
not
> the intended recipient of this e-mail, you may not copy, forward,
disclose
> or otherwise use it in any way whatsoever. If you have received this
> e-mail by mistake, please e-mail the sender by replying to this
message,
> and deleting the original and any printout thereof.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page