For your first question, you should check what is
running in your database. If what you said is correct,
you may be running a few large queries doing sorting,
joining a bunch of tables. Try 'top' and check what
are the top sessions consuming all the cpu time.

for your second question, I'm sorry I can't help.

benny

--- Alfee Chow <[Email Address Removed] wrote:
>
>
> Mateys,
>
> I get a Sun machine running Oracle 9.2.0.1.0 on
> SunOS 5.9 Generic 112233-02
> August 2002 with 4 CPUs.
>
> However, all CPU is busy all the time. Ideal is Zero
> !!! And the CPU spends
> about 35% time in doing system job instead of Oracle
> job (users). Is that
> normal ??? I don't think so. Anything I can tune or
> investigate this problem
> ???
>
> oracle => iostat 3
> tty sd0 sd1 sd6
> sd45 cpu
> tin tout kps tps serv kps tps serv kps tps serv
> kps tps serv us sy wt
> id
> 0 8 114 4 14 112 3 14 0 0 0
> 0 0 0 3 2 3
> 92
> 0 78 1 0 4 0 0 0 0 0 0
> 0 0 0 63 36 0
> 0
> 0 1518 0 0 0 11 1 5 0 0 0
> 0 0 0 63 36 0
> 1
> 0 27 4 1 5 3 1 7 0 0 0
> 0 0 0 65 35 0
> 0
> 0 53 0 0 0 0 0 0 0 0 0
> 0 0 0 69 30 0
> 1
> 0 53 0 0 0 0 0 0 0 0 0
> 0 0 0 66 34 0
> 0
> 0 27 0 0 0 0 0 0 0 0 0
> 0 0 0 62 38 0
> 0
>
> Could you please help to to recover my UNDO
> Tablespace
> datafile for my DB which is running in NOARCHIVELOG
> mode?
>
> Thanks
> Sami
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> http://platinum.yahoo.com
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Oracle LazyDBA home page