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
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
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:
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 Message
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
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 upgrade
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 the
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
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
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.
10 matches
Mail list logo