Re: ora-4030 error
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: Michael Fontana <michael.fontana@xxxxxxxxxxx>
- Date: Mon, 23 Nov 2009 14:45:17 -0500
Mike,
After I reduced the ulimit of psoft user, the job ran successfully via
process scheduler. We ran twice to make sure it run. However, I ran the
same sql via sqlplus, it failed again with 4030 error. I got explain
which is differently from what I got from sqr (via ps). The explain plan
I got for oem. I used tkprof to generate the plan for sqlplus.
Another interesting thing is after tax upgrade and cpu patch, I
immedailty refresh 2 testing database. One used the old file cp method
to clone the database, the other one used rman hot backup to clone the
database. Same sql ran successfully on the rman refreshed database. But
run out of temp space on the old fashion cloned database. Of course, the
execution plan are different from everywhere. prod (via ps and via
sqlplus), test (via rman duplicate and cold file cp)
Joan
--
//www.freelists.org/webpage/oracle-l
Other related posts:
