Re: ORA-04030, create text index error
From: jgar the jorrible <joel-garry_at_home.com>
Date: Tue, 10 Mar 2009 10:43:21 -0700 (PDT)
Message-ID: <a392af6e-717c-44a4-8de8-c088a9ad3874_at_r15g2000prh.googlegroups.com>
On Mar 10, 8:29 am, lsllcm <lsl..._at_gmail.com> wrote:
Date: Tue, 10 Mar 2009 10:43:21 -0700 (PDT)
Message-ID: <a392af6e-717c-44a4-8de8-c088a9ad3874_at_r15g2000prh.googlegroups.com>
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.shtml is older 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-sentenced-scam-over-foreclosures/?uniontribReceived on Tue Mar 10 2009 - 12:43:21 CDT