| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: my initial storage division for SAN
rahul sharma,
hi, one question, 300GB to place archivelogs from a&b, they should be seperated , right? unless you use cluster filesystem, you cannot let the two node mount the same volume, right? and maybe SAME rule works for you, consider it.And whether your system is write intensive, you can check it like:
13:08:50 perfstat_at_BIDDB.EACHNET.COM> @readwrite
Total buffer
1.6515E+10
Elapsed: 00:00:00.48 old 2: :totalcost := &totalcost; new 2: :totalcost := 1.6515E+10;
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
total execution
1218693220
Elapsed: 00:00:00.29 old 2: :totalexec :=&totalexec; new 2: :totalexec :=1218693220;
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.02
SQL_TYPE Total buffer total execution average Cost 成本比率 执行比率 ---------- ------------- --------------- ------------ ---------- ----------
BEGIN 2848457875 232752041 12.238165 17.24 19.09 DECLA 218094451 6762742 32.2494117 1.32 .55 DELET 47111763 1617433 29.1274897 .28 .13 INSER 320604425 41939893 7.64437871 1.94 3.44 SELEC 1.2343E+10 880118415 14.0239731 74.73 72.21 UPDAT 737797721 55448104 13.3060947 4.46 4.54 column totalcost heading "Total buffer " new_value totalcost select sum(buffer_gets) totalcost from v$sql; variable totalcost number; begin :totalcost := &totalcost;
col totalexec heading "total execution" new_value totalexec
select sum(executions) totalexec from v$sql;
variable totalexec number;
begin
:totalexec :=&totalexec;
end;
/
select upper(substr(sql_text,1,5)) SQL_TYPE,sum(buffer_gets) TotalCost ,sum(executions) TotalExec
,sum(buffer_gets)/sum(executions) "average Cost",
trunc(Sum(buffer_gets)/(:totalcost),4)*100 "成本比率",
Trunc(sum(executions)/(:totalexec),4)*100 "执行比率"
from v$sql
group by upper(substr(sql_text,1,5))
having sum(buffer_gets)>100000;
Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org(China Oracle User Group)
>we are in a process of migratin our instances to SAN, i have been given the >task of >dividing the SAN storage :-(( > >here are my initial setup, we have been given a 1TB box ... please let me >know if i am missing something > >(two instances A & B) > - 36GB x 2 for redo logs 3 groups of two members each 500M size, >multiplexed instance A > - 36GB x 2 for redo logs 3 groups of two members each 500M size, >multiplexed instance B >- 300GB to hold archive logs from A & B , mirrored >- 36GB drive for TEMP A & B > >the rest of the storage will be divided into DATA and INDEX for A & B , my >question is.. should we make >RAID5 for data and index ?? or individual drives ? we know the IO patterns >for all the tablespaces, ideally the write intensive tbs should be RAID(1+0) >, but we might not have enough space if we do that. !! (have i answerd all >my questions ??? ;-)) > >i would appreciate any comments from you guys who have DB's running on SAN. > >TIA > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: rahul sharma > INET: rahul_at_infotech.co.id > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: chao_ping_at_vip.163.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Mon Apr 28 2003 - 01:06:37 CDT
 |
 |