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”

The Silver is the New Black Theme. Blog at


Get every new post delivered to your Inbox.

Join 203 other followers