Gene,
I strongly recommend implementing Statspack.
It is very straight-forward.
Just do it when you have exclusive use of the database, or comment
out the following two lines in ora_rdbms_admin:SPCUSR.SQL if you have
these packages already installed.
(We're running 8.1.7 on
Is sombebody playing with Statspack (spcreate.sql)?
One piece of the install runs dbmspool.sql
Nelson
-Original Message-
Sent: Tuesday, January 20, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
So what's the recommendation, how can I recompile all the SYS packages?
use Method-R.
I'm not sure how a badly fragmented table would show up in a 10046 trace
file.
If a table reorganization is really required, I think a trace would show
excess physical io.
Nelson Petersen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL
What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
PCTFREE and PCTUSEDare not part of the storage
clause.
SQL create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
Now you've got me going, Rich.
After 15 years of VMS we're being forced to use UNIX (HP-UX 11i) just
because
the application we want to use doesn't run on VMS.
(Developers needed to re-write the app for VMS. Marketing needed so the
developers will be paid
and the company will be profitable.)
The
same thing occurs on OpenVMS on version 9.2.0.4 of Oracle.
Nelson
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003
7:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Analytic bug in 9.2.0.4While playing around
Title: RE: decrease initial extent
Since
I agreed with Mladen that it wouldn't work, I just had to test
this.
On
8.1.7.3 on OpenVMS the "deallocate unused keep #" shrinks the initial
extent.
It
shrank a test table from 1m to 8k. I'm not sure why it chose
8k.
(db_block_size=4k,default