| How do I justify using different disks (2 merged) [message #481383] |
Tue, 02 November 2010 21:44  |
kytemanaic
Messages: 55
Registered: February 2009
|
Member |
|
|
I have run AWR i,e. ?rdbms/admin/awrrpt.sql from 0800 to 1700,
and based on metalink 842884.1,
Quote:
Av Rd(ms) [Average Reads in milliseconds] should not cross beyond 30,
the following tablespaces have failed Tablespace I/O suggested threshold i,e, the Av Rd(ms) of the respective tablespaces have cross the 30 ms more than once
TEMP 2 occurances
RMAN 4 occurances
USERS 4 occurances
DATA_TABLESPACEB 3 occurances
DATA_INDEXSPACE 1 occurance
DATA_TABLESPACEA 1 occurance
RMAN 6 occurances
USERS 6 occurances
from http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm, it suggest the following
Quote:
Using Multiple Tablespaces
Using multiple tablespaces allows you more flexibility in performing database operations. When a database has multiple tablespaces, you can:
Separate user data from data dictionary data to reduce I/O contention.
Separate data of one application from the data of another to prevent multiple applications from being affected if a tablespace must be taken offline.
Store different the datafiles of different tablespaces on different disk drives to reduce I/O contention.
Take individual tablespaces offline while others remain online, providing better overall availability.
Optimizing tablespace use by reserving a tablespace for a particular type of database use, such as high update activity, read-only activity, or temporary segment storage.
Back up individual tablespaces.
first thing first, am I analysing the AWR wrongly?
if I am not analysing wrongly, is my suggested solution of using different disk to store different files correct?
If more need to be pump in, I would gladly provide.
thanks
|
|
|
|
|
|
| Re: How do I justify using different disks [message #481398 is a reply to message #481386] |
Wed, 03 November 2010 02:22  |
kytemanaic
Messages: 55
Registered: February 2009
|
Member |
|
|
Quote:
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\SUPERB\SUPERB_INDX_01.DBF
E:\ORA102\PROD\SUPERB\SUPERB_02.DBF
E:\ORA102\PROD\SUPERB\SUPERB_03.DBF
E:\ORA102\PROD\SUPERB\SUPERB_04.DBF
E:\ORA102\PROD\SUPERB\SUPERB_05.DBF
E:\ORA102\PROD\SUPERB\SUPERB_06.DBF
E:\ORA102\PROD\SUPERB\SUPERB_07.DBF
E:\ORA102\PROD\SUPERB\SUPERB_01.DBF
E:\ORA102\PROD\USERS01.DBF
E:\ORA102\PROD\SYSTEM01.DBF
E:\ORA102\PROD\SYSAUX01.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\RMAN01.DBF
E:\ORA102\PROD\VISIONAEL\DATAA01.DBF
E:\ORA102\PROD\VISIONAEL\DATAA02.DBF
E:\ORA102\PROD\VISIONAEL\DATAB01.DBF
E:\ORA102\PROD\VISIONAEL\DATAB02.DBF
E:\ORA102\PROD\VISIONAEL\DATA_IS01.DBF
E:\ORA102\PROD\VISIONAEL\DATA_IS02.DBF
E:\ORA102\PROD\VISIONAEL\DATA_IS03.DBF
E:\ORA102\PROD\VISIONAEL\DATA_IS04.DBF
E:\ORA102\PROD\NGWEBCC01.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_01.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_02.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_03.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_04.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_05.DBF
E:\ORA102\PROD\GISOPNT\GISOPNT_01.DBF
E:\ORA102\PROD\SUPERB\SUPERB_08.DBF
E:\ORA102\PROD\SUPERB\SUPERB_09.DBF
E:\ORA102\PROD\SUPERB\SUPERB_10.DBF
E:\ORA102\PROD\WORKFLOW01.DBF
E:\ORA102\PROD\SYSTEM01_2.DBF
E:\ORA102\PROD\SUPERB\SUPERB_11.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\UNDOTBS03_PROD.DBF
E:\ORA102\PROD\SUPERB\SUPERB_12.DBF
E:\ORA102\PROD\UNDOTBS04_PROD.DBF
E:\ORA102\PROD\SUPERB\SUPERB_13.DBF
E:\ORA102\PROD\SUPERB\SUPERB_14.DBF
E:\ORA102\PROD\SUPERB\SUPERB_15.DBF
E:\ORA102\PROD\SUPERB\SUPERB_16.DBF
E:\ORA102\PROD\SYSAUX01_2.DBF
E:\ORA102\PROD\SYSAUX01_3.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_06.DBF
E:\ORA102\PROD\UNDOTBS05_PROD.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\UNDOTBS06_PROD.DBF
E:\ORA102\PROD\SUPERB\SUPERB_17.DBF
E:\ORA102\PROD\SUPERB\SUPERB_18.DBF
E:\ORA102\PROD\NRS\NRS_01.DBF
E:\ORA102\PROD\NRS\NRS_02.DBF
E:\ORA102\PROD\NRS\NRS_03.DBF
E:\ORA102\PROD\NRS\NRS_04.DBF
E:\ORA102\PROD\NRS\NRS_05.DBF
E:\ORA102\PROD\NRS\NRS_06.DBF
E:\ORA102\PROD\NRS\NRS_07.DBF
E:\ORA102\PROD\NRS\NRS_08.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\NRS\NRS_09.DBF
E:\ORA102\PROD\NRS\NRS_10.DBF
E:\ORA102\PROD\NRS\NRS_11.DBF
E:\ORA102\PROD\NRS\NRS_12.DBF
E:\ORA102\PROD\NRS\NRS_13.DBF
E:\ORA102\PROD\NRS\NRS_14.DBF
E:\ORA102\PROD\NRS\NRS_15.DBF
E:\ORA102\PROD\NRS\NRS_16.DBF
E:\ORA102\PROD\NRS\NRS_17.DBF
E:\ORA102\PROD\NRS\NRS_18.DBF
E:\ORA102\PROD\NRS\NRS_19.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\NRS\NRS_20.DBF
E:\ORA102\PROD\NRS\NRS_21.DBF
E:\ORA102\PROD\NRS\NRS_22.DBF
E:\ORA102\PROD\NRS\NRS_23.DBF
E:\ORA102\PROD\NRS\NRS_24.DBF
E:\ORA102\PROD\NRS\NRS_25.DBF
E:\ORA102\PROD\NRS\NRS_26.DBF
E:\ORA102\PROD\NRS\NRS_27.DBF
E:\ORA102\PROD\NRS\NRS_28.DBF
E:\ORA102\PROD\NRS\NRS_29.DBF
E:\ORA102\PROD\NRS\NRS_30.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_07.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_08.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_09.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_10.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_11.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_12.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_13.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_14.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_15.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_16.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_17.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_18.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_19.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_20.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_21.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_22.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_23.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_24.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_25.DBF
E:\ORA102\PROD\SUPERB\SUPERB_19.DBF
E:\ORA102\PROD\UNDOTBS01_PROD.DBF
E:\ORA102\PROD\UNDOTBS02_PROD.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\SUPERB\SUPERB_20.DBF
E:\ORA102\PROD\SUPERB\SUPERB_21.DBF
E:\ORA102\PROD\SUPERB\SUPERB_22.DBF
E:\ORA102\PROD\SUPERB\SUPERB_23.DBF
E:\ORA102\PROD\SUPERB\SUPERB_24.DBF
E:\ORA102\PROD\SUPERB\SUPERB_25.DBF
E:\ORA102\PROD\SUPERB\SUPERB_26.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_02.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_03.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_04.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_05.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\SUPERB\SUPERB_INDX_06.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_07.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_08.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_09.DBF
E:\ORA102\PROD\SUPERB\SUPERB_INDX_10.DBF
E:\ORA102\PROD\SUPERBNEW\SUPERBNEW_01.DBF
E:\ORA102\PROD\SUPERBNEW\SUPERBNEW_02.DBF
E:\ORA102\PROD\SUPERBNEW\SUPERBNEW_INDX_01.DBF
E:\ORA102\PROD\GISOPNT\GISOPNT_02.DBF
E:\ORA102\PROD\GISOPNT\GISOPNT_03.DBF
E:\ORA102\PROD\GISOPNT\GISOPNT_04.DBF
FILE_NAME
--------------------------------------------------------------------------------
E:\ORA102\PROD\UNDOTBS07_PROD.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_26.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_27.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_28.DBF
E:\ORA102\PROD\GRIDMIG\GRIDS_DATA_29.DBF
E:\ORA102\PROD\PERFSTAT_01.DBF
E:\ORA102\PROD\PERFSTAT_02.DBF
E:\ORA102\PROD\PERFSTAT_03.DBF
E:\ORA102\PROD\PERFSTAT_04.DBF
E:\ORA102\PROD\PERFSTAT_05.DBF
sorry din mentioned that My OS is windows 32 bit and rdbms is oracle 10gr2.
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
