<—- 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”