| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> VMS, large database
I have a large 7.4 db running under VMS... Database has limited objects, 125,148 meg, with 1,131 tables and 1,022 indexes. (Total
objects = 3,445)
It runs around 256 I/O per sec and 7,011 logical I/O per sec. Fetch vs. Scan is 5%..
They run about 87 db waits per minute and get 176 I/O per wait...
What might I look at to see if they would benefit to go from an 8K blocksize to 16K as they migrate from 7.4 to 8.1.7 I think it is... He's going to build a new database and import. If this would help, it would be the time to do it.
ThinkSpark - Michael Alan Kline, Sr.
Technical Consultant - Richmond, Virginia Office
13308 Thornridge Court; Midlothian, VA 23112, USA.
W: 804-744-1545 Cell: 804-314-6262
Michael.Kline_at_ThinkSpark.com
Pager: 877-705-1155_at_my2way.com
Alpha pager: www.metrocall.com/Page.html
ICQ: 1009605, 975313 PhoneFree: 1057439
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: mkline1_at_comcast.net
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: ListGuru_at_fatcity.com (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).
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
------_=_NextPart_001_01C1C75E.5DF0CD00--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Kline
INET: mkline1_at_comcast.net
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: ListGuru_at_fatcity.com (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).
 |
 |