Oracle Scripts
open-menu closeme
Home
All Oracle Scripts
Scripts & Commands
Links icon
Oracle Database Documentation Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English Português
rss

  • Oracle Time Model Queries: System and Session Performance Monitoring

    calendar Oct 2, 2025 / Feb 8, 2026 · 6 min read · Oracle Database Performance Tuning Time Model Statistics AWR Analysis Database Monitoring SQL Queries System Performance Session Analysis v$sess_time_model v$sys_time_model  ·
    Share on: twitter facebook linkedin copy

    Oracle Time Model Queries: System and Session Performance Monitoring Purpose Oracle time model queries provide database administrators with powerful tools to measure and analyze where time is spent within the database system. These queries use two essential dynamic performance views that track accumulated time for …


    Read More

  • Enable or Disable Oracle GATHER_STATS_JOB for Automatic Statistics Collection using dbms_scheduler

    calendar Oct 1, 2025 / Feb 8, 2026 · 4 min read · oracle database dbms scheduler statistics gathering performance tuning database administration pl/sql optimizer statistics maintenance tasks dbms_scheduler  ·
    Share on: twitter facebook linkedin copy

    Enable or Disable Oracle GATHER_STATS_JOB for Automatic Statistics Collection The GATHER_STATS_JOB is a critical Oracle Database scheduled job that automatically collects optimizer statistics to ensure the database query optimizer generates efficient execution plans. This job is enabled by default when creating a new …


    Read More

  • Oracle AWR Create Baseline for Performance Monitoring DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE

    calendar Sep 29, 2025 / Feb 8, 2026 · 6 min read · Oracle Database AWR Performance Tuning Database Monitoring PL/SQL DBA Scripts Baseline Management Performance Analysis DBMS_WORKLOAD_REPOSITORY  ·
    Share on: twitter facebook linkedin copy

    Oracle AWR Create Baseline for Performance Monitoring DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE What is Oracle AWR Create Baseline The DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE procedure creates a baseline by preserving a specific range of AWR snapshots for future performance comparisons. A baseline protects performance …


    Read More

  • How to Manually Take an AWR Snapshot in Oracle Database with dbms_workload_repository.create_snapshot

    calendar Sep 27, 2025 / Feb 8, 2026 · 5 min read · Oracle Database AWR Performance Tuning Database Administration PL/SQL Monitoring Troubleshooting Database Optimization dbms_workload_repository  ·
    Share on: twitter facebook linkedin copy

    How to Manually Take an AWR Snapshot in Oracle Database with dbms_workload_repository.create_snapshot What is Oracle AWR Snapshot Creation? Creating a manual AWR snapshot in Oracle Database allows database administrators to capture performance statistics at specific points in time, providing precise data for …


    Read More

  • How to Change Oracle AWR Retention Period to 14 Days using dbms_workload_repository

    calendar Sep 26, 2025 / Feb 8, 2026 · 4 min read · Oracle Database AWR Performance Tuning Database Administration PL/SQL Workload Repository Snapshot Management Oracle DBA dbms_workload_repository dba_hist_wr_control dbms_workload_repository  ·
    Share on: twitter facebook linkedin copy

    How to Change Oracle AWR Retention Period to 14 Days using dbms_workload_repository.modify_snapshot_settings Purpose The Oracle code changes the Automatic Workload Repository (AWR) retention period from the default 8 days to 14 days (two weeks). This allows database administrators to store performance snapshots for a …


    Read More

  • How to Change Oracle AWR Snapshot Interval to 30 Minutes using dbms_workload_repository.modify_snapshot_settings

    calendar Sep 25, 2025 / Feb 8, 2026 · 4 min read · Oracle Database AWR Performance Tuning Database Administration DBMS Workload Repository Snapshot Management Oracle Performance Database Monitoring dbms_workload_repository  ·
    Share on: twitter facebook linkedin copy

    How to Change Oracle AWR Snapshot Interval to 30 Minutes using dbms_workload_repository.modify_snapshot_settings Purpose The Oracle Database Automatic Workload Repository (AWR) collects and stores performance statistics to help database administrators monitor and analyze database performance over time. The code …


    Read More

  • How to Check Oracle AWR Snapshot Interval and Retention Settings using table dba_hist_wr_control

    calendar Sep 24, 2025 / Feb 8, 2026 · 6 min read · Oracle Database AWR Performance Tuning Database Administration SQL Scripts Monitoring Workload Repository DBA dba_hist_wr_control  ·
    Share on: twitter facebook linkedin copy

    How to Check Oracle AWR Snapshot Interval and Retention Settings using table dba_hist_wr_control Purpose The Oracle Database Automatic Workload Repository (AWR) is a critical component for performance monitoring and database tuning that automatically collects and stores performance statistics at regular intervals. This …


    Read More

  • Display a List of Snapshots in Oracle AWR with dba_hist_snapshot

    calendar Sep 22, 2025 / Feb 8, 2026 · 6 min read · Oracle Database AWR Performance Tuning SQL Scripts Database Monitoring DBA Tasks Snapshot Management Performance Analysis dba_hist_snapshot  ·
    Share on: twitter facebook linkedin copy

    Understanding Oracle AWR Snapshot Display The Oracle Automatic Workload Repository (AWR) is a performance diagnostic tool that collects, processes, and stores database statistics automatically. Displaying a list of available snapshots is essential for database administrators who need to generate AWR reports, analyze …


    Read More

  • Oracle Statspack Automation: Scheduling Hourly Database Performance Snapshots (spauto.sql

    calendar Sep 7, 2025 / Feb 8, 2026 · 3 min read · oracle database statspack performance monitoring automation dba scripts database tuning oracle administration job scheduling  ·
    Share on: twitter facebook linkedin copy

    Oracle Statspack Automation: Scheduling Hourly Database Performance Snapshots Oracle Statspack automation provides database administrators with continuous performance monitoring capabilities through scheduled snapshot collection. The spauto.sql script enables automated hourly snapshots that capture essential database …


    Read More

  • How to Uninstall Oracle Statspack Using the spdrop Script - Complete Guide

    calendar Sep 6, 2025 / Feb 8, 2026 · 5 min read · oracle database statspack database administration performance tuning sql plus oracle dba database cleanup oracle scripts  ·
    Share on: twitter facebook linkedin copy

    How to Uninstall Oracle Statspack Using the spdrop Script - Complete Guide Oracle Statspack uninstallation is accomplished using the @?/rdbms/admin/spdrop command, which completely removes the Statspack performance monitoring framework from your Oracle database. This command removes all associated objects including the …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • »
    • »»

OracleScripts.com

Your Source for Oracle SQL Scripts
Read More

Recent Posts

  • Oracle RMAN Reset Database After RESETLOGS Recovery
  • Oracle RMAN Unregister Database from Recovery Catalog or rc_database
  • How to Register an Oracle Database with RMAN Catalog
  • How to Create Oracle RMAN Recovery Catalog Step by Step
  • Display Log Destinations Options for Oracle Data Guard Primary Database
  • Oracle Database Log Destinations Monitoring Script for Data Guard
  • Check Oracle Data Guard Standby Synchronization Status
  • Oracle Logical Standby Apply Stop and Start Commands

Categories

SCRIPTS 167 ORACLE BACKUP DATA GUARD 15 ORACLE ADMINISTRATION RAC 12 ORACLE PERFORMANCE AWR 12 ORACLE STRUCTURE TABLESPACE 11 ORACLE STRUCTURE FILES 10 ORACLE STRUCTURE OBJECTS 10 ORACLE ADMINISTRATION SESSION 9 ORACLE ADMINISTRATION ASM 8 ORACLE PERFORMANCE GENERAL 8 ORACLE PERFORMANCE STATISTICS 8 ORACLE PERFORMANCE WAITS 8 ORACLE ADMINISTRATION STATUS 7 ORACLE PERFORMANCE STATSPACK 7
All Categories
ORACLE ADMINISTRATION ASM8 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION9 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION USER5 ORACLE BACKUP DATA GUARD15 ORACLE PERFORMANCE AWR12 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE MEMORY3 ORACLE PERFORMANCE QUERY TUNING6 ORACLE PERFORMANCE STATISTICS8 ORACLE PERFORMANCE STATSPACK7 ORACLE PERFORMANCE WAITS8 ORACLE RMAN4 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES2 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS167
[A~Z][0~9]

Series

ADMIN GUIDE 167

Tags

ORACLE 120 DATABASE 57 DATABASE ADMINISTRATION 44 SQL 43 ADMINISTRATION 34 ORACLE DATABASE 32 PERFORMANCE 30 DBA 26 PERFORMANCE TUNING 24 OPTIMIZATION 17 DATA GUARD 14 TROUBLESHOOTING 14 MONITORING 12 V$SESSION 12
All Tags
$DATAFILE1 ACCOUNT1 ADMINISTRATION34 ALL_OBJECTS1 ALTER SESSION1 ANALYZE1 ARCHIVE LOG1 ARCHIVE LOGS4 ASH REPORTS1 ASM2 ASM DISK UTILIZATION1 AUTOMATION1 AUTOTRACE1 AWR10 AWR ANALYSIS1 BACKUP2 BACKUP AND RECOVERY2 BACKUP AND RESTORE1 BACKUP MANAGEMENT1 BACKUP RECOVERY3 BACKUP STRATEGY1 BASELINE MANAGEMENT3 CHARACTER-SET1 CLUSTER5 CLUSTER MANAGEMENT1 CLUSTERWARE1 CONNECTED-USERS3 CONSTRAINTS3 DATA GUARD14 DATA INTEGRITY3 DATA-MANAGEMENT8 DATABASE57 DATABASE ADMINISTRATION44 DATABASE BACKUP2 DATABASE CLEANUP1 DATABASE MAINTENANCE2 DATABASE MANAGEMENT3 DATABASE MONITORING10 DATABASE OPTIMIZATION3 DATABASE PERFORMANCE1 DATABASE RECOVERY5 DATABASE REGISTRATION1 DATABASE SIZE1 DATABASE START-UP1 DATABASE TUNING2 DATAFILES5 DBA26 DBA COMMANDS2 DBA SCRIPTS7 DBA TASKS1 DBA TOOLS2 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS6 DBA_DATA_FILES5 DBA_ERRORS1 DBA_EXTENTS1 DBA_FEATURE_USAGE_STATISTICS1 DBA_FREE_SPACE2 DBA_HIST_BASELINE1 DBA_HIST_SNAPSHOT1 DBA_HIST_WR_CONTROL2 DBA_INDEXES1 DBA_LOCK1 DBA_OBJECTS7 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SEGMENTS9 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TABLES2 DBA_TABLESPACES1 DBA_TEMP_FILES2 DBA_TS_QUOTAS1 DBA_UNDO_EXTENTS1 DBA_USERS1 DBMS SCHEDULER1 DBMS WORKLOAD REPOSITORY1 DBMS_METADATA1 DBMS_RCVCAT1 DBMS_SCHEDULER1 DBMS_STATS5 DBMS_STATS.GATHER_DATABASE_STATS1 DBMS_STATS.GATHER_SCHEMA_STATS1 DBMS_WORKLOAD_REPOSITORY4 DDL1 DEVELOPMENT1 DIAGNOSTICS1 DISASTER RECOVERY1 DISK GROUP CREATION1 DISK INFORMATION5 DISK SPACE ANALYSIS1 DISKGROUP4 EXECUTION PLAN1 EXPLAIN-PLAN2 EXPORT1 EXTERNAL REDUNDANCY1 FAL1 FEATURES1 FREE SPACE1 GAP RESOLUTION1 GATHER_SYSTEM_STATS1 HASH1 HIGH AVAILABILITY5 HOT-BACKUP1 I/O1 IMPORT1 INCOMPLETE RECOVERY1 INDEX1 INSTALLED3 JAVA1 JOB SCHEDULING1 LAST-ACTIVITY1 LATCH1 LATCH CONTENTION1 LOG MANAGEMENT1 LOGICAL STANDBY1 MAINTENANCE1 MAINTENANCE TASKS1 MANAGEMENT8 MANAGING10 MEMORY1 MEMORY MANAGEMENT1 MEMORY TUNING1 MODIFY1 MONITORING12 MONITORING SCRIPTS1 MRP1 NLS_DATABASE_PARAMETERS1 OBJ$1 OBJECTS6 OIFCFG1 OPTIMIZATION17 OPTIMIZER STATISTICS1 ORACHECK1 ORACLE120 ORACLE - DATABASE ADMINISTRATION - SQL - DBA_CONSTRAINTS1 ORACLE ADMINISTRATION2 ORACLE ASM6 ORACLE BACKUP1 ORACLE BROKER1 ORACLE CLUSTERWARE11 ORACLE CRS9 ORACLE DATABASE32 ORACLE DBA4 ORACLE DIAGNOSTICS1 ORACLE PERFORMANCE2 ORACLE SCRIPTS3 ORACLE TUNING1 ORACLE VIEWS3 OSUSER1 PARAMETERS2 PASSWORD FILE1 PEFORMANCE1 PERFORMANCE30 PERFORMANCE ANALYSIS4 PERFORMANCE OPTIMIZATION3 PERFORMANCE TUNING24 PERFORMANCE-MONITORING8 PGA1 PHYSICAL STANDBY1 PL SQL1 PL/SQL5 PLSQL1 PRIMARY DATABASE2 PRIVILEGES1 PROCEDURE2 QUERY1 QUERY ANALYSIS1 QUERY OPTIMIZATION3 QUERY-TUNING2 QUOTAS1 RAC7 RC_DATABASE1 RDBMS1 RECOVERY3 RECOVERY CATALOG4 REDO LOGS1 REDO TRANSPORT1 REPLICATION2 RESETLOGS1 RESOURCE OPTIMIZATION3 RMAN4 ROLE PRIVILEGES1 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 SCHEMA SPACE USED1 SCRIPTING1 SCRIPTS4 SECURITY1 SEGMENTS3 SEQUENCE NUMBERS1 SESSION ANALYSIS2 SESSION-PID1 SESSIONS1 SESSIONS-SORTED1 SHARED POOL1 SHOW2 SHOW ROLES1 SHOW_TABLE_ROLE_PRIVILEGES1 SHOW-USER-SQL5 SNAPSHOT MANAGEMENT4 SNAPSHOTS1 SPACE USAGE1 SPACE USED1 SPFILE1 SQL43 SQL APPLY1 SQL COMMANDS5 SQL OPTIMIZATION1 SQL PERFORMANCE2 SQL PLUS1 SQL QUERIES3 SQL QUERY3 SQL SCRIPTS9 SQL STATISTICS1 SQL TUTORIAL1 SQL*PLUS1 SRVCTL3 STANDBY DATABASE7 STANDBY LOGS1 START4 START-UP TIME1 STATISTICS3 STATISTICS GATHERING1 STATISTICS MANAGEMENT2 STATSPACK7 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT5 STORAGE OPTIMIZATION1 SYSTEM PERFORMANCE1 TABLE1 TABLESPACE10 TEMP2 TIME MODEL STATISTICS1 TRACING2 TRANSACTIONS1 TROUBLESHOOTING14 TUNING8 UNDO_RETENTION1 USAGE2 USED SPACE1 USER4 USER SPACE1 USER$1 USERS2 UTLXPLS1 V$ACTIVE_SESSION_HISTORY1 V$ARCHIVE_DEST2 V$ARCHIVE_DEST_STATUS2 V$ARCHIVED_LOG1 V$ASM_OPERATION1 V$BACKUP1 V$CONTROLFILE3 V$DATABASE2 V$DATAFILE7 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$INSTANCE1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG4 V$LOGFILE5 V$MANAGED_STANDBY1 V$PARAMETER2 V$PROCESS2 V$SEGMENT_STATISTICS1 V$SESS_TIME_MODEL1 V$SESSION12 V$SESSION_LONGOPS1 V$SESSION_WAIT1 V$SESSTAT1 V$SGASTAT2 V$SQLAREA8 V$STANDBY_LOG1 V$STATNAME2 V$SYS_TIME_MODEL1 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE3 V$TRANSACTION1 V$WAITSTAT1 VDATAFILE2 WORKLOAD REPOSITORY3 X$BH1 X$KCBFWAITV1
[A~Z][0~9]
OracleScripts.com

Copyright  ORACLESCRIPTS.COM. All Rights Reserved

to-top