Oracle needs some amount in java_pool_szie to startup; not sure how much.
>From: "BigP" <big_planet_2000_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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_at_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: <F001.0052BEEF.20030109163716_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "BigP" <big_planet_2000_at_hotmail.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>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: root_at_fatcity.cts.com
>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" <ORACLE-L_at_fatcity.com>
>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" <ORACLE-L_at_fatcity.com>
> > 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.
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > > -----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: zlmei_at_hotmail.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: richard.ji_at_mobilespring.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: arupnanda_at_hotmail.com
> >
> > 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: ListGuru_at_fatcity.com (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: big_planet_2000_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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: arupnanda_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Jan 09 2003 - 20:29:03 CST
