Never use this reserved word ( current_date ) when you define a column .
If you do so , you will end up in unexpected behavior : when you will select from the table, you will get always the current date , not the data which is actual in the table .
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