Oracle needs some amount in java_pool_szie to startup; not sure how much.
From: "BigP" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: v$sgastat question
Date: Thu, 09 Jan 2003 16:37:16 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by mc8-f41.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 9 Jan 2003 17:19:10 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id RAA77802;Thu, 9 Jan 2003 17:17:26 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052BEEF; Thu, 09 Jan 2003 16:37:16 -0800
Message-ID: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "BigP" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 10 Jan 2003 01:19:10.0757 (UTC) FILETIME=[478EFD50:01C2B846]
Do you really need java pool ? If not get rid of it . set it to 0.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 2:44 PM
> Guang,
>
> Earlier I posted a response to check java pool and large pool parameters.
> Any progress on that?
>
> Arup.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, January 09, 2003 3:15 PM
>
>
> > Then you should look into statspack and get a copy of "Oracle
Performance
> > Tuning 101".
> >
> > -----Original Message-----
> > Sent: Thursday, January 09, 2003 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi:
> >
> > My objective is to see if there is anything that I can change on db
> setting
> > to increase the performance, without modifying application code (BTW, we
> > already looked at all application code at least 5 times and would like
to
> > see if our db setting is good).
> >
> > Guang
> >
> > -----Original Message-----
> > Date: Wed, 8 Jan 2003 15:31:59 -0600
> >
> > Guang - What is your objective? What would you define as an improvement?
> >
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, January 08, 2003 3:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi:
> >
> > I am trying to learn how to make use v$sgastat info in our oracle 8173
db.
> >
> > Here is what I set for the instance:
> >
> > shared_pool_size 268435456
> > shared_pool_reserved_size 13421772
> > large_pool_size 614400
> > java_pool_size 1024000
> >
> > I also got v$sgastat info:
> >
> > SQL> select * from v$sgastat;
> >
> > POOL NAME BYTES
> > ----------- -------------------------- ----------
> > fixed_sga 73888
> > db_block_buffers 409600000
> > log_buffer 1024000
> > shared pool free memory 20906472
> > ....
> >
> >
> > _________________________________________________________________
> > Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Guang Mei
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Richard Ji
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BigP
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE* http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
