Re: How to speed up 8i

From: michael ngong <mngong_at_yahoo.com>
Date: 24 Sep 2002 07:50:19 -0700
Message-ID: <ecf365d5.0209240650.2313a572_at_posting.google.com>

"Ognjen Antonic" <ogo_at_ogo.homeip.net> wrote in message news:<YHLj9.2093$EM5.71126_at_news.siol.net>...
> _database_is_fast = true
> _no_of_dbas_needed = 0
>
> :)
>
>
> "Steve" <smontgomerie_at_hotmail.com> wrote in message
> news:156709aa.0209231249.6cd62070_at_posting.google.com...
> > ...waiting for the magic parameter joke
> >
Where do we start here.
You may need to run a couple of database checks Can you tell if everything is exactly the same? The indexes all came over correctly?
There are no outstanding waits?
The same jobs are running?
etc

select d.name file_name
 ,f.phyblkrd blocks_read
 ,f.phyblkwrt blocks_written,
 f.phyblkwrt + f.phyblkrd Total_IOS
 from v$filestat f
 ,v$datafile d
  where d.file#=f.file#
  order by f.phyblkrd+ f.phyblkwrt desc
*This should give you outstanding IO stats

TOTAL WAIT STATS
SELECT event
,total_waits,
time_waited,
(time_waited/total_waittime)*100 pct_total FROM
v$system_event SE,
(SELECT SUM(time_waited) total_waittime
FROM v$system_event
WHERE event NOT IN (

'client message',
'SQL*Net message from client',
'SQL*Net more data from client'

,'rdbms ipc message',

'pipe get',
'Null event',
'pmon timer',
'smon timer',
'parallel query dequeue')) TOT 

WHERE total_waits > 0
 AND time_waited > 1000
AND event NOT IN
('client message','SQL*Net message from client', 'SQL*Net more data from client'

,'rdbms ipc message','pipe get'
,'Null event'
,'pmon timer'
,'smon timer'
,'parallel query dequeue')

ORDER BY pct_total DESC;

DISK SORTS SELECT name, value

              FROM v$sysstat
              WHERE name like '%sort%'; 

I will leave it here you should be able to do a few more tests hopefully that might help
Use my regular email if you clarifications Michael Tubuo Ngong Received on Tue Sep 24 2002 - 16:50:19 CEST