Re: ORA-04030, create text index error
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 16 Mar 2009 13:45:19 -0500
Message-ID: <t8xvl.14562$W06.1724_at_flpi148.ffdc.sbc.com>
lsllcm wrote:
>> On Mar 11, 1:43 am, jgar the jorrible <joel-ga..._at_home.com> wrote:
>>
>>
>>
>>
>>
>>> On Mar 10, 8:29 am,lsllcm<lsl..._at_gmail.com> wrote:
>>>> Could you paste the document 233869.1 here?
>>> No. That would be a violation of Oracle support terms. You don't
>>> have support?
>>> If you aren't swapping, you might have some pga problem that might
>>> require serious support help. What do the pga advisor views tell
>>> you? What do you have pga_aggregate_target set to? I don't have
>>> linux available so I can't comment on your stack size,http://www.puschitz.com/TuningLinuxForOracle.shtmlisolder but may
>>> give you a clue what to look for if you have a stack collision
>>> problem. How big is your SGA? What does your swapinfo look like?
>>> jg
>>> --
>>> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/mar/10/1b10scam211015-3-s...
>> Sorry, I have read the document 233869.1.
>>
>> I have increased pga_aggregate_target to 30g.
>>
>> The stack size is 10g
>>
>> stack size (kbytes, -s) 10240
>>
>> I have add memory parameter 1g, When we create regular index, it will
>> use temporary tablespace. But why does not it use when creating text
>> index? It is very strange.- Hide quoted text -
>>
>> - Show quoted text -
Date: Mon, 16 Mar 2009 13:45:19 -0500
Message-ID: <t8xvl.14562$W06.1724_at_flpi148.ffdc.sbc.com>
lsllcm wrote:
> On Mar 11, 4:28 am, lsllcm <lsl..._at_gmail.com> wrote:
>> On Mar 11, 1:43 am, jgar the jorrible <joel-ga..._at_home.com> wrote:
>>
>>
>>
>>
>>
>>> On Mar 10, 8:29 am,lsllcm<lsl..._at_gmail.com> wrote:
>>>> Could you paste the document 233869.1 here?
>>> No. That would be a violation of Oracle support terms. You don't
>>> have support?
>>> If you aren't swapping, you might have some pga problem that might
>>> require serious support help. What do the pga advisor views tell
>>> you? What do you have pga_aggregate_target set to? I don't have
>>> linux available so I can't comment on your stack size,http://www.puschitz.com/TuningLinuxForOracle.shtmlisolder but may
>>> give you a clue what to look for if you have a stack collision
>>> problem. How big is your SGA? What does your swapinfo look like?
>>> jg
>>> --
>>> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/mar/10/1b10scam211015-3-s...
>> Sorry, I have read the document 233869.1.
>>
>> I have increased pga_aggregate_target to 30g.
>>
>> The stack size is 10g
>>
>> stack size (kbytes, -s) 10240
>>
>> I have add memory parameter 1g, When we create regular index, it will
>> use temporary tablespace. But why does not it use when creating text
>> index? It is very strange.- Hide quoted text -
>>
>> - Show quoted text -
> > Can anyone help? > > Thanks
Time to log a call with support. Received on Mon Mar 16 2009 - 13:45:19 CDT