Kevin,
�
I thought that those are actually RAID 4.
You don't have any control over allocation on a NetApp box?
Is that due to inherent limitations of the volume manager/file systems
or due to implementation specific to your SysAdmins' biases?
�
thanks,
�
Paul
�
-----Original Message-----
Sent: Tuesday, June 12, 2001 6:39 PM
To: Multiple recipients of list ORACLE-L
New file system is out.�� We are running on Net App Appliances containing a
Raid 5 system on Solaris using Oracle 8.0.5.�� Not the best environment but
its what we have to work with.� So, hardware is out.
�
As far as file system tuning .....� Another no.� Its a Waffle system .....
basicly, write anywhere , so where you put the tables and indexes are prety
much a moot point.��
�
So, we are down to runnig it at night.��Not the kind of suggestion I was
looking for .... but its the one I figured I would hear.
�
Oh well.
�
Thanks anyway.
-----Original Message-----
Sent: Tuesday, June 12, 2001 5:05 PM
To: Multiple recipients of list ORACLE-L
buy a better i/o subsystem?� this should finish in single digit minutes, at
worst.
�
ok, can't do that?
�
then
�
tune the i/o system
can't?
ok, then partition the table/index to faster/more/different drives
can't?
ok, then run the analyze at night via cron
can't
ok, then screw it, it's not worth it.� ( just kidding )
-----Original Message-----
Sent: Tuesday, June 12, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L
Hi folks;
� We have an Analyze running that is taking forever.� Here is the setup:
��� The table is about 250 bytes wide.
��� The table is normally�100,000 rows
��� The table has grown to over 4,000,000 rows.
��� There is one index on 1 column.
��� We used the Compute Statistics options
�
Does anyone have any suggestions on how we can get this analyze to complete
and still generate worthwile statistics ??
�
Thanks
�
Kevin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
