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] subscribe: send a blank email to oracledba-[Email Address Removed] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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 LazyDBA home page