HOW TO SHOW ALL OBJECTS PRIVILEGES FOR A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object grants that a particular user has. It includes both direct privileges and privileges granted through a role.
HOW TO GET ORACLE NLS SETTINGS DEFINED ON DATABASE, INSTANCE, AND SESSION LEVELS
The post provides a database query to compare Oracle NLS settings defined on a database, an instance, and a session levels.
SYSAUX TABLESPACE IS TOO LARGE BECAUSE OF OPTIMIZER STATISTICS ADVISOR TASK DATA
Due to a bug in 12.2 and 18c databases, the SYSAUX tablespace grows rapidly and consumes lots of space in the database. The SM/ADVISOR option is involved.
CLEAN UP DATABASE FROM THE SESSHIS USER AND HIS OBJECTS
Removing all custom objects that were created through 2 posts : ALTERNATIVE TO V$ACTIVE_SESSION_HISTORY VIEW IN STANDARD EDITION and/or DUMPING SQL EXECUTION HISTORY INFORMATION SNAPSHOTS IN STANDARD EDITION
DUMPING SQL EXECUTION HISTORY INFORMATION SNAPSHOTS IN STANDARD EDITION
A way to catch and store every single SQL ever executed in a Standard Edition database. Creation SQL execution snapshots for later analysis.
TOO HIGH ELAPSED TIME FOR ENTERPRISE MANAGER QUERIES BECAUSE OF AUDIT RECORDS
The Enterprise Manager Queries are on the top of CPU/TIME consuming queries in statspack reports. The post offers some methods to handle it.
SYSAUX TABLESPACE IS TOO LARGE BECAUSE OF OPTIMIZER STATISTICS HISTORY
The SYSAUX tablespace keeps growing because of storing old table statistics. A purging of history data is required.
ERRORS ORA-39150 AND ORA-08186 DURING DATAPUMP IMPORT WHEN USING FLASHBACK_TIME OPTION
A datapump session fails with the error “bad flashback time” because of the specified FLASHBACK_TIME parameter. It fails even if parameter is correct.
- Linux (8)
- Networker (2)
- Oracle (71)
- Account (3)
- AWR (4)
- Database Errors (7)
- Database Performance (10)
- Datapump (4)
- DBMS_SCHEDULER (2)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- NLS SETTINGS (1)
- Objects (2)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- Optimizer Statistics Advisor (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (3)
- Tablespaces (2)
- Temporary Tablespace (2)