I don't think the cursor sharing will help. We've been going 'round and
'round with the shared pool fragmentation problem and the 4031 errors.
Flushing the shared pool might or might not work; sometimes it cleans things
up; sometimes it doesn't do anything (as far as I can tell). About all you
c
*** Comments by BECKER, BILL Fri Jun 20, 2003 -- 08:09:59 AM
We upgraded to 64-bit 9.2.0.3.0 on Solaris 9 a few weeks ago,
and are currently experiencing ORA-01733 "virtual column not allowed
here" errors - bug 2884797. This is a star transformation bug,
and you are likely to hit it if yo
Looks like a whole set of bugs we haven't come across YET
-Original Message-
Sent: 20 June 2003 10:14
To: Multiple recipients of list ORACLE-L
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle Co
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8
following NON-Documented parameters were set by Oracle Corp
_shared_pool_reserved_min_alloc=16384
This was done to take care of the ORA-4031 errors. This caused shared pool erros to
STOP Occuring
though at