Oracle Scripts

Oracle Database Documentation Oracle Enterprise Manager

About

Contact Us

Privacy Statement

May 28, 2019 · 0 min read ·

Share on:

OracleScripts.com

Your Source for Oracle SQL Scripts

Series

ORACLE RMAN 24 ORACLE BACKUP DATA GUARD 15 ORACLE ADMINISTRATION UNIX 14 ORACLE PERFORMANCE AWR 13 ORACLE ADMINISTRATION RAC 12 ORACLE ADMINISTRATION SESSION 11 ORACLE STRUCTURE FILES 11 ORACLE STRUCTURE OBJECTS 11 ORACLE STRUCTURE TABLESPACE 11 ORACLE BACKUP FLASHBACK 10 ORACLE PERFORMANCE WAITS 10 ORACLE ADMINISTRATION STATUS 9 ORACLE PERFORMANCE GENERAL 9 ORACLE ADMINISTRATION ASM 8

All Series

[A~Z][0~9]

Tags

ORACLE 137 DATABASE ADMINISTRATION 56 DATABASE 51 ORACLE DATABASE 50 ORACLE DBA 48 SQL 46 DBA 38 ADMINISTRATION 32 PERFORMANCE 28 V$SESSION 28 PERFORMANCE TUNING 25 ORACLE ADMINISTRATION 22 RMAN 19 TROUBLESHOOTING 18

All Tags

$DATAFILE1 10046 TRACE1 ACCOUNT1 ACTIVE SESSION HISTORY1 ADMIN1 ADMIN GUIDE2 ADMIN SCRIPTS1 ADMINISTRATION32 ADR1 ADVISOR FRAMEWORK1 AIX1 ALERT LOG2 ALL_CONSTRAINTS2 ALL_DIRECTORIES2 ALL_ERRORS1 ALL_IND_COLUMNS1 ALL_OBJECTS1 ALL_PLSQL_OBJECT_SETTINGS1 ALL_SCHEDULER_RUNNING_JOBS1 ALL_TAB_COLUMNS1 ALL_USERS1 ALTER DATABASE1 ALTER INDEX1 ALTER SESSION1 ALTER SYSTEM4 ANALYZE1 APROPOS1 ARCH PROCESS1 ARCHIVE1 ARCHIVE LOG1 ARCHIVE LOGS7 ARCHIVED REDO LOGS1 ARCHIVELOG1 ARCHIVELOG MANAGEMENT1 ASH REPORTS1 ASH SAMPLING1 ASM3 ASM DISK UTILIZATION1 AUDIT FILES1 AUTOMATIC DIAGNOSTIC REPOSITORY1 AUTOMATION1 AUTOTRACE1 AWR10 AWR ANALYSIS1 AWR RETENTION1 BACKGROUND PROCESSES1 BACKUP6 BACKUP AND RECOVERY4 BACKUP AND RESTORE1 BACKUP AUDITING1 BACKUP JOB MONITORING1 BACKUP MAINTENANCE1 BACKUP MANAGEMENT5 BACKUP RECOVERY6 BACKUP REPOSITORY1 BACKUP RETENTION1 BACKUP STRATEGY2 BACKUP VALIDATION2 BACKUP VERIFICATION3 BACKUP-COMMANDS1 BASELINE MANAGEMENT3 BUFFER CACHE1 CACHE FLUSHING1 CHARACTER-SET1 CLUSTER5 CLUSTER MANAGEMENT1 CLUSTERWARE1 COMMAND LINE1 COMPRESSION2 CONNECTED-USERS3 CONSISTENT EXPORT1 CONSTRAINTS3 CORRUPTION DETECTION1 CPIO1 CREATE_JOB1 CTAS1 CURSOR CACHE1 DATA DICTIONARY1 DATA DICTIONARY VIEWS1 DATA GUARD14 DATA INTEGRITY3 DATA RECOVERY1 DATA-MANAGEMENT7 DATA-PROTECTION1 DATA-PUMP4 DATABASE51 DATABASE ADMINISTRATION56 DATABASE BACKUP15 DATABASE CLEANUP1 DATABASE CONNECTIVITY2 DATABASE FILES1 DATABASE MAINTENANCE6 DATABASE MANAGEMENT3 DATABASE MIGRATION1 DATABASE MONITORING9 DATABASE OPTIMIZATION2 DATABASE PERFORMANCE1 DATABASE PROGRAMMING1 DATABASE RECOVERY11 DATABASE REGISTRATION1 DATABASE SIZE1 DATABASE START-UP1 DATABASE TUNING2 DATABASE USAGE1 DATABASE_PROPERTIES1 DATAFILE MANAGEMENT1 DATAFILES5 DATAPUMP3 DBA38 DBA COMMANDS4 DBA SCRIPTS9 DBA TASKS2 DBA TOOLS5 DBA_ADVISOR_ACTIONS1 DBA_ADVISOR_FINDINGS1 DBA_ADVISOR_RECOMMENDATIONS1 DBA_ADVISOR_TASKS1 DBA_ALL_TABLES1 DBA_AUTOTASK_CLIENT1 DBA_AUTOTASK_WINDOW_CLIENTS1 DBA_CONS_COLUMNS2 DBA_CONSTRAINTS7 DBA_DATA_FILES8 DBA_DATAPUMP_JOBS2 DBA_DEPENDENCIES1 DBA_DIRECTORIES3 DBA_ERRORS2 DBA_EXTENTS2 DBA_FEATURE_USAGE_STATISTICS2 DBA_FREE_SPACE6 DBA_HIGH_WATER_MARK_STATISTICS1 DBA_HIST_ACTIVE_SESS_HISTORY2 DBA_HIST_BASELINE3 DBA_HIST_FILESTATXS1 DBA_HIST_REPORTS1 DBA_HIST_SERVICE_STAT1 DBA_HIST_SERVICE_WAIT_CLASS1 DBA_HIST_SNAPSHOT4 DBA_HIST_SQLBIND1 DBA_HIST_SQLSTAT1 DBA_HIST_TABLESPACE_STAT1 DBA_HIST_WR_CONTROL4 DBA_IND_COLUMNS1 DBA_IND_EXPRESSIONS1 DBA_IND_STATISTICS1 DBA_INDEXES4 DBA_JOBS2 DBA_LOBS1 DBA_LOCK1 DBA_OBJECTS8 DBA_OPTSTAT_OPERATIONS1 DBA_PROFILES1 DBA_RECYCLEBIN2 DBA_RESUMABLE2 DBA_ROLE_PRIVS3 DBA_ROLES2 DBA_ROLLBACK_SEGS2 DBA_SCHEDULER_JOB_RUN_DETAILS2 DBA_SCHEDULER_JOBS2 DBA_SCHEDULER_RUNNING_JOBS1 DBA_SEGMENTS11 DBA_SOURCE1 DBA_TAB_COL_STATISTICS1 DBA_TAB_COLUMNS1 DBA_TAB_MODIFICATIONS1 DBA_TAB_PRIVS2 DBA_TAB_STATISTICS1 DBA_TABLES4 DBA_TABLESPACES6 DBA_TEMP_FILES4 DBA_TEMP_FREE_SPACE1 DBA_TS_QUOTAS2 DBA_UNDO_EXTENTS1 DBA_USERS4 DBA-RESUMABLE1 DBMS SCHEDULER1 DBMS WORKLOAD REPOSITORY1 DBMS_AUTO_TASK_ADMIN1 DBMS_FLASHBACK4 DBMS_JOB2 DBMS_METADATA1 DBMS_MONITOR1 DBMS_OUTPUT3 DBMS_RCVCAT1 DBMS_REDEFINITION1 DBMS_RESUMABLE1 DBMS_ROWID1 DBMS_SCHEDULER4 DBMS_SHARED_POOL1 DBMS_SPACE1 DBMS_SQL_MONITOR1 DBMS_STATS6 DBMS_STATS.GATHER_DATABASE_STATS1 DBMS_STATS.GATHER_SCHEMA_STATS1 DBMS_SYSTEM1 DBMS_UTILITY1 DBMS_WARNING1 DBMS_WORKLOAD_REPOSITORY7 DBMS_XPLAN3 DDL1 DIAGNOSTIC DATA1 DIAGNOSTIC DEST1 DIAGNOSTIC_DEST1 DIAGNOSTICS2 DIRECTORY1 DIRECTORY OBJECT2 DISASTER RECOVERY1 DISCONNECT SESSION1 DISK GROUP CREATION1 DISK INFORMATION5 DISK MANAGEMENT1 DISK SPACE ANALYSIS1 DISKGROUP4 DISPLAY_CURSOR1 DOCUMENTATION1 DROPPED OBJECTS1 DYNAMIC PARAMETERS1 DYNAMIC PERFORMANCE VIEWS3 EDITOR1 ERROR DIAGNOSTICS1 ERROR RESOLUTION1 EXECUTION PLAN1 EXECUTION PLANS2 EXP UTILITY1 EXPDP5 EXPLAIN-PLAN2 EXPORT3 EXPORT-IMPORT1 EXTERNAL REDUNDANCY1 EXTPROC1 FAILED JOBS1 FAL1 FAST RECOVERY AREA2 FEATURES1 FILE HANDLES1 FILE IO1 FILESYSTEM1 FIND2 FINISH_REDEF_TABLE1 FLASHBACK7 FLASHBACK QUERY1 FLASHBACK TABLE1 FLASHBACK_TIME1 FLUSH BUFFER_CACHE1 FLUSH SHARED_POOL1 FOREIGN KEY1 FRA1 FREE SPACE1 GAP RESOLUTION1 GATHER_PLAN_STATISTICS1 GATHER_SYSTEM_STATS1 GREP2 GV$DIAG_INFO1 GV$FLASHBACK_DATABASE_LOG1 GV$FLASHBACK_DATABASE_LOGFILE1 GV$FLASHBACK_DATABASE_STAT1 HASH1 HIGH AVAILABILITY5 HOT-BACKUP2 HP-UX1 IMPDP3 IMPORT2 IMPORT-EXPORT1 INCOMPLETE RECOVERY1 INDEX1 INDEX COALESCE1 INDEX MAINTENANCE1 INDEX REBUILD1 INDEXES1 INDEXING1 INIT.ORA1 INSERT APPEND1 INSTALLATION1 INSTALLED3 INSTANCE TUNING1 IO1 JAVA1 JOB MONITORING1 JOB RUN HISTORY1 JOB SCHEDULING2 KILL SESSION1 KSH2 LAST-ACTIVITY1 LATCH1 LATCH CONTENTION1 LEGACY EXPORT1 LINUX1 LINUX FOR DBAS1 LISTENER1 LISTENER.ORA2 LOG MANAGEMENT1 LOG SWITCH FREQUENCY1 LOGICAL BACKUP2 LOGICAL STANDBY1 LS DU COMMANDS1 LSOF1 MAINTENANCE1 MAINTENANCE TASKS1 MAN1 MANAGEMENT8 MANAGING9 MATERIALIZED VIEW LOGS1 MEMORY1 MEMORY MANAGEMENT2 MEMORY TUNING1 MIGRATION1 MKNOD1 MODIFY1 MONITORING12 MONITORING SCRIPTS1 MOVE DATAFILE1 MRP1 NAMED PIPE1 NETSTAT1 NETWORKING1 NLS_DATABASE_PARAMETERS1 OBJ$1 OBJECTS6 OIFCFG1 OMF1 ONLINE DATAFILE MOVE1 ONLINE TABLE REDEFINITION1 OPATCH1 OPTIMIZATION15 OPTIMIZER STATISTICS1 ORA-000311 ORACHECK1 ORACLE137 ORACLE 12C1 ORACLE ADMINISTRATION22 ORACLE ADMINISTRATION JOBS1 ORACLE ASM6 ORACLE BACKUP4 ORACLE BROKER1 ORACLE CLUSTERWARE11 ORACLE COMMANDS1 ORACLE CRS8 ORACLE DATABASE50 ORACLE DBA48 ORACLE DBA SCRIPTS4 ORACLE INSTANCE MANAGEMENT1 ORACLE MONITORING1 ORACLE NET3 ORACLE PERFORMANCE10 ORACLE RMAN3 ORACLE RMAN REPORTING1 ORACLE SCHEDULER3 ORACLE SCRIPTS6 ORACLE STRUCTURE1 ORACLE TUNING1 ORACLE VIEWS2 ORACLE-ADMIN2 ORACLE-EXPORT2 ORADEBUG1 OSUSER1 PARALLEL SQL EXECUTION1 PARAMETERS2 PARFILE1 PASSWORD FILE1 PATCHING1 PEFORMANCE1 PERFORMANCE28 PERFORMANCE ANALYSIS3 PERFORMANCE DIAGNOSTICS1 PERFORMANCE OPTIMIZATION3 PERFORMANCE TUNING25 PERFORMANCE-MONITORING7 PGA2 PHYSICAL STANDBY1 PL SQL1 PL/SQL1 PLSQL9 POINT IN TIME RECOVERY4 PRIMARY DATABASE2 PRIMARY KEY1 PRIVILEGES1 PROCEDURE1 PROCESS DIAGNOSTICS1 PURGE STATEMENT1 QUERY1 QUERY ANALYSIS1 QUERY OPTIMIZATION3 QUERY-TUNING2 QUOTAS1 RAC8 RC_BACKUP_SET1 RC_DATABASE1 READ CONSISTENCY1 REAL-TIME MONITORING1 RECOVERY5 RECOVERY CATALOG5 RECOVERY MANAGER10 RECYCLE BIN1 REDO LOG1 REDO LOG INTERNALS1 REDO LOG SIZING1 REDO LOGS1 REDO TRANSPORT1 REPLICATION1 RESETLOGS1 RESOURCE OPTIMIZATION2 RESUMABLE SPACE ALLOCATION1 RETENTION POLICY3 RMAN19 RMAN BACKUP HISTORY1 RMAN COMMANDS1 RMAN REPORTING1 ROLE PRIVILEGES1 ROLE_ROLE_PRIVS1 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 ROUTING DIAGNOSTICS1 RUN_DURATION1 SCHEDULER JOB MONITORING1 SCHEMA EXPORT2 SCHEMA SPACE USED1 SCHEMA_EXPORT_OBJECTS1 SCN1 SCRIPTING1 SCRIPTS6 SECURITY1 SECURITY AUDIT1 SEGMENT ADVISOR1 SEGMENTS2 SEQUENCE NUMBERS1 SESSION ANALYSIS2 SESSION MANAGEMENT1 SESSION MONITORING1 SESSION TERMINATION1 SESSION_ROLES1 SESSION-PID1 SESSIONS1 SESSIONS-SORTED1 SGA1 SHARED POOL2 SHELL4 SHELL-SCRIPTING2 SHOW1 SHOW ROLES1 SHOW_TABLE_ROLE_PRIVILEGES1 SHOW-USER-SQL4 SNAPSHOT MANAGEMENT4 SNAPSHOTS1 SOLARIS1 SPACE MANAGEMENT5 SPACE USAGE1 SPACE USED1 SPFILE1 SQL46 SQL APPLY1 SQL COMMANDS5 SQL MONITORING1 SQL OPTIMIZATION1 SQL PERFORMANCE2 SQL PLUS1 SQL QUERIES3 SQL QUERY3 SQL SCRIPTS8 SQL STATISTICS1 SQL TRACE1 SQL TUNING1 SQL TUTORIAL1 SQL*NET2 SQL*PLUS3 SRVCTL3 STANDBY DATABASE7 STANDBY LOGS1 START3 START_REDEF_TABLE1 START-UP TIME1 STATISTICS3 STATISTICS GATHERING1 STATISTICS MANAGEMENT2 STATSPACK7 STOP3 STORAGE3 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT10 STORAGE OPTIMIZATION1 STORAGE REPORTING1 STORED PROCEDURES1 SYSTEM PERFORMANCE1 TABLE1 TABLE COMPRESSION1 TABLE REORGANIZATION1 TABLESPACE7 TABLESPACE MANAGEMENT1 TABLESPACE MONITORING1 TABLESPACE USAGE1 TEMP1 TEMPORARY TABLESPACE1 TERMINAL1 TEXT EDITING1 TEXT EDITOR1 TIME MODEL STATISTICS1 TNS1 TNSNAMES.ORA2 TRACE FILE1 TRACE FILES3 TRACING2 TRANSACTIONS1 TROUBLESHOOTING18 TUNING7 UNDO1 UNDO MANAGEMENT1 UNDO RETENTION1 UNDO_RETENTION1 UNIFIED_AUDIT_TRAIL1 UNIX2 UNIX COMMANDS13 USAGE2 USED SPACE1 USER3 USER SPACE1 USER_ADVISOR_FINDINGS1 USER_ALL_TABLES1 USER_CONSTRAINTS1 USER_ERRORS1 USER_IND_COLUMNS1 USER_OBJECTS1 USER_RECYCLEBIN1 USER_ROLE_PRIVS1 USER$1 USERS2 UTL_FILE1 UTL_RECOMP1 V$ DYNAMIC VIEWS2 V$ACTIVE_SESSION_HISTORY5 V$ARCHIVE_DEST4 V$ARCHIVE_DEST_STATUS3 V$ARCHIVE_GAP1 V$ARCHIVE_PROCESSES1 V$ARCHIVED_LOG5 V$ASM_DISK3 V$ASM_DISK_STAT2 V$ASM_DISKGROUP2 V$ASM_FILE2 V$ASM_OPERATION3 V$BACKUP1 V$BACKUP_DATAFILE1 V$BACKUP_PIECE1 V$BACKUP_REDOLOG1 V$BACKUP_SET1 V$CONTROLFILE3 V$DATABASE9 V$DATABASE_BLOCK_CORRUPTION1 V$DATAFILE13 V$DATAGUARD_PROCESS1 V$DATAGUARD_STATS2 V$DB_CACHE_ADVICE1 V$DB_OBJECT_CACHE1 V$DIAG_ALERT_EXT1 V$DIAG_INFO2 V$FILESTAT2 V$FLASH_RECOVERY_AREA_USAGE1 V$FLASHBACK_DATABASE_LOG2 V$FLASHBACK_DATABASE_LOGFILE1 V$FLASHBACK_DATABASE_STAT1 V$INSTANCE1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG7 V$LOG_HISTORY2 V$LOGFILE6 V$MANAGED_STANDBY4 V$PARAMETER4 V$PGA_TARGET_ADVICE1 V$PGASTAT1 V$PROCESS4 V$RECOVERY_AREA_USAGE1 V$RECOVERY_FILE_DEST1 V$RMAN_BACKUP_JOB_DETAILS1 V$RMAN_OUTPUT1 V$SEGMENT_STATISTICS2 V$SESS_TIME_MODEL1 V$SESSION28 V$SESSION_LONGOPS3 V$SESSION_WAIT5 V$SESSTAT3 V$SGASTAT2 V$SORT_USAGE1 V$SQL4 V$SQL_MONITOR1 V$SQL_PLAN2 V$SQL_PLAN_MONITOR1 V$SQL_WORKAREA1 V$SQL_WORKAREA_HISTOGRAM1 V$SQLAREA9 V$STANDBY_LOG1 V$STATNAME4 V$SYS_TIME_MODEL1 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE3 V$TEMPSEG_USAGE1 V$TRANSACTION2 V$UNDOSTAT3 V$VERSION1 V$WAITSTAT1 VDATAFILE2 VI3 WAIT CLASS1 WAIT EVENTS1 WORKLOAD REPOSITORY3 X$ FIXED TABLES1 X$BH1 X$KCBFWAIT1 X$KCBFWAITV1 X$KCCCP1

[A~Z][0~9]