Smon kicks in every 5 minutes to query ts$ to check
if any dictionary-managed tablespaces have pctincrease
non-zero, and then tries to coalesce them. THere are several
other jobs that smon does which are also visible as standard
SQL querying, and therefore require normal database read
requests.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"Michael J. Moore" <NOhicamelSPAM_at_comcast.net> wrote in message
news:ez9Fb.446468$275.1320599_at_attbi_s53...
> --- snip---
>
>
> > >
> > > SMON performs instance recovery, so it must read from redo logs. The
> manuals
> > > I have read are not clear on how SMON does this, but if it does read,
> then
> > > that counts as I/O, right? SMON also cleans up temporary segments anc
> > > coalesces free extents. Can it do this without performing I/O?
> >
> > SMON might to I/O at instance startup; also to the rollback segments for
> > uncommitted "transactions" (which I'll stipulate is an oxymoron).
> >
> > I agree that the OCP test questions leave a lot to be desired.
> >
>
> Well you did straighten me out about CKPT ... thanks. It is interesting
that
> even in the Oracle manuals, their diagrams never show SMON pointing to any
> of the files, only pointing to the SGA. This leaves me wondering if SMON
> actually performs it's own I/O or invokes some other process to do it's
> dirty work. I wish they would give a little more detail.
>
>
>
Received on Sun Dec 21 2003 - 12:29:59 CST
