-
编辑 删除
记录数据库所有ddl操作
NAME TYPE VALUE------------------------------------ ----------- ------------------------------enable_ddl_logging boolean FALSE通过ash查询历史执行sql：V$ACTIVE_SESSION_HISTORYDBA_HIST_SQLTEXTselect s.*,b.SQL_TEXT from (select a.SAMPLE_TIME,a.sql_id &nb...
-
编辑 删除
ora 脚本
#!/bin/bashif [ "$LOGNAME" = "oracle" ]; then SQLPLUS_CMD="/ as sysdba";else SQLPLUS_CMD="/ as sysdba";ficase $1 in si) if [ "$LOGNAME" = "oracle" ]; then sqlplus "/ as sysdba" ...
-
编辑 删除
ora 脚本
#!/bin/bashif [ "$LOGNAME" = "oracle" ]; then SQLPLUS_CMD="/ as sysdba";else SQLPLUS_CMD="/ as sysdba";ficase $1 in si) if [ "$LOGNAME" = "oracle" ]; then sqlplus "/ as sysdba" ...
-
编辑 删除
How to Resize a Datafile (文档 ID 1029252.6)
In this DocumentPurposeScopeDetails =============================1. Increase Datafile Size============================= ...
-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
-
编辑 删除
vim-Filter commands
vim ! Filter commands
