Coskan’s Approach to Oracle

July 23, 2010

Blogroll Report 16/07/2010 – 23/07/2010

Filed under: Blogroll Report — coskan @ 3:17 pm

<—- Blogroll Report 09/07 /2010 – 16/07/2010

1-What is tablespace and disk level fragmentation?
Jonathan Lewis-Fragmentation-2

2-What is table level fragmentation?
Jonathan Lewis-Fragmentation-3

3-What is index level fragmentation?
Jonathan Lewis-Fragmentation-4

4-How to delete database file system when you hit “ORA-64007: invalid store specified” error.
Frits Hoogland-DBFS and ORA-64007: invalid store specified

5-Automated SQL*Loader control file generator
Charles Kim-Generate SQL*Loader Control File Script

6-How to unbind NICS on Unix to remove them from ifconfig -a output?
Dan Norris-unplumb (or unbinding) NICs on Linux

7-ASMCMD privileges with 11GR2
Neil Johnson-ASMCMD privileges in Grid Infrastructure

8-How does OEM Performance Tab uses ASH data to generate reports ?
Marcin Przepiorowski-OEM performance tab and Active Session History data.

9-I/O throughput vs IOPS
Martin Widlake-More Memory Meanderings – IOPS and Form Factors

10-How to read block header part of index block dump?
Richard Foote-Index Block Dump: Block Header Part I (Editions Of You)

11-Why does Oracle / CBO ignores your Hint?
Charles Hooper-Demonstration of Oracle “Ignoring” an Index Hint

12-How do you calculate the chance of loosing data with ASM mirroring? ASM disk partnership
Alex Fatkulin-ASM Mirroring and Disk Partnership

13-How to sort ora-0094 when using tablespaces tab with select catalog role?
Hector R Madrid-ORA-00942 Querying Tablespaces from Enterprise Manager

14-How does exadata storage indexes work?
Marc Fielding-Exadata’s Best Kept Secret: Storage Indexes

15-Operating system Tuning recommendations for using Oracle on Linux
Ronny Egner-Tuning Linux for Oracle

16-What is the meaning of V$DATABASE.CREATED column ? Is it DB creation or controlfile creation date ?
Hemant K Chitale-V$DATABASE.CREATED — is this the Database Creation timestamp ?

17-Oracle Data Dictionary and ASYNCH I/O
Frits Hoogland-Doing synchronous IO on ASM

18-Unexpected growth in size and not using of free space with ASSM
Nigel Noble-10gR2 – 11gR2, ASSM Space Management “Bug”


July 19, 2010

Blogroll Report 02/04/2010 – 09/04/2010

Filed under: Blogroll Report — coskan @ 1:40 pm

<—- Blogroll Report 26/03 /2010 – 02/04/2010

1-How To Format Corrupted Block which is Not Part Of Any Segment?
Michael T. Dinh-logical corruption

2-Different behavior for connect by with UNION and UNION ALL clauses due to bug 6429113
Timur Akhmadeev-connect by oddity

3-How does failed login check on dba_audit_session can cause performance problem ?
Jonathan Lewis-Failed Login

4-How to split big tables for parallel operations ? manual parallelization – similar to Jonathan Lewis Pseudo Parallel
Ruslan Dautkhanov-splitting big tables for parallel operations

5-How to change database name with ASM data structure change ?
Martin Nash-Rename database when using ASM

6-Expert views about gathering statistics
Iggy Fernandez-Statistics How and When ?

7-How does dynamic remastering work in 11GR2-How to do Manual remastering?
Fairlie Rego-Dynamic remastering in 11G

8-How to use 11G SECTION SIZE option for decreasing backup time
John Hallas-Reducing RMAN backup time for unevenly sized tablespaces/

9-XTRACE session trace browser to browse in a tracefile
Alberto Dell’era-Xtrace: an Oracle session trace browser (introduction)

10-Ways to sort problems arrived with new fix (5483301) which changed how non-existing values are treated when there is a frequency histogram on a column / expression.
Randolf Geist-Frequency histograms – edge cases

11-How to avoid unavailability of materialized views during refresh operation
Arup Nanda-Online Materialized View Complete Refresh With Partitions

July 16, 2010

Blogroll Report 09/07/2010 – 16/07/2010

Filed under: Blogroll Report — coskan @ 4:31 pm

Note: I have gazillion non read blog posts on my list but I gave up waiting to read them in order so I am starting to continue from this week.  I hope if I find time I will add them retrospectively.

1-How does dropping and creating tables on read only tablespaces work?
Tanel Poder-Dropping and creating tables in read only tablespaces?!

2-How to present oracle statistics in charts using VB Script ?
Charles Hooper-Oracle Statistics Chart Viewer

3-How to add dependency to cluster resources ? Adding ASM dependency to Instance ?
Murali Vallath-10gR2., adding dependency to applications/resources managed by CRS

4-How to install systemtap on OEL5-update-5 and sample script?
Frits Hoogland-Installing systemtap on OEL5, update 5

5-Restrictions on Table and Index Compression
Randolf Geist-Compression Restrictions

6-Oracle Outer joins and Ansi Equivalents
Maria Colgan-Outerjoins in Oracle

7-Oracle on Windows – Important bits
Charles Hooper-Windows as an OS Platform for Oracle Database – Where Do I Start?

8-Introduction to Fragmentation in Oracle
Jonathan Lewis-Fragmentation-1

9-How do we syncronize changes, happening while the initial data load extract process is in operation with goldengate?
Gavin Soorma-GoldenGate – Online Change Synchronization with the initial data load

10-What is the difference between RAISE_APPLICATION_ERROR and RAISE?

11-How does ASM mirroring work? Hot spare capacity instead of hot spare disk?
Jeremy Schneider-ASM Mirroring – No Hot Spare Disk

Blogroll Report  16/07 /2010 – 23/07/2010 –>

Blog at