Hi,
From Oracle perspective (since you already have HP-UX perspective):
- check this:
select (bbc.total_waits*100/(cg.value+dbg.value)) "Buff busy ratio ind. < 0,007"
from v$system_event bbc,
v$sysstat cg, v$sysstat dbg
where bbc.event='buffer busy waits'
and cg.name ='consistent gets'
and dbg.name='db block gets'
select round(((1-(sum(decode(name, 'physical reads', value,0)) /
(sum(decode(name,'db block gets', value,0))+
(sum(decode(name, 'consistent gets', value, 0))))))*100),2)
|| '%' "Buffer Cache Hit Ratio > 90%"
from v$sysstat;
- what are your db_block_size, db_block_buffers, log_checkpoint_interval (should be twice redolog size) and log_checkpoint_timeout?
- Use a different tablespace for indexes and tables for each module of the application
- avoid fragmentation of tablespaces:
See the fragmentation in Oracle Tablespace Manager or trought this query:
select file_id, block_id, blocks,
owner||'.'||segment_name "Name"
from sys.dba_extents
where tablespace_name = upper(:p_tablespace_name)
UNION
select file_id, block_id, blocks,
'Free'
from sys.dba_free_space
where tablespace_name = upper(:p_tablespace_name)
order by 1,2,3
Rebuild the highly fragmented indexes:
alter index
. rebuild
storage( initial next ); -- INITIAL_SIZE and NEXT_SIZE can be 8M or 8K for example
PS: if you don't have Online JFS use options delaylog, nodatainlog for data logical volumes and delaylog,datainlog for binaries.
Best Regards,
Eric Antunes
Each and every day is a good day to learn.
