Статьи

Агрегатные функции (User-Defined Aggregate Functions)

• AGGREGATE_STRING с задаваемым разделителем
• AGGREGATE_BITOR

Rollup, Cube, and Grouping Sets

• Разбираем магический CUBE с помощью GROUPING_ID

Работа с датами

• Time zone, работа с временными зонами
• Get a difference between dates (получить разницу между датами)
• Generation date range with specified increments
• How to convert seconds to HH24:MI:SS

Администрирование

• ORACLE-BASE: DBA Scripts
• Customizing Locale Data NLS_SORT=UKRUMIX
• Duplicate control file (Дублирование управляющего файла)
• Backup control file to trace
• GRANT ANY OBJECT PRIVILEGE
• Запретить пользователям подключаться в базе
• Move Flash Recovery Area to a new location
• Index Rebuild vs. Coalesce vs. Shrink Space
• Moving/Renaming Datafiles While the Database is Online  
• Shared Server Diagnostics (DISPATCHER, SHARED_SERVER CIRCUIT)
• Exploring the LOCAL_LISTENER parameter

Tablespaces

• Check tablespace size usage 
• Shrinking undo tablespace
• Shrinking temporary tablespace in Oracle 10g and 11g
• TEMP tablespace usage history

Tables

• Getting information about table size, lob segment and lob index segment size which belongs to table

Tips

• Oracle Automating Script for KEEP Pool Caching Tables & Indexes db_keep_cache_size

ASH & AWR

• ASH and AWR Performance Tuning Scripts
• Analysis of Wait Events
• Taking a AWR snapshot and analyze with AWR Report Analysis screen
• AWR Report Analysis

Events

• Solving event I/O and Cluster wait and freeing wasted space in LOBs

RMAN

• RMAN effective use
• Use Data Recovery Advisor to Perform Recovery 
• ZLIB - new compression algorithm in Oracle 11g
• Restore archivelog from backup by logseq/scn 
• Recovery using the SWITCH DATABASE TO COPY command
• Backup Duplexing with RMAN
• Monitoring the recovery progress of Standard/Standby database using v$recovery_process

Мониторинг

• How to connect SQLPlus without tnsnames.ora
• Top DBA Shell Scripts for Monitoring the Database
• How to finding Max SESSION_CACHED_CURSORS in use
• How to find the SQL statements with hard parses (SQLs which not used bind variables)
• How to viewing Oracle bind variable values?
• Capture any failed SQL queries using database trigger in Oracle
• sql_trace vs. event 10046, level 4
• Determine How Long a Session has been Idle using v$session
• Determine sessions count from machine, username using v$session
• Processes and Sessions Utilization

Alert.log

• Reading alert log via SQL in Oracle 11g
• Check Alert Logs (ORA-XXXXX) 
• Shell Script to Monitor the 11g Oracle Database Alert Log File
• Procedure to write to alert.log

ADRCI Utility

• ADRCI usage examples 
• adrci - a survival guide for the DBA
• ADRCI: ADR Command Interpreter
• Morgans Library - ADR Command Interpreter

Tuning

• Oracle Database Performance Tuning Guide
• PGA Memory Management

Developing

• Alternative quoting mechanism
• Read data from clob
• Extract duplicate keywords from string
• Developing and Debugging PL/SQL using Oracle SQL Developer
• Search values in all columns of all tables

Linux

• Perform SSH and SCP Without Entering Password on openSSH