THE FAILED LOGINS METRIC QUERY IS VERY SLOW BECAUSE OF SYS.AUD$ TABLE SIZE
Failed Logins metric in Oracle Enterprise Manage Cloud Control 13c is too slow.
Auditing, Initialization Parameters, Oracle Enterprise Manager, Performance Tunning
SYS.AUD$ TABLE IS VERY LARGE
How to clean up SYS.AUD$ table
HOW TO BACKUP AN INITIALIZATION PARAMETER FILE BY QUERYING A DATABASE VIEW
A query to list all of the parameter values currently used by an instance.
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.
- 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