Site Map
-
Oracle Database
- Contacts
- Forum
-
How To Guides
- Automatic Diagnostics Repository Schema
- Data Guard Features
- How to add a Second listener on a Second Network to a 12c RAC Cluster
- How to Add Control File when Using ASM
- How to Audit a Failed Logon Attempt
- How to Audit Privilege Usage by a User (12c)
- How to Build a Grid Control Environment (10g)
-
How to Build a Grid Control Environment (11g)
- Grid Control 11.1.0.1 Administration Guide
- Grid Control 11.1.0.1 Install Guide
- Grid Control 11.2.0.1 Database Install Guide
- Grid Control 11 Known Issues, Bugs and Features.
- Grid Control Agent Install Guide
- Grid Control Post Implementation Configuration Guide
- How to Deinstall an 11.1.0.1 Grid Control Agent.
- How to Uninstall a Grid Control 11.1.0.1 Agent
- Manually Installing an 11g Grid Control Agent
- Manually Installing an 11g Grid Control Agent Against a Virtual Hostname
- How to Configure and use Flashback Database
- How to Configure Database Express
- How to Export and Import Database Statistics
- How to Export into Import via a Pipe Over SQL Net
- How to Extend the Admin Group Properties in 12c OEM
- How to Fix 12C OEM that is Missing Metrics for a Database
- How to Flashback a Table
- How to Flashback a Table to Before a Drop.
- How to Install Oracle 10g on Solaris
- How to Install Oracle 11g on Linux with ASM
- How to Install Oracle 12c and ASM on RedHat
- How to Install Oracle RAC 12c (12.1) on Linux with ASM
- How to Install RAC 10.2.0.4
- How to Install RAC 11g on OEL
- How to Manage Audit Files and Auditing on 11gr2
- How to Manage the Evolution of Baselines
- How to Manually Install XML DB on 11gR2
- How to Move an ASM Datafile to Another Diskgroup
- How to Patch to October 2018 One-off JDBC Patch
- How to Profile PLSQL
- How to Rename a Database Prior to 9.2
- How to Rename an Oracle User in AWS RDS
- How to Resize/Recreate Redo Groups
- How to Restore a Control File from Netbackup without an RMAN Catalog
- How to Upgrade a 10.2 Database to an 11.2 Database
- How to Upgrade Grid Control 10g to Grid Control 11g
- How to Use Datapump Over a Database Link
- How to use expdp on AWS RDS
- Invalidating a Plan
- Missing FK Indexes
- Multitenant Mini Guides
- Oracle Log Files and Trace Files
- Oracle Snipets
- RAC Interconnect Port Configurations for Switches
- Reading Oracle Trace Files
- Reading the Oracle Alert Log - Crash Recovery
- The Highlights of 11g New Features
- Tracking Down TM Locks
- Useful Notes From The 10gR2 Concepts Guide
- Using the Oracle Shrink Command
- Manuals
- News Archive
- Oracle Global Distributed Database
- Real Life Examples
-
Script Library
- ADR Maintenance and Log Tidy Script
- A Logon Trigger to Trace a User Session
- A Script to Monitor Plan Changes
- Buffer Cache Hit Ratio
- Check for Foreign Key Indexes
- Checks the Status of the Oracle Database
- Compressed Export Script
- Compressed Import Script
- CPU Load Script
- Creating Testing Tables
- CRS Status Script
- Detecting Lob Corruption
- Flashback Scripts
- Full RMAN Incremental Backup to Tape
- Grid Control Agent 11gR1 Silent Install
- Monitor Oracle Processes
- Monitor the CRS Stack
- New Datapump Export Script
- Script to Get User Permissions
- Show ASM Disk Usage
- Sort Usage Procedure
- Tidy the Oracle Logs
- Tracing SQL Statements for 10g
- Site Map
-
SQL Library
- ASM Diskgroups Attached to a Database
- Blockers and Waiters with RowID
- Blocking Locks
- Blocking Locks (All New Verbose Version)
- Check for Histograms on User Objects
- Check for Index Fragmentation
- Check for Missing FK Indexes
- Check How Much Table data has Changed Since the Last Analyze
- Check if Data Pump Job is Hung
- Check the Number of Rows per Block
- Check UNDO is Configured Correctly
- Create AWR Reports
- DBMS ADVISOR: Segment Advice
- Display DB Cache Advice and Cloud Computing
- Displays Last Analyzed Details for a Given Schema
- Displays Rollback Stats
- Displays Space Usage for Each Datafile
- Displays SQL Statement for the Specified Address or Hash
- Displays Temp Sort Space Currently in Use by Users
- Display the Time a Row was Last Updated
- Find Out what NLS settings are in place
- Find the Cause of Invalid Objects
- Flashback Database Commands
- Get Historical Plans from the AWR Using SQLID
- Get the DDL for a Given Table
- Get the Schema Currently Connected Too
- How to Disable Auto Drop of Plan Directives
- How to Disable Plan Directives
- How to Export and Import Using DBMS_DATAPUMP - Remap Schema Version
- How to Run a Parallel Datapump Table Only Export
- How to Use DBMS_DATAPUMP with a DB Link
- List Active Resource Plan
- List All Database Parameters
- List All Hidden Database Parameters
- List All Tables With Supporting Information
- List all Temporary Segments
- List an Object and Object Type via a Given File and Block ID.
- List ASM Diskgroups
- List ASM Diskgroups and Files
- List Consumer Groups
- List Current SQL By Execution Time For A Schema
- List Current SQL Stats for a Given User
- List Current Total Executions by SQLID for a Given Schema
- List Database Links
- List Database Parameter History
- List Database Sessions
- List Database Session Waits
- List Distinct SQL ID's for a Given Session
- List Earliest Flashback Database Time and SCN
- List Flashback Database Restore Points
- List Flashback Log Details
- List info for All Jobs Currently Running
- List Information on Consumer Groups Usage
- List Installed RDBMS Components
- List ITL Waits for a Given Users Objects
- List Job Information
- List Job Schedules
- List Long Operations for RAC
- List Memory Allocations for RAC Sessions
- List of Accessed Objects
- List of PL/SQL Code Blocks that Contain a Specified Word.
- List Plan Directives
- List RAC Sessions
- List Resource Plans
- List RMAN Jobs
- Lists all Locked Objects
- Lists all Locked Objects for RAC
- List Service Info
- List Session Details for a Given Time Period
- List Session ID for a Given OS Process ID
- List Session Waits for RAC
- List Summed Database Waits
- List Tables with More than One Extent
- List the Current Rows Processed by SQLID for a Given Schema
- List the Flashback Logging Size
- List the Most Resource Hungry SQL Statements
- List the Number of Extents for all Indexes for a Given Table
- List the Size and Quantity of Extents for a given Segment
- List the SQL statement Held for a Specific Session ID
- List Unusable Indexes for a Specified Schema
- List Users Created on the Database
- List Users Logged On
- List Users Session Parameters
- Load SQL Plans from the Cache
- RDBMS Feature Usage
- Read the Alert Log via SQL
- Redo Log Switches Per Hour
- Running Jobs
- Scheduler Information
- Segment Space Usage by Owner
- Session Tracing
- SGA Buffer Information
- SGA Resize Operations
- Show Best Performing Plan Hash Values Over Time
- Show CPU Usage for Active Sessions
- Show Details of SGA Pools
- Show Disk File Operations
- Show Gaps in Tablespace or Specific Datafile
- Show High Water Marks
- Show Info about Windows
- Show Info for a Given Index
- Show Info for Latches
- Show Job Class Information
- Show Memory Allocations for Database Sessions
- Show Object Cache Information
- Show REDO Information
- Show Rollback Information
- Show Scheduled Windows
- Show Session Waits for a Given Session ID
- Shows Index Usage for a Given Table
- Shows Memory Target Advice
- Shows Object Accessed for a Given Session ID
- Show SQL Workarea Memory Usage Statistics
- Shows Scheduler Job Credentials
- Shows Temporary Tablespace Usage
- Shows Trace Filename for Current Session
- Show the Bind Variable for a Given SQLID
- Show the Defined Default Column Values for a Given Table
- Show the First Day of the Month
- Show the FIrst Day of the Year
- Show the High Water Mark for a Given Table
- Show the HWM for a Datafile and Whether they can be Resized
- Show the Last Day of the Month
- Show the Number of Days in this Month
- Show the Number of Months Between Two Dates
- Show the Number of Seconds Left Today
- Show the Number of Seconds So Far Today
- Show the Plan Hash Values for a Given SQLID Over a Given Period
- Show the Remaining Days in the Month
- Show the Start Date and End Date of the Month
- Show Top SQL by Execution for a Given date Time
- Show Total IO for Each Datafile
- Show Undo Information
- Show Undo Information for RAC
- Tablespace Usage
- Tablespace Usage Report Procedure
- Tracing PLSQL
- Tracking Down Transactions from a SQL
- View Datafile Info
- Tools
-
Useful Commands and Information
- Conditional Operators in Linux
- How To Add A Swap File To Redhat V7
- How To Encrypt And Password Protect A Linux File
- How To Generate A Random Number in Linux
- How to Manage the Local Cluster Registry
- Number Manipulation On Linux
- Proxy Access
- Shrinking LOBs
- SRVCTL Commands
- Unix Monitoring
- Useful ASM Commands
- Useful CRS Commands
- Useful Diagnostics Commands
- Useful Find Commands
- Useful Oracle Commands
- Useful RunInstaller Flags
- Useful Sysdate Formats and Queries
- Useful Unix Commands
- Using Autotrace
- Using GV$ Cursor
-
Useful Documents
- Oracle 11g Default Schemas
- Oracle 19c Default Schemas
- Row Chaining
-
The Highlights of 19c New Features
- 19c New Features Data Guard
- Automatic Indexing
- Hybrid Partitioned Tables - 19c New Feature
- In-Memory 19c New Features
- JSON - 19c New Features
- Multitenant - 19c New features
- Security - 19c New Features
- Sharding - 19c New features
-
SQL Quarantine
- Create a Quarantine Configuration for a SQL Statement by Plan Hash Value
- Create a Quarantine Configuration for a SQL Statement by SQL ID
- Create a Quarantine Configuration for a SQL Statement by SQL Text
- Delete a Quarantine Configuration
- Disable a Quarantine Configuration
- Disable Automatic Quarantine
- Enable a Quarantine Configuration
- How to Move Quarantine Configurations Between Databases
- Query a Quarantine Threshold
- Set Thresholds for a Given Quarantine Configuration
- V$SQL - SQL Quarantine
- What is SQL Quarantine?
- Useful Tables and Views
- White Papers
