Sfat : upgrade la 10.2.0.4
Metalink note id : 361680.1
Cause
Bug.4930777/4612267 SQLPLUS HANGS ON MACHINES WITH LARGE UPTIME -- EVEN SQLPLUS HANGS
which says it happens when machine is up for more than 248 days.
Checked in truss output and uptime output exactly maching these symtoms...
Solution
To implement the solution, please execute the following steps:
1.Download one off patch from metalink for bug 4612267 ( 10.2.0.1 )
2. apply patch and rerun sqlplus.
OR
Reboot Server
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history
with 1-minute granularity
-
Here are two scripts for showing GV$SYSMETRIC_HISTORY contents in a simple
tabular way: vstat.sql - show up to one hour of current history at 1-minute
gran...
Acum 6 zile
Niciun comentariu:
Trimiteți un comentariu