Home » Server Options » Text & interMedia » Oracle Text tuning (Oracle,10GR2,Linux RHEL6)
Oracle Text tuning [message #642503] Sun, 13 September 2015 10:42 Go to previous message
devan0165
Messages: 28
Registered: September 2015
Location: Malaysia
Junior Member
Hi All,

I am newbie to Oracle 10g.

I have a linux box with oracle text installed running with total RAM of 16GB.

The server configured as below:-

1) SHMMAX = 13GB
2) SGA = 8GB
3) PGA = 4800M
4) CTX index memory = 2 GB.

Are the above oracle settings consider optimal for fulltext reindexing?

Are the CTX memory and PGA allocated from SHMMAX ?

Please help me to have oracle optimal setting

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ORA-29849 exception
Next Topic: matching names from two tables
Goto Forum:
  


Current Time: Tue Mar 31 23:52:56 CDT 2020