I am running a small dev server (Windows 2K) with Oracle 8.1.7, I would like to run two instances; one for the RMAN and OEM repository and the other for developing. I have experimented by creating two instances using the DBCA and
left the defaults. I have run both of these with the Management server and the machine just crawled (it only has 256 MB ram - hopefully to be doubled
soon).
I want to make the OEM / RMAN instance use as little resources as possible so I have experimented with the SGA. I have changed the parameter file by uncommenting the small DB settings aginst the following
SHARED_POOL_SIZE
DB_BLOCK_BUFFERS
LOG_BUFFER
and reduced the JAVA_POOL_SIZE to 32k as I don't use java. This has reduced the instance from 100MB to 30MB roughly.
Does anybody have any guidelines for parameter and DB settings to produce a small instance suitable for the OEM/RMAN and one for developing with on a non production box. At the moment I am selecting all the options in the
DBCA:
TimeSeries
Spatial
Jserver
Intermedia
Visual Information Retreival
Advanced Replication
sql plus help
I don't think I need any of these for the OEM/RMAN instance? The data file size is 260MB what can this be reduced to along with the following tablespaces; rollback, user, temporary, tools, index
user.
Sorry for the long post! And any help would be gladly appreciated as I am struggling to find any resources on this.
Regards,
Harry
left the defaults. I have run both of these with the Management server and the machine just crawled (it only has 256 MB ram - hopefully to be doubled
soon).
I want to make the OEM / RMAN instance use as little resources as possible so I have experimented with the SGA. I have changed the parameter file by uncommenting the small DB settings aginst the following
SHARED_POOL_SIZE
DB_BLOCK_BUFFERS
LOG_BUFFER
and reduced the JAVA_POOL_SIZE to 32k as I don't use java. This has reduced the instance from 100MB to 30MB roughly.
Does anybody have any guidelines for parameter and DB settings to produce a small instance suitable for the OEM/RMAN and one for developing with on a non production box. At the moment I am selecting all the options in the
DBCA:
TimeSeries
Spatial
Jserver
Intermedia
Visual Information Retreival
Advanced Replication
sql plus help
I don't think I need any of these for the OEM/RMAN instance? The data file size is 260MB what can this be reduced to along with the following tablespaces; rollback, user, temporary, tools, index
user.
Sorry for the long post! And any help would be gladly appreciated as I am struggling to find any resources on this.
Regards,
Harry