| 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). Received on Fri Mar 08 2002 - 13:23:28 CST
 |
 |