Re: SMON Coalesce Frequency on ORACLE 7.1

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/01/07
Message-ID: <68vmic$t1k$1@hermes.is.co.za>#1/1

arpege wrote in message <34B3386E.21F0_at_imaginet.fr>...
>I've read that SMON wakes up every 5 minutes in order to coalesce
>contigous free space on ORACLE 7.1 . Is is possible to define this
>frequency and how ?

Undocumented/unsupported:
(in server manager)

ORADEBUG WAKEUP <orapid>

where <orapid> is the process id of PMON. Try the following SQL statement to get the Oracle process id:
SELECT

  s.sid "Session ID",
  p.spid "UNIX PID",
  p.pid "Oracle PID",
  s.program

FROM v$process p, v$session s
WHERE p.addr = s.paddr
AND s.program LIKE '%PMON%'

And please let us know if this works or not... :-)

regards,
Billy Received on Wed Jan 07 1998 - 00:00:00 CST