When you enable direct IO for an oracle database ( filesystemio_options = directio or filesystemio_options = setall ) , you may encounter this error in alert.log , when opening the database .
Cannot re-create tempfile the same name file exists
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 5 zile
Niciun comentariu:
Trimiteți un comentariu