With Oracle 10g, external table was required to read alert log but luckily Oracle 11g created a system table that can be used to access alert log from SQL: X$DBGALERTEXT. Oracle reads the log.xml from alert directory (which contains all the data what alert.log does), parses it and returns the details back as rows. Beginning [...]
Tech Blog
Blog Stats
- 56,060 hits
Tea Break
Oracle Blogs
Oracle Documentation
UNIX/LINUX
Categories
- Backup and Recovery (11)
- Business Intelligence (1)
- Data Dictionary (7)
- Dictionary Tables (2)
- Performance Views (1)
- Data Storage (1)
- DBA Tasks and Interview Stuff (1)
- Hardware (1)
- oracle (1)
- Oracle Architecture (23)
- Initialization parameters (5)
- Memory Architecture (4)
- Oracle Memory (3)
- Process Architecture (3)
- SGA (2)
- Storage Architecture (11)
- Tablespaces (3)
- Oracle Concepts (2)
- Oracle DBA (2)
- Oracle Installation Creation Configuration (2)
- Oracle Issues (3)
- Oracle Network (4)
- Listener (2)
- Oracle TNS (2)
- Oracle SQL (9)
- Dynamic SQL (1)
- SQL Functions (1)
- String Functions (1)
- SQL Hints (1)
- Table SQL (2)
- Oracle Tools (1)
- Oracle Utilities (6)
- Performance Monitoring and Maintenance (1)
- Performance Tuning (14)
- SQL Optimization (5)
- SQL Joins (1)
- STATISTICS (1)
- SQL Optimization (5)
- PL SQL (6)
- Functions (1)
- Packages (2)
- Procedures (2)
- Portals (1)
- Schema Objects (10)
- Security (4)
- Privileges (1)
- Table (1)
- Users (2)
- SQL Server (3)
- Streams (1)
- Uncategorized (5)
- UNIX (7)
- AWK and SED (2)
- Utilities (3)
- Windows Utilities (1)
Category Cloud
Backup and Recovery Data Dictionary Indexes Initialization parameters Listener Logical Backup Export Import Memory Architecture Oracle Architecture Oracle DBA Oracle Issues Oracle Memory Oracle Network Oracle SQL Oracle TNS Oracle Utilities Performance Tuning PL SQL Process Architecture RMAN backup and recovery Schema Objects SGA SQL Optimization SQL Server Storage Architecture Tables Tablespaces Table SQL Uncategorized UNIX Utilities
Blog at WordPress.com. Theme: Spring Loaded by the449.
