OraFAQ Forum: Text & interMedia » Oracle Text tuning

Home » Server Options » Text & interMedia » Oracle Text tuning (Oracle,10GR2,Linux RHEL6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Text tuning [message #642503]

Sun, 13 September 2015 10:42

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

Report message to a moderator

[Message index]

		Oracle Text tuning By: devan0165 on Sun, 13 September 2015 10:42
		Re: Oracle Text tuning By: John Watson on Sun, 13 September 2015 11:29
		Re: Oracle Text tuning By: devan0165 on Sun, 13 September 2015 21:06
		Re: Oracle Text tuning By: devan0165 on Tue, 15 September 2015 07:24
		Re: Oracle Text tuning By: John Watson on Tue, 15 September 2015 07:31
		Re: Oracle Text tuning By: devan0165 on Tue, 15 September 2015 07:41
		Re: Oracle Text tuning By: John Watson on Tue, 15 September 2015 07:44
		Re: Oracle Text tuning By: John Watson on Tue, 15 September 2015 07:46
		Re: Oracle Text tuning By: devan0165 on Tue, 15 September 2015 08:00
		Re: Oracle Text tuning By: Barbara Boehmer on Wed, 16 September 2015 16:08
		Re: Oracle Text tuning By: devan0165 on Tue, 22 September 2015 21:03
		Re: Oracle Text tuning By: BlackSwan on Tue, 22 September 2015 23:00
		Re: Oracle Text tuning By: John Watson on Wed, 23 September 2015 01:38
		Re: Oracle Text tuning By: devan0165 on Wed, 23 September 2015 01:44
		Re: Oracle Text tuning By: John Watson on Wed, 23 September 2015 02:01
		Re: Oracle Text tuning By: devan0165 on Wed, 23 September 2015 02:19
		Re: Oracle Text tuning By: John Watson on Wed, 23 September 2015 02:22
		Re: Oracle Text tuning By: devan0165 on Wed, 23 September 2015 02:25
		Re: Oracle Text tuning By: devan0165 on Wed, 23 September 2015 04:18
		Re: Oracle Text tuning By: devan0165 on Wed, 23 September 2015 04:21
		Re: Oracle Text tuning By: John Watson on Wed, 23 September 2015 07:00
		Re: Oracle Text tuning By: devan0165 on Fri, 25 September 2015 03:43
		Re: Oracle Text tuning By: John Watson on Fri, 25 September 2015 03:50
		Re: Oracle Text tuning By: devan0165 on Sun, 27 September 2015 08:26
		Re: Oracle Text tuning By: John Watson on Sun, 27 September 2015 08:38
		Re: Oracle Text tuning By: devan0165 on Sun, 27 September 2015 08:53
		Re: Oracle Text tuning By: Michel Cadot on Sun, 27 September 2015 10:37
		Re: Oracle Text tuning By: devan0165 on Sun, 27 September 2015 21:45
		Re: Oracle Text tuning By: Michel Cadot on Mon, 28 September 2015 00:31
		Re: Oracle Text tuning By: Barbara Boehmer on Wed, 23 September 2015 23:01
		Re: Oracle Text tuning By: devan0165 on Thu, 24 September 2015 08:01

Previous Topic:	ORA-29849 exception
Next Topic:	matching names from two tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 07:02:17 CDT 2024