Hi Charlie,
> Variable Size 100663296 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 33841152 bytes
> Which initSGA.ora parameters control the "Variable Size" piece of
> the 9i SGA? I'd like to shrink this total to around 32MB.
You could change both t
Try shared_pool_size, large_pool_size, java_pool_size and
shared_pool_reserved size.
This is from 8i, there may be additional ones on 9i, or 1 or 2
of those I mentioned may be deprecated.
Jared
On Monday 24 June 2002 15:05, Charlie Mengler wrote:
> Yes, I know I need to RTFM, but if some kin
Also,
you probably thought of this, but have you looked at v$sga (which seems to be the info
you get on startup) and v$sgastat - which has details of each of the sections.
On 81714 on NT,
v$sga shows:
Fixed Size
Variable Size
Database Buffers
R
For those who dont know(and might not care),
OLD: db_block_buffers
NEW: db_cache_size
OLD: buffer_pool_keep
NEW: db_keep_cache_size
OLD: buffer_pool_recycle
NEW: db_recycle_cache_size
NEW: db_2K_cache_size
NEW: db_4k_cache_size
NEW: db_8k_cache_size
NEW: db_16K_cache_size
NEW: db_32K_cache_size
Charlie,
all of the following control the variable size.
db_block_buffers ( Of course db_cache_size in 9i) and
sharedpool_size and log_buffer_size.
The thing to note is you have your log_buffer_size set
to way higher than necessary. IMHO For such a small(
test ? ) system few KBs would suffice.
wa
Charlie,
You are hardly able to fit two instances of your configuration into 256M
along with OS memory requirements. For example, JServer option has
additional requirements for java_pool_size. RTFM about OLAP and Data Mining
option if they have some additional memory requirements. Partitionning A
Thanks to all that replied.
oracle@actaeon:RPT# sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 25 06:24:55 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Pro
Joe, what happened with your weekly tip about 9i ?
Ramon
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 9:58 PM
> For those who dont know(and might not care),
>
> OLD: db_block_buffers
> NEW: db_cache_size
> OLD: buffer
Ramon, it all depends on my workload and its been a bit much lately, i'm
hoping to test logical standby after i get thru studying for 9i upgrade
exam and take the test on mid july.
joe
Ramon E. Estevez wrote:
>Joe, what happened with your weekly tip about 9i ?
>
>Ramon
>
>- Original Mess
Check on Oracle streams in 9iR2. It is the new way for replication (Almost
same technology used in Quest product).
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original Message-
Sent: Tuesday, June 25
Ok. Joe
Good luck !!!
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 3:45 PM
> Ramon, it all depends on my workload and its been a bit much lately, i'm
> hoping to test logical standby after i get thru studying for 9i up
11 matches
Mail list logo