Bisa dicoba:

SQL> SELECT * FROM V$SGASTAT;

bw


--- In [email protected], Arif Mulyana <arinkm...@...> wrote:
>
> Halo mas Santoso,
> 
> Terima kasih mas atas informasinya, tetapi apakah perintah tersebut bisa 
> melihat status SGA yg saat ini sedang terpakai oleh Oracle (secara realtime) ?
> Terima kasih mas.
> 
> Salam
> 
> 
> Arif 
> 
> 
> --- On Sun, 4/7/10, absant...@... <absant...@...> wrote:
> 
> > From: absant...@... <absant...@...>
> > Subject: Re: [indo-oracle] Query SGA
> > To: [email protected]
> > Date: Sunday, 4 July, 2010, 1:35 PM
> > Halo mas arif,
> > 
> > Sql> show sga
> > Atau
> > Sql> select * from v$sga;
> > 
> > Salaam
> > Sent from my BlackBerry Wireless Handheld 
> > Powered by Gee! from StarHub
> > 
> > -----Original Message-----
> > From: arinkm...@...
> > Sender: [email protected]
> > Date: Sat, 3 Jul 2010 11:19:25 
> > To: <[email protected]>
> > Reply-To: [email protected]
> > Subject: [indo-oracle] Query SGA
> > 
> > Halo rekan-rekan, 
> 
> > Mau tanya donk query utk melihat status sga kita yang
> > realtime apa yah?
> 
> > 
> 
> > Salam
> 
> > 
> 
> > Arif
> 
> > 
> 
> > 
> 
> > Sent from BlackBerry® on 3
> 
> >
>


Kirim email ke