Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: A VLDB contest

RE: A VLDB contest

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 30 Aug 2006 10:38:51 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270958FFC9@AABO-EXCHANGE02.bos.il.pqe>


Wow....how big is your shared pool?  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

Ours is the age that is proud of machines that can think and suspicious
of men who try to.  --H. Mumford Jones, 1892-1980

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eric Jenkinson
Sent: Wednesday, August 30, 2006 9:51 AM
To: kevinc_at_polyserve.com
Cc: ORACLE-L
Subject: Re: A VLDB contest


Our largest database has following:
 
SQL> select *
     2   from v$sgastat
     3   where name like '%ASM%'
     4   order by bytes;
 
POOL           NAME                                              Bytes
------------------  ------------------------------------------
-------------------- 
shared pool   ASM rollback operations                       2592
shared pool   ASM map operations                            3360
shared pool   ASM file                                             19200
large pool      ASM map operations hashta              393216
shared pool   ASM extent pointer array            2.1131E+10
 
Do not have the ORA-4031 creeping syndrome on this database.
 
On 8/29/06, Kevin Closson <kevinc_at_polyserve.com> wrote: 


	Does anyone actually have ASM "put to the test" as they say?
Anyone 
	have huge ASM extent pointer array areas within their shared
pool? Anyone 
	have "ORA-4031-creeping syndrome" ? 

	For instance: 
	         select * from v$sgastat; 
	POOL         NAME                            BYTES 
	------------ -------------------------- ---------- 
	 shared pool ASM extent pointer array 287097144 

	Anyone see 1GB or more? 



	Kevin Closson 
	Chief Architect, Oracle Database Solutions 
	PolyServe, Inc 
	kevinc_at_polyserve.com 
	http://www.polyserve.com/oracle_consolidation.php

<http://www.polyserve.com/oracle_consolidation.php>
http://www.polyserve.com/oracle_rac_clusters.php
<http://www.polyserve.com/oracle_rac_clusters.php>
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 30 2006 - 09:38:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US