All Oracle Scripts

Scripts & Commands

Oracle Database Documentation Oracle Enterprise Manager

Privacy Statement

Categories

Oracle Performance Statspack
Jan 1, 0001 · 0 min read ·
Share on:

Read More
- 1
- 2
- 3
- 4

OracleScripts.com

Your Source for Oracle SQL Scripts

Recent Posts

Insert Control Characters in vi with Ctrl-V for Oracle Prompts
Check RESUMABLE_TIMEOUT and RESUMABLE Status in V$SESSION
Monitor PGA Aggregate Target with V$PGASTAT in Oracle
Oracle Scheduler Job Monitoring with DBA_SCHEDULER_RUNNING_JOBS
Oracle DBMS_SCHEDULER: Create and Manage Jobs with PL/SQL
Query Wait Events by Session with Oracle V$SESSION_WAIT
Oracle Index Rebuild and Coalesce with ALTER INDEX
Search UNIX Man Pages for Oracle DBA Tools with man -k

Categories

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

All Categories

ORACLE ADMINISTRATION ASM8 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION JOBS2 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION10 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION UNIX13 ORACLE ADMINISTRATION USER5 ORACLE BACKUP DATA GUARD15 ORACLE BACKUP DATAPUMP4 ORACLE BACKUP FLASHBACK8 ORACLE BACKUP IMPORT EXPORT4 ORACLE PERFORMANCE AWR12 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE MEMORY4 ORACLE PERFORMANCE QUERY TUNING6 ORACLE PERFORMANCE STATISTICS8 ORACLE PERFORMANCE STATSPACK7 ORACLE PERFORMANCE WAITS9 ORACLE PLSQL1 ORACLE RMAN23 ORACLE SQL*NET2 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES3 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS224

[A~Z][0~9]

Series

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

All Series

ADMIN GUIDE1 ORACLE ADMINISTRATION ASM8 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION JOBS2 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION10 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION UNIX13 ORACLE ADMINISTRATION USER5 ORACLE BACKUP DATA GUARD15 ORACLE BACKUP DATAPUMP4 ORACLE BACKUP FLASHBACK8 ORACLE BACKUP IMPORT EXPORT4 ORACLE PERFORMANCE AWR12 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE MEMORY4 ORACLE PERFORMANCE QUERY TUNING6 ORACLE PERFORMANCE STATISTICS8 ORACLE PERFORMANCE STATSPACK7 ORACLE PERFORMANCE WAITS9 ORACLE PLSQL1 ORACLE RMAN23 ORACLE SQL*NET2 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES3 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4

[A~Z][0~9]

Tags

ORACLE 147 DATABASE ADMINISTRATION 62 DATABASE 61 ORACLE DATABASE 52 SQL 51 DBA 40 ADMINISTRATION 35 PERFORMANCE 31 ORACLE DBA 30 PERFORMANCE TUNING 25 V$SESSION 20 RMAN 18 TROUBLESHOOTING 18 OPTIMIZATION 17

All Tags

$DATAFILE1 ACCOUNT1 ADMIN1 ADMIN GUIDE2 ADMIN SCRIPTS1 ADMINISTRATION35 AIX1 ALERT LOG1 ALL_CONSTRAINTS2 ALL_DIRECTORIES2 ALL_OBJECTS1 ALTER INDEX1 ALTER SESSION1 ALTER SYSTEM2 ANALYZE1 APROPOS1 ARCHIVE1 ARCHIVE LOG1 ARCHIVE LOGS7 ARCHIVED REDO LOGS1 ARCHIVELOG1 ARCHIVELOG MANAGEMENT1 ASH REPORTS1 ASM3 ASM DISK UTILIZATION1 AUDIT FILES1 AUTOMATION1 AUTOTRACE1 AWR10 AWR ANALYSIS1 BACKGROUND PROCESSES1 BACKUP7 BACKUP AND RECOVERY4 BACKUP AND RESTORE1 BACKUP MAINTENANCE1 BACKUP MANAGEMENT6 BACKUP RECOVERY6 BACKUP REPOSITORY1 BACKUP RETENTION1 BACKUP STRATEGY2 BACKUP VALIDATION2 BACKUP VERIFICATION3 BACKUP-COMMANDS1 BASELINE MANAGEMENT3 CHARACTER-SET1 CLUSTER5 CLUSTER MANAGEMENT1 CLUSTERWARE1 COLD-BACKUP1 COMMAND LINE1 COMPRESSION2 CONNECTED-USERS3 CONSTRAINTS3 CONTROLFILE1 CORRUPTION DETECTION1 CPIO1 CREATE_JOB1 CTAS1 DATA GUARD14 DATA INTEGRITY3 DATA RECOVERY1 DATA-MANAGEMENT8 DATA-PROTECTION1 DATA-PUMP2 DATABASE61 DATABASE ADMINISTRATION62 DATABASE BACKUP16 DATABASE CLEANUP1 DATABASE CONNECTIVITY2 DATABASE FILES1 DATABASE MAINTENANCE6 DATABASE MANAGEMENT3 DATABASE MIGRATION1 DATABASE MONITORING10 DATABASE OPTIMIZATION3 DATABASE PERFORMANCE1 DATABASE PROGRAMMING1 DATABASE RECOVERY11 DATABASE REGISTRATION1 DATABASE SIZE1 DATABASE START-UP1 DATABASE TUNING2 DATAFILES5 DATAPUMP3 DBA40 DBA COMMANDS4 DBA SCRIPTS11 DBA TASKS2 DBA TOOLS5 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS7 DBA_DATA_FILES6 DBA_DIRECTORIES3 DBA_ERRORS1 DBA_EXTENTS2 DBA_FEATURE_USAGE_STATISTICS1 DBA_FREE_SPACE4 DBA_HIST_BASELINE3 DBA_HIST_SNAPSHOT4 DBA_HIST_WR_CONTROL3 DBA_IND_COLUMNS1 DBA_INDEXES1 DBA_JOBS1 DBA_LOCK1 DBA_OBJECTS7 DBA_RESUMABLE1 DBA_ROLE_PRIVS1 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SCHEDULER_JOBS1 DBA_SCHEDULER_RUNNING_JOBS1 DBA_SEGMENTS9 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TAB_PRIVS1 DBA_TABLES2 DBA_TABLESPACES3 DBA_TEMP_FILES3 DBA_TS_QUOTAS2 DBA_UNDO_EXTENTS1 DBA_UNDO_SEGMENTS1 DBA_USERS1 DBA-RESUMABLE1 DBMS SCHEDULER1 DBMS WORKLOAD REPOSITORY1 DBMS_FLASHBACK1 DBMS_METADATA1 DBMS_RCVCAT1 DBMS_SCHEDULER3 DBMS_STATS5 DBMS_STATS.GATHER_DATABASE_STATS1 DBMS_STATS.GATHER_SCHEMA_STATS1 DBMS_WORKLOAD_REPOSITORY4 DDL1 DEVELOPMENT1 DIAGNOSTIC DEST1 DIAGNOSTICS2 DIRECTORY1 DIRECTORY OBJECT2 DISASTER RECOVERY1 DISK GROUP CREATION1 DISK INFORMATION5 DISK MANAGEMENT1 DISK SPACE ANALYSIS1 DISKGROUP4 DOCUMENTATION1 DYNAMIC PARAMETERS1 DYNAMIC PERFORMANCE VIEWS2 EDITOR1 ERROR DIAGNOSTICS1 ERROR RESOLUTION1 EXECUTION PLAN1 EXP UTILITY1 EXPDP3 EXPLAIN-PLAN2 EXPORT3 EXPORT-IMPORT1 EXTERNAL REDUNDANCY1 EXTPROC1 FAL1 FAST RECOVERY AREA2 FEATURES1 FILE HANDLES1 FILE IO1 FILESYSTEM1 FIND2 FLASHBACK7 FLASHBACK QUERY1 FRA1 FREE SPACE1 GAP RESOLUTION1 GATHER_SYSTEM_STATS1 GREP2 HASH1 HIGH AVAILABILITY5 HOT-BACKUP2 HP-UX1 IMPDP2 IMPORT2 IMPORT-EXPORT1 INCOMPLETE RECOVERY1 INDEX1 INDEX COALESCE1 INDEX MAINTENANCE1 INDEX REBUILD1 INDEXING1 INIT.ORA1 INSERT APPEND1 INSTALLATION1 INSTALLED3 INSTANCE TUNING1 IO1 JAVA1 JOB MONITORING1 JOB SCHEDULING2 KSH2 LAST-ACTIVITY1 LATCH1 LATCH CONTENTION1 LEGACY EXPORT1 LINUX1 LINUX FOR DBAS1 LISTENER1 LISTENER.ORA2 LOG MANAGEMENT1 LOGICAL BACKUP2 LOGICAL STANDBY1 LS DU COMMANDS1 LSOF1 MAINTENANCE1 MAINTENANCE TASKS1 MAN1 MANAGEMENT8 MANAGING10 MEMORY1 MEMORY MANAGEMENT2 MEMORY TUNING1 MIGRATION1 MKNOD1 MODIFY1 MONITORING12 MONITORING SCRIPTS1 MRP1 NAMED PIPE1 NETSTAT1 NETWORKING1 NLS_DATABASE_PARAMETERS1 OBJ$1 OBJECTS6 OIFCFG1 OPATCH1 OPTIMIZATION17 OPTIMIZER STATISTICS1 ORACHECK1 ORACLE147 ORACLE ADMINISTRATION11 ORACLE ASM6 ORACLE BROKER1 ORACLE CLUSTERWARE11 ORACLE COMMANDS1 ORACLE CRS9 ORACLE DATABASE52 ORACLE DBA30 ORACLE DBA SCRIPTS4 ORACLE DIAGNOSTICS1 ORACLE NET3 ORACLE PERFORMANCE4 ORACLE RMAN3 ORACLE RMAN REPORTING1 ORACLE SCHEDULER2 ORACLE SCRIPTS6 ORACLE STRUCTURE1 ORACLE TUNING1 ORACLE VIEWS3 ORACLE-ADMIN2 ORACLE-BACKUP3 ORACLE-EXPORT2 OSUSER1 PARAMETERS2 PARFILE1 PASSWORD FILE1 PATCHING1 PEFORMANCE1 PERFORMANCE31 PERFORMANCE ANALYSIS4 PERFORMANCE OPTIMIZATION3 PERFORMANCE TUNING25 PERFORMANCE-MONITORING8 PGA2 PHYSICAL STANDBY1 PL SQL1 PL/SQL1 PLSQL10 POINT IN TIME RECOVERY4 PRIMARY DATABASE2 PRIVILEGES1 PROCEDURE2 PROCESS DIAGNOSTICS1 QUERY1 QUERY ANALYSIS1 QUERY OPTIMIZATION3 QUERY-TUNING2 QUOTAS1 RAC8 RC_DATABASE1 RDBMS1 READ CONSISTENCY1 RECOVERY6 RECOVERY CATALOG5 RECOVERY MANAGER10 REDO LOGS1 REDO TRANSPORT1 REPLICATION2 RESETLOGS1 RESOURCE OPTIMIZATION3 RESUMABLE SPACE ALLOCATION1 RETENTION POLICY3 RMAN18 RMAN COMMANDS1 ROLE PRIVILEGES1 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 ROUTING DIAGNOSTICS1 SCHEMA EXPORT2 SCHEMA SPACE USED1 SCN1 SCRIPTING1 SCRIPTS6 SECURITY1 SEGMENTS3 SEQUENCE NUMBERS1 SESSION ANALYSIS2 SESSION MANAGEMENT1 SESSION-PID1 SESSIONS1 SESSIONS-SORTED1 SHARED POOL1 SHELL4 SHELL-SCRIPTING2 SHOW2 SHOW ROLES1 SHOW_TABLE_ROLE_PRIVILEGES1 SHOW-USER-SQL5 SNAPSHOT MANAGEMENT4 SNAPSHOTS1 SOLARIS1 SPACE MANAGEMENT3 SPACE USAGE1 SPACE USED1 SPFILE1 SQL51 SQL APPLY1 SQL COMMANDS5 SQL OPTIMIZATION1 SQL PERFORMANCE2 SQL PLUS1 SQL QUERIES3 SQL QUERY3 SQL SCRIPTS10 SQL STATISTICS1 SQL TUTORIAL1 SQL*NET2 SQL*PLUS3 SRVCTL3 STANDBY DATABASE7 STANDBY LOGS1 START4 START-UP TIME1 STATISTICS3 STATISTICS GATHERING1 STATISTICS MANAGEMENT2 STATSPACK7 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT10 STORAGE OPTIMIZATION1 STORED PROCEDURES1 SYSTEM PERFORMANCE1 TABLE1 TABLESPACE10 TEMP2 TERMINAL1 TEXT EDITING1 TEXT EDITOR1 TIME MODEL STATISTICS1 TNS1 TNSNAMES.ORA2 TRACE FILES2 TRACING2 TRANSACTIONS1 TROUBLESHOOTING18 TUNING8 UNDO MANAGEMENT1 UNDO_RETENTION1 UNIX2 UNIX COMMANDS13 USAGE2 USED SPACE1 USER4 USER SPACE1 USER_CONSTRAINTS1 USER_IND_COLUMNS1 USER$1 USERS2 UTL_FILE1 UTLXPLS1 V$ACTIVE_SESSION_HISTORY2 V$ARCHIVE_DEST3 V$ARCHIVE_DEST_STATUS3 V$ARCHIVE_GAP1 V$ARCHIVED_LOG3 V$ASM_DISK3 V$ASM_DISKGROUP2 V$ASM_FILE2 V$ASM_OPERATION3 V$BACKUP1 V$BACKUP_DATAFILE1 V$CONTROLFILE3 V$DATABASE6 V$DATAFILE10 V$DATAGUARD_STATS2 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$INSTANCE1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG4 V$LOGFILE5 V$MANAGED_STANDBY4 V$PARAMETER3 V$PGASTAT1 V$PROCESS2 V$SEGMENT_STATISTICS2 V$SESS_TIME_MODEL1 V$SESSION20 V$SESSION_LONGOPS1 V$SESSION_WAIT3 V$SESSTAT2 V$SGASTAT2 V$SORT_USAGE1 V$SQL2 V$SQL_PLAN1 V$SQLAREA8 V$STANDBY_LOG1 V$STATNAME3 V$SYS_TIME_MODEL1 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE3 V$TRANSACTION1 V$UNDOSTAT1 V$WAITSTAT1 VDATAFILE2 VI3 WAIT CLASS1 WAIT EVENTS1 WORKLOAD REPOSITORY3 X$BH1 X$KCBFWAITV1

[A~Z][0~9]

Copyright ORACLESCRIPTS.COM. All Rights Reserved