I use oracle 9i in linux.
I have several instance running in it .
How can I check the perormance of the instance is good or bad ??
What subject and how I can check to monitor the performance of these instance ???
Pleae give me more detailed information
Use Oracle statspack (Using Statspack)... The report will show you what the bottlenecks are on your system.
Bottlenecks are most often detected by reviewing the system waits. This is part of the report. You need at least "SELECT_CATALOG_ROLE" or "DBA" role to be able to query the given v$ views
select * from (
select event, wait_class, total_waits waits, time_waited time, round(100 * time_waited / total_time, 2) perc_time from (
sum(time_waited) over () total_time
se.event_id = e.event_id
and e.wait_class != 'Idle'
and e.wait_class != 'Other'
order by perc_time desc
) where rownum <= 10