OraNA :: Oracle News Aggregator

<—- Blogroll Report 29/01/2010 – 05/02/2010

1-How to simulate Oracle errors with simulator events

Dennis Yurichev-Oracle RDBMS internal self-testing features

2-How to decode dates in histograms?

Martin Widlake-Format of Date Histograms

3-How to decide the value of datafile resize option ?

Jonathan Lewis-Shrink Tablespace

4-All about network wait events

Kyle Hailey-Oracle: Network Waits

5-When does manual logfile switch trigger complete checkpoint ?

Lua Donghua-ALTER SYSTEM SWITCH LOGFILE and CHECKPOINT

6-When does “alter system archive log current” trigger checkpoint?

Lua Donghua-ALTER SYSTEM ARCHIVE LOG CURRENT and CHECKPOINT

7-How to secure java in Oracle and how to test public revocation?

Paul Wright-Securing Java In Oracle and DBMS_JVM_EXP_PERMS

8-Difference between case and decode in terms of trimming

Timo Raitalaakso-Equality -comparing text

9-How to upgrade ASM 10.2 to 11.2 single instance

Martin Bach-Upgrade ASM 10.2 to 11.2 single instance

10-How to use resumable operations in Oracle

Stewart Bryson-Data Warehouse Fault Tolerance Part 1: Resuming

11-How to restart your ETL process with restore points ?

Stewart Bryson-Data Warehouse Fault Tolerance Part 2: Restarting

12-How to use incremental backup for no logging operations for recovery in DW environments?

Stewart Bryson-Data Warehouse Fault Tolerance Part 2: Restoring

13-Beginners guide to index block dumps and treedumps Part-1

Richard Foote-Index Block Dumps and Index Tree Dumps Part I: (Knock On Wood)

14-NVL and COALESCE performance comparison?

Scott Wesley-Short-circuit Evaluations – moving away from NVL

Scott Wesley-One more COALESCE vs NVL example to finish the week

15-How to drill down and detail sys_time_model data vs2?

Charles Hooper-Working with Oracle’s Time Model Data 3

16-How to put gather_plan_statistics hint without changing the code by sql profiles?

Kerry Osborne-gather_plan_statistics

17-How to check/extract unsuccessful connection attempts in listener_log ?

Martin Bach-Check for non-successful connection attempts in listener.log

18-Why does Oracle use undo when there is already redo logs? (Must read)

Jonathan Lewis-Why Undo?

19-How to configure ASYNC-IO on HP/UX?

John Hallas-OER 27064: cannot perform async I/O to file – HPUX

20-How to convert cross platform single instance to RAC with RCONFIG?

Syed Jaffar Hussain-My experience of converting a cross platform (AIX to HP) single instance database to RAC using RCONFIG tool

21-How to backup Oracle to cloud storage ?

Alisher Yuldashev -Let Your Oracle Backups Be Up in the Clouds

22-Fundemantals of Performance Tuning (Must read)

Cary Milsap-Thinking Clearly About Performance

23-Solutions to Permission problems with fuse and DBFS

Kevin Closson-Oracle Database 11g Database
File System (DBFS). Common DBFS Problems and Solutions. Part II.

24-How to send execution plan to excell and show execution plans on web

Charles Hooper-Automated DBMS_XPLAN, Trace, and Send to Excel

25-Weird Transitive Closure behaviour in execution plan which causes ignorance of hints

Jonathan Lewis-Ignoring Hints-2

26-How to do initial server pool configuration before database creation in 11GR2?

Martin Bach-Server Pool experiments in RAC 11.2

27-Problems with usage of Append_Values and solutions

Gary Myers-Append Values and how not to break the database

28-How does Subquery factoring work?

Tim Hartley-Getting Recursive

<—- Blogroll Report 22/01/2010 – 29/01/2010

1-Oracle 0 day exploit
Miladin Modrakovic-Oracle Exploit Published 11g R2
2-Faulty quotes about Non Default Block Sizes
Charles Hooper-Faulty Quotes 5 – Block Sizes
3-Common mistake done after adding and index to see how it performs
Hemant K Chitale-Some Common Errors – 1 – using COUNT(*)
4-RAC One Node and connection failover handling
Marcin Przepiorowski-Oracle RAC One Node – part 3
5-How to set PCTFREE ?
Anurag Tibrewal-PCTFREE
6-How to use average active sessions and available CPU for tuning ?
Kyle Hailey-Tuning the Application, Database and Hardware
7-How to get workload character of your Database from AWR data?
Karl Arao-Workload characterization using DBA_HIST tables and kSar
8-Flash Cache and Flash drive performance comparisons
Guy Harrison-Flash tablespace vs. DB Flash Cache
9-How to use NMAP for network diagnosing
Frits Hoogland-Must have network diag tool NMAP
10-How to discover device names for LUNs when LUN number is known?
Saurabh Sood-How To Discover Disk Name When LUN Number is Known (OEL5)
11-Parallel queries and sort performance behaviour
Kellyn Pedersen-When Parallel is Wrong
12-How to use CATALOG command to catalog missing tape backups?
Marcin Przepiorowski-RMAN and SBT_TAPE backup pieces – how to catalog it
13-How to audit sys into an OS file owned by root?
Uwe Hesse-How to audit sys into an OS file owned by root
14-How to use dbms_parallel_execute package in 11GR2?
Tim Hall- DBMS_PARALLEL_EXECUTE
15-How to share read-only tablespaces between databases (comments***)?
Uwe Hesse-Sharing READ ONLY Tablespaces between Databases
16-Documentation bugs during pre-requisite checks on Solaris
Luo Donghua-Documentation Bug for Oracle database installation on Solaris
17-How to report if there was an unrecoverable operation happened?
Catherine Chow-Oracle: What is an Unrecoverable Data File?
18-How to use latch classes in case you really want to change the spin count and cause minimal effect ?
Craig Shallahamer – Gotta low latch class
19-All about gathering execution plans
Charles Hooper-Execution Plans – What is the Plan, and Where Do I Find It?
Charles Hooper-Execution Plans – What is the Plan, and Where Do I Find It 2?
Charles Hooper-Execution Plans – What is the Plan, and Where Do I Find It 3?
20-Faulty quotes about %100 CPU utilization ? (comments)
Charles Hooper-Faulty Quotes 6 – CPU Utilization
21-SQL Tuning Advisor generated SQL Profiles and manual sql profile (comments)
Kerry Osborne-Single Hint SQL Profiles
Kerry Osborne-SQL Tuning Advisor Profiles
22-How to do pivoting pre-11G?
Marc Billette-Easy Pivot Query Result in pre-11g Oracle