Pawan - The gurus are sleeping in this morning, so you're stuck with the "aspiring guru". According to Oracle's documentation, v$waitstat breaks buffer waits down by block class. You may be better off starting with v$system_event and v$session_event and if this shows a lot of buffer busy waits, then key in on v$waitstat. You might get a copy of Gaja's book "Oracle Performance Tuning 101". Then you'll really impress him. If you have everything on a single drive, tablespace design probably isn't going to buy you much in terms of performance. Myself, I would tend to tune the memory buffer cache first in this situation. You may also want to consider adding more drives, depending on how you plan to use this database.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, August 28, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Hi DBA gurus, One of the application is going live .At presenr data is 15GB and will grow more by 10 GB in year time. What is the right approach of tablespace design having more files of smaller size(10 files of 2 GB ) or less file of bigger size (3 files of 8 gb ). No tables in this application is partitioned all the files will be on a single disk I am Orcale 8.1.7 on Win 2K. 2) Following is output of my v$waitstat . Kinly give som suggestions CLASS COUNT TIME ------------------ ---------- ---------- data block 46251 0 sort block 0 0 save undo block 0 0 segment header 15 0 save undo header 0 0 free list 0 0 extent map 0 0 bitmap block 0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header 1225 0 undo block 55 0 Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
