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?
-Origina
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 VMS.
d nail it. Everyone who is willing to put in some sweat
equity
can 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
What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
PCTFREE and PCTUSED are 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 wi
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, defaul