HOW TO FIND WHO AND WHAT SQL IS USING TEMP TABLESPACE?
A query to know which sessions are currently using temporary space in the Oracle Database, and how much space each session consumes.
Queries, Tablespaces
HOW TO QUERY THE HIDDEN PARAMETERS IN AN ORACLE DATABASE
A query to view all the hidden parameter and their default values.
HOW TO GET ORACLE NLS SETTINGS DEFINED ON DATABASE, INSTANCE, AND SESSION LEVELS
A database query to fetch Oracle NLS settings defined on a database, an instance, and session levels.
HOW TO FETCH THE CURRENT ORACLE DATABASE STATUS
A query to fetch a current status of an Oracle Database.
HOW TO IDENTIFY BLOCKED AND BLOCKING SESSIONS IN ORACLE DATABASE
A query to identify blocked and blocking sessions in an Oracle Database.
- Accounts
- Auditing
- AWR
- Bash Scripts
- Datapump
- Default Category
- Demos
- Directory Objects
- Environment Variables
- Initialization Parameters
- Iptables
- Java Program
- Memory Usage
- Metadata API
- Networker
- NLS Settings
- Optimizer Statistics
- ORA-00942
- ORA-01031
- ORA-01720
- ORA-28001
- ORA-31671
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Postfix
- Privilegies
- Processes
- Queries
- Red Hat Enterprise Linux
- Redo Logs
- Session Tracing
- Sessions
- SQL Trace
- SQLPlus
- Statspack
- Tablespaces
- UTL_FILE
- UTL_FILE_DIR
- Wait Events
- Yum