Coskan’s Approach to Oracle

September 27, 2009

Blogroll Report 18/09/2009 – 25/09/2009

Filed under: Blogroll Report — coskan @ 8:41 pm

<—- Blogroll Report 11/09/2009 – 18/09/2009

Here come this week’s selection,

1-Solution to “ORA-38760: This database instance failed to turn on flashback database” after interrupted flashback database

Fairlie Rego – Interrupting Flashback Database

2-ASSM bug with different data block size

Jonathan Lewis – Bugs

3-Functions in SQLS and read consistency behaviour

Hemant K Chitale-SQLs in Functions : Each Execution is Independent

4-What happens and how to recover when you lose your OCR mirror and all the nodes were down?

Geert De Paep-The ultimate story about OCR, OCRMIRROR and 2 storage boxes – Chapter 1

5-Why do we need to have power of 2 numbers of partitions for hash partitioning?

Jonathan Lewis – Hash Partitions

6-Diagnosing network problem by tracing system calls

Amit Bansal-Sqlplus connection on AIX taking too long

7-Limits on Triggers with LOB’s

Grégory Guillou-Triggers and LOBs: Synchronous CDC and Synchronous Streams Capture

8-Different behaviour of dictionary tables for Deleted tables

Martin Widlake-Beware Deleted Tables

9-How to use BBED for data extracting/hacking?

Steve Callan-Oracle’s Block Browser and Editor tool

10-How to do manual failover with 11G Data Guard Broker

Jim Czuprynski-Performing Database Failover with Oracle 11g Data Guard

11-How to configure alternate pfile/spfile location on windows systems by using registry keys

Matt Canning-Alternate locations for database parameter files in 11g – Part 4 of 7

12-Auditing for beginners

Robert Geier-Enable Oracle auditing BEFORE you need it

13-How to configure Data Guard Broker

Apun Hiran - How To: Configure Data Guard Broker

14-How to configure Data Guard Fast-Start Failover with Data Guard Broker

Apun Hiran - How To: Configure Data Guard Fast-Start Failover Step By Step

11GR2 Related Posts

1-Architecture behind exadata v2 flash cache?

Jean Pierre Dijcks-500GB/sec and Database Machine Generation 2

2-SSH User setup for Clusterware installation-11GR2 New feature

Luis Moreno Campos-SSH User Equivalence in 11gR2 Real Application Clusters Clusterware installation

3-Video for installing 3 node Oracle RAC 11G in VMWare

Eric (masterschema)-Install Oracle RAC 11g R2 in VMWare – 3 nodes

4-Video for adding 4th node on 3 node Oracle RAC 11G in VMWare

Eric (masterschema)-Extending RAC 11gR2 to 4th node

5-Video for having more than one DB in a single RAC cluster in VMWare

Eric (masterschema)-More than one database in a single RAC cluster

6-How to create new mount point with ASMCA-11GR2 New database manageability feature

Luis Moreno Campos-Putting ACFS to work: how to create a mount point in the new Oracle File System

7-Technical whitepaper for Sun Oracle Exadata V2 database machine (PDF file)

Oracle – A Technical Overview of the Sun Oracle Exadata Storage Server and Database Machine

Blogroll Report 25/09/2009 – 02/10/2009–>

September 19, 2009

Blogroll Report 11/09/2009 – 18/09/2009

Filed under: Blogroll Report — coskan @ 6:01 pm

<—- Blogroll Report 04/09/2009 – 11/09/2009

Another 11GR2 week but this time with  addition of Exadata V2 announcement. It was hard to pick one and I chose Alex Gorbachev’s views about this new database machine.

1-What are simulators in shared pool buffer cache ?

Tanel Poder - KGL simulator, shared pool simulator and buffer cache simulator – what are these?

2-When does Plan_hash_value changes?

Riyaj Shamsudeen – Is plan_hash_value a final say?

3-Nologging and recovery relationsip

Uwe Hesse -How do NOLOGGING operations affect RECOVERY?

4-Pros and Cons of the supported ways to solve index explosion

Jonathan Lewis – Index Explosion 4

5-How to move from ASM to filesystem?

John Hallas – Moving from ASM storage back to filesystem

6-How to regress Opatch version?

John Hallas – Regressing an Opatch version

7-How to use MV_CAPABILITIES_TABLE for fast refreshable materialized view restrictions?

Rob Van Wijk-Fast refreshable materialized view errors, part six: MV_CAPABILITIES_TABLE

8- Why/How to split check constraints when there is top-level AND?

Rob Van Wijk-Check constraints and AND

9- What happens and how to recover when you loose your OCR mirror ?

Geert De Paep-The ultimate story about OCR, OCRMIRROR and 2 storage boxes – Chapter 1

10- Report need backup and retention policy relationship

Khurram Siddiqui – coreletion between report need backup and retention policy

11- How histogram gathering works when first N characters is same?

Martin Widlake – Decrypting Histogram Data #3 – is 7 or 15 Characters Significant?

12- In what cases System statistics gathering can fail and workarounds (ORA-20003: Unable to gather system statistics)?

Martin Widlake – Another Day, Another Obscure Oracle Error

13- What is a VLDB and Who is VLDB DBA?

Martin Widlake – What is a VLDB

14- How to install Oracle Database 10g on Mac OS X Snow Leopard?

Raimonds Simanovskis – How to install Oracle Database 10g on Mac OS X 10.6 Snow Leopard

15- ASM Hands on Trainings by Alejandro Vargas (22 labs so far so I put archive link instead of all)

Alejandro Vargas – ASM Hands on Trainings

16- How to configure and use Oracle Public Yum?

Charles Kim – Public Yum with Oracle

17- How system statistics and CPU costing model works with indexes?

Richard Foote-The CBO CPU Costing Model and Indexes – Another Introduction

18- How to create read only OEM user?

Rajeev Ramdas Thottathil – Creating a view only user in Enterprise Manager grid control

19 – How to diagnose a problem for solving with Method-R?

Carry Milsap-On the Importance of Diagnosing Before Resolving

20- What privileges you need to  copy schemas over database link in a procedure

Dani Ray-The gains and pains of dbms_datapump. Part I

11GR2 New Features Posts

1- Exadata V2

Alex Gorbachev -Unveiling the OLTP Oracle Database Machine & Exadata v2

2- How to do maintenance on ASM Volumes and Cluster File Systems- New Server Manageability Feature of 11GR2

Charles Kim – Maintaining ASM Volumes and Cluster File Systems in Oracle Database 11g Release 2

3- How to create disk groups with ASMCMD Command Extensions- New Server Manageability Feature of 11GR2

Charles Kim -New ways to create disk groups in Oracle Database 11g Release 2

4- ASMCMD Command Extensions- New Server Manageability Feature of 11GR2

Charles Kim -Ways to mount and dismount disk groups in Oracle Database 11g Release 2

5- How to rename disk groups with renamedg utility – New Server Manageability Feature of 11GR2

Charles Kim – Rename Disk Group

6- How to manage volumes with ASMCMD Command Extensions – New Server Manageability Feature of 11GR2

Charles Kim – Volume Management with asmcmd

7- ASM Cluster File System (ACFS) command line – New Server Manageability Feature of 11GR2

Charles Kim – ACFS command-line tools available in Oracle Database 11g Release 2

8- How to configure ACFS for auto-startup – New Server Manageability Feature of 11GR2

Charles Kim – Configure ACFS for auto-startup for non-RAC database servers

9- New DBMS_COMPRESSION package – New Server Manageability Feature of 11GR2

Chandra Pabba-Oracle11gR2 Table / Tablespace Compression

10- Intelligent Data Placement – New Server Manageability Feature of 11GR2

Chandra Pabba-Oracle11gR2 ASM New Feature – Intelligent Data Placement

11- Deferred Segment Creation behaviour with traditional Export / Import – New Server Manageability Feature of 11GR2

Chandra Pabba- Oracle11gR2: Deferred Segment Creation and export behavior!

12- NTH_VALUE Analytic function – New Business Intelligence and Data Warehousing feature of 11GR2

Lucas Jellema - Oracle Database 11gR2 – New analytical function NTH_VALUE

Blogroll Report 18/09/2009 – 25/09/2009—->

September 11, 2009

Blogroll Report 04/09/2009 – 11/09/2009

Filed under: Blogroll Report — coskan @ 6:28 pm

<—- Blogroll Report 28/08/2009 – 04/09/2009

This week was again busy with 11GR2 new features and the absolute winner of the new feature blog entry competition is Charles Kim and his posts are not just excerpts from available documentation. Nicolas Gasparotto was the first one who finds  a bug in 11GR2 for popular new feature deferred segment creation.   I could not even find time to install release, but people started to find bugs, I think I am loosing my speed :)  11GR2 selections are again grouped separately and will, till everything goes to normal.

1-Dangerous sorting behaviour of Oracle for Analytic functions

Jonathan Lewis – Analytic Agony

2-How to use ADRCLI in 11G?

Charles Kim – Automatic Diagnostic Repository (ADR) Command Line Interface

3-How to use REGEXP for argument validation in Shell Script (check the comments)?

Jared Still - Shell Tricks

4-Behaviour change of CBO when partition level stats are available but table level are not

Hemant K Chitale-Table and Partition Statistics

5-How to avoid password hardcoding in Shell scripts with Oracle Wallet ?

Amit Bansal-Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password?

6-How to disable ocssd.bin for non-rac non asm environments?

Charles Kim – Disable ocssd.bin daemon when running non-RAC environments

7-How to use SQL Performance Analyzer (SPA) in 11G?

Steve Callan-SQL Performance Analyzer

8-Why buffer cache buffers can reside in shared pool and what are KGH NO ACCESS in shared pool?

Tanel Poder -KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!

9-What are the reasons for chained rows and How to deal with them ?

Joel Goodman – Are you chained to your tables.

10-ORA-01792 with inline views

Dion Cho-Interesting case of ORA-01792 error.

11-When your backup policy might not be enough?

Martin Widlake – Your Backups Are Probably Too Simple

12-The new version of the Upgrade to Oracle Database 11g – The whole Story

Mike Dietrich-New version of 11g upgrade slides available

13-Invalid Oracle Internet Directory problem after Oracle identity management upgrade

Frank Van Bortel – Upgrade IDM from 10.1.2 to 10.1.4: dba_registry invalid OID

11GR2 New Features Posts

1-ASM Storage Management Configuration Assistant- New server manageability feature

Charles Kim -Oracle has a new configuration assistant in 11g Release 2 – ASMCA

2-ASM Intelligent Data Placement-New Server Manageability feature of 11GR2

Charles Kim – ASM – Intelligent Data Placement

3-How to install 11GR2 on Linux?

Charles Kim-Installing Oracle Database 11g Release 2 – Enterprise Database Edition

4-Enterprise Manager Support for ASM Cluster File System (ACFS) – New Server Manageability feature of 11GR2

Charles Kim - Creating ASM Volumes and Cluster File Systems with Enterprise Mangers in 11g Release 2

5-ASM FS Snapshot – New Server Manageability feature of 11GR2

Charles Kim -Creating ASM Snapshots with Enterprise Mangers in 11g Release 2

6-How to start DBCONSOLE in 11GR2 ?

Charles Kim -Starting dbconsole from command line in Oracle Database 11g Release 2

7-How to fix PRVF-5472: or PRVF-5439: during 11GR2 installation?

Chandra Pabba – Oracle11gR2 CRS Install – ntpd requirement

8-How to install Peoplesoft on 11gR2 64-bit?

Nicolas Gasparotto – Peoplesoft on 11gR2 64-bits

9-Lib32 Dir is not available in 11GR2 64 bit

Nicolas Gasparotto – 11gR2 64-bits : where is lib32 ?

10-Bug # 8816562 Deferred Segment Creation is not working with move and workaround for the bug.

Nicolas Gasparotto – Get rid off segment of empty table (11gR2)

11-Step by step 11GR2 upgrade

Saurabh Sood-Get Upgrading: Steps To Upgrade To 11gR2

12-No need of voting disk backuo for 11GR2 clusterware-New clustering feature of 11GR2

Syed Jaffar Hussain- Voting Disk Backup Procedure Changed in Oracle 11g Release 2

13-SQL Generation – New server managealibility feature of 11GR2

We do streams-The New Streams 11.2 SQL Generation Facility

14-XMLType Partitioning – New Unstructured Data Management feature of 11GR2

Marco Gralike – Oracle RDBMS 11gR2 – XML Data Partitioning

15-IGNORE_ROW_ON_DUPKEY_INDEX Hint-New availability feature of 11GR2

Luis Moreno Campos-Oracle 11gR2 feature of the Day!

16-Step by step 11gR2 rac installation on 64 bit Linux

Rajeev Ramdas Thottathil - 11gR2 rac installation on 64 bit Linux step by step

Blogroll Report 11/09/2009 – 18/09/2009 –>

September 8, 2009

Blogroll Report 21/08/2009 – 28/08/2009

Filed under: Blogroll Report — coskan @ 12:04 pm

<—- Blogroll Report 14/08/2009 – 21/08/2009

1-Workaround for LOB Concatenation performance problem

Dion Cho- Reducing CLOB concatenation

2-How to use flashback and guaranteed restore points for Data Guard?

Vitaliy Mogilevskiy-Using Flashback Database to strengthen Data Guard Setup

3-Possible reasons for changing bind variable names (read the comments)

Jonathan Lewis- Quiz Night-2

4-Detecting low memory starvation on Red Hat <5 Linux x86-32bit

Martin Decker -Out-of-Memory killer on 32bit Linux with big RAM

5-SUMDELTA$ table is not purged when MVIEW base table is using Direct path insert

H.Tonguc Yilmaz -Materialized views and sys.sumdelta$ UPDATE-DELETE performance

6-Tuning SQL*Net message from dblink with USE_HASH hint

Marko Sutic- SQL Tuning – using USE_HASH hint – dblink issue

7-New infiniband monitoring with OSWatcher

Husnu Sensoy -Full Coverage in Infiniband Monitoring with OSWatcher 3.0: IB Monitoring

8-Workaround for setting maxtrans for indexes in 10G

Jonathan Lewis- Index Explosion-3

9-How to detect violating rows for constraints

Shailesh Mishra -Constraints: How to resolve the duplicated primary key exceptions

10-Diagnosing “latch: cache buffer chains “

Tanel Poder -latch: cache buffers chains latch contention – a better way for finding the hot block

11-How to use Oracle Q-quote with dbms_advanced_rewrite.

Kerry Osborne-Quotes in Strings (Oracle Q-quote)

12- Does oversize of datatype VARCHAR2 causes performance problem?

Mohammad Abdul Momin Arju – Does oversize of datatype VARCHAR2 causes performance problem

13- Workarounds for ORA-00600 ORA-12085 ORA-03113 with GV$SQL and GV$SQL_PLAN

Martin Widlake-RAC GV$SQL type Bugs

14-Issues while validating database backups with restore database validate command

Miladin Modrakovic-Bugman ( RMAN ) validate restore “bug”

Oracle Streams—-

15-How to use Oracle Advanced Queuing Buffered Messages (demo for exchange messages between 2 queues in different databases.

We do streams-Oracle AQ Buffered Queues 101 (Part 2)

16-Simple way to fix propogations errors with streams

We do streams- Propagation Error And Exception Queue Management

17- How to do data comparison between tables using DBMS_COMPARISON in 11G

We do streams- Data Comparison with DBMS_COMPARISON

18- Behaviour of fire_once=false triggers with streams

We do streams- Are your triggers triggered by Streams?

19- How to use V$STREAMS_MESSAGE_TRACKING for Tracking LCRs Through a Stream

We do streams- Tracking Streams Changes with V$STREAMS_MESSAGE_TRACKING

Blogroll Report 28/08/2009 – 04/09/2009—- >

September 7, 2009

Blogroll Report 14/08/2009 – 21/08/2009

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

<—- Blogroll Report 07/08/2009 – 14/08/2009


I am back from holiday and I think did my best to filter these blog posts from large number of blog posts, when I am away even Oracle released 11.2 :). Next time I won’t take a holiday longer than 10 days. I will cover the missing weeks one by one instead of 3 weeks in 1 post.

1- Using REGEXP_LIKE with outer joins ?

Peter Scott -Slightly Fuzzy Lookups

2- How to use alert log for error trends ?

Karl Arao – Knowing the trend of Deadlock occurrences from the Alert Log

3-How to read treedump for what happened in indexes ?

Jonathan Lewis – Treedump

4- Using alter system kill session in procedure

John Hallas-Procedure to kill a session

5- How to get the date for the last day of the previous month?

Jonathan Lewis - Why test ?

6- How to bulk insert cursor data into a table ?

Liang Gang Yu-BULK INSERT cursor’s data INTO A TABLE – Oracle10g, 11g

7- How to use UTL_COMPRESS to compress files ?

Steve Callan-Compressing files in Oracle

8- When you lost your spfile?

Matt Canning-Dealing with a lost SPFILE

9- Transparent Application Failover (TAF) for Data Guard ?

Uwe Hesse – Connect Time Failover & Transparent Application Failover for Data Guard

10 – Using backup copy to move files after changing the recordsize on filesystem ?

Don Seiler-Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize

11- What are Synthetic Commits and Rollbacks?

Christian Antognini - Synthetic Commits and Rollbacks

12 -ORA-16069 after switchover?

Don Seiler – ORA-16069? You May Need A New Standby Controlfile

13 -Possible solution for slow network connection in 11G ?

Marcin Przepiorowski – Slow network connection in 11g

14 -How to escalate Oracle SR ?

Chris Warticki- Support Escalation Process…Again!

15-How to adjust optimizer_index_cost_adj if you really want to use it ?

Richard Foote – The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III

16 -How to track DDL changes in 11G ?

Miladin Modrakovic – Tracking DDL changes in 11g

17 -How to do Oracle Cross-Platform Migration with Minimal Downtime ?

Don Seiler – HOWTO: Oracle Cross-Platform Migration with Minimal Downtime

18 -How to use Active Data Guard in 11G ?

Jim Czuprynski - Using Oracle 11g’s Active Data Guard and Snapshot Standby Features

19 -How to install Oracle Client on unsupported OS ?

Marko Sutic – How to install Oracle Client 11g on Windows 7?

20 -How to use unix EXPECT utility to simulate non-interactivity for interactive only installations?

Advait Deo – Spawn, Expect, Send and Interact

Blogroll Report 21/08/2009 –28/08/2009—->

August 14, 2009

Blogroll Report 07/08/2009 – 14/08/2009

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

<—- Blogroll Report 31/07/2009 – 07/08/2009

This week was technically ritch and these are my selections.

1- How to measure redo log generation ?

Ben Prusinski – DBA Quick Tip of the week: Measuring Redo Generated

2-How to solve ORA-01620 for RAC standby for non-RAC primary?

Chandra Pabba – ORA-01620 while creating a RAC standby for non-RAC primary

3-How to speed up Single instance RAC convertion process via RCONFIG ?

Sabdar Syed – How we faster the process of converting a non-ASM single-instance database to RAC database with ASM using RCONFIG tool?

4-Quick VPD for beginners

Paul M.Wright – VPD vite

5-Information about shared pool freelists

Riyaj Shamsudeen – Shared pool freelists (and durations)

6-How does optimizer behaves when where clause is not in index but index columns in order list ?

Randolf Geist – Optimizer cleverness

7-How to use convert command to copy files from ASM to filesystem?

Marcin Przepiorowski – ASM datafile operation in NOMOUNT

8-How to avoid invalid packages message before upgrade to 11G?

Mike Dietrich - Drop SYS.PLAN_TABLE$ prior to upgrading

9-How Oracle fast refreshes materialized views (MVs) of a single master table?

Alberto Dell’Era – Fast refresh of single-table materialized views – algorithm summary

10- How to decrypt endpoint_value in dba_tab_histograms

Martin Widlake - Decrypting Histogram Data

11- Workarounds for ITL related index growth

Jonathan Lewis - Index Explosion-2

12- How  DBMS_STATS.SET_*_PREFS  in 11G ?

CBO Architects Group- Understanding DBMS_STATS.SET_*_PREFS procedures

13-Improvements on autoallocated segments in 11G

Christian Antognini -System Managed Extent Size – 11g Improvements

14-Quick guide to Troubleshooting Oracle Streams

Pat Lehane – Troubleshooting Oracle Streams/CDC

15-How to use DBMS_ROWID ?

Tom Kyte – On DBMS_ROWID, Parsing, and Sizing

16-Tutorial for RMAN scripts

Arup Nanda -Scripting Oracle RMAN Commands

17-How to clear session which were marked for kill?

Tanel Poder-Alter system kill session and ORA-00031: session marked for kill

18-How to copy schemas over database link in a procedure ?

Dani Rey-The gains and pains of dbms_datapump. Part I

19-How to send mail with CLOB attachment?

Ozay Akdora – Sending mail with CLOB attachement

20-11G upgrade problem caused by timesone file

Miladin Modrakovic - Issues with upgrade to 11g

21-ORA-00384 on 11G when you set minimum for db_cache_size

Steven Karam – Strange Behavior with MEMORY_TARGET

22-ORA-15099 with ASM disks larger than 2 TB

Jonathan Lewis – Tera-Bug

23-  How to automate usage of DBMS_DATAPUMP over network link

Daniel Ray-The gains and pains of dbms_datapump. Part I

Blogroll Report 07/08/2009 – 14/08/2009—->

August 12, 2009

Blogroll Report 31/07/2009 – 07/08/2009

Filed under: Blogroll Report — coskan @ 2:32 pm

<—- Blogroll Report 24/07/2009 – 31/07/2009

It is a bit late but I had decent excuses like post upgrade problems (as usual on a system which wasnt tested properly when it was test db )

1- Why not to trust ASH.TIME_WAITED ?

Vitaliy Mogilevskiy- Making sense of ASH TIME_WAITED Units

2- Restrictions when using union all with Fast refreshable materialized views

Rob Van Wijk- Fast refreshable materialized view errors, part four: union all MV’s

3- Reasons of big SYSTEM tablespaces

Martin Widlake- Why is my SYSTEM Tablespace so Big?

4- Oracle on Linux in Windows without virtualization tools.

Marcin Przepiorowski- andLinux and Oracle

5- How does Oracle fast refresh materialized views containing only joins of master tables

Alberto Dell’Era- fast refresh of join-only materialized views -algorithm summary

6- How to increase performance for data unloading from Oracle to other vendors via Oracle Heterogeneous Services

Ilmar Kerm- High performance data unloading from Oracle to ODBC database

7- Example of diagnosing a multipath problem

Martin Decker- Multipathing Configuration issue waiting to happen

8- Library Cache Pin wait caused by PL/SQL compalition

Kubilay Kara – Library Cache Pin Waits during PL/SQL compilation

9- Why export import is not reliable for detacting corrupt data blocks.

Jared Still- Detecting Corrupt Data Blocks

10- How to solve installation of grid control agent problem on active passive microsoft cluster environment

Alex Fatkulin – How to install Oracle Grid Control Agents on a Windows failover cluster with no downtime

11- ORA-4031 when there is plenty of free space in SGA.

Riyaj Shamsudeen- ORA-4031 and Shared Pool Duration

Oracle Forums

1- one block appears 54K times as cr in v$bh

Blogroll Report 24/07/2009 – 31/07/2009 –>

July 24, 2009

Blogroll Report 17/07/2009 – 24/07/2009

Filed under: Blogroll Report — coskan @ 2:05 pm

<—- Blogroll Report 10/07/2009 – 17/07/2009

This was one of those weeks that you really need a summary of the blog activities, it was more than fruitful.
The most popular topic was new 11G feature Direct Path Access and they all were very interesting.
My personal choice of the week is Index Quiz series from Jonathan Lewis, they were very informative and I strongly recommend you, not miss any of the comments.

1- Direct path pros/cons and how to disable direct path access.

Miladin Madrakovic -Direct path reads and serial table scans in 11g

Christian Antognini-Impact of Direct Reads on Delayed Block Cleanouts

Dion Cho-Disabling direct path read for the serial full table scan – 11g

2- Indexes and ITL

Jonathan Lewis -
Index Quiz 1
Index Quiz 2

3- table stats Choked by Auto Stats Gathering Job.

Martin Widlake-
Automated Statistics Gathering Silently Fails
Automated Statistics Gathering Silently Fails #2
4- Explanation of min segment size – Richard Foote vs Myths
Richard Foote-Why A Segment Really Has To Be At Least 2 Blocks In Size

5- Negative effects of optimizer_index_cost_adj
Richard Foote-The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II
6- Difference between NOT IN and NOT EXISTS with NULLs
Hemant K Chitale-The difference between NOT IN and NOT EXISTS

7- How to find out parameters and diagnostic events of specific session ?
Dion Cho – Spying on the other session

8- Case of failed Stored outlines in 11G
Dion Cho-Stored outline does not work – the stupidity of Oracle 11g

9- How to automate AWR report generation ?
Rajeev Ramdas Thottathil- Shell script to generate awr reports for a range of snapshots

10- What does not effect plan_hash_value generation ?

Randolf Geist – PLAN_HASH_VALUE – How equal (and stable?) are your execution plans – part 1

11- How to use logminer when flashback is not option ?

Uwe Hesse- Logminer: Not as modern as Flashback but still useful!

12 – Summary of most known PL/SQL features

Steven Feuerstein – Must Know Features of PL/SQL

13- How to automate test script generation for SQLs with bind variables ?

Kerry Osborne-Creating Test Scripts With Bind Variables

14- How to check possible bind variable needs ?

Alberto Dell’Era – Bind Variables Checker for Oracle – now install-free

15- Faster fixed table access.

Miladin Madrakovic-Accessing Fixed Tables using Direct Access

16- Explanation of Securefile deduplication in 11G

Liang Gang Yu -Oracle 11g SecureFile System-Part 1- Deduplication of LOBs

17- Solution to emctl “WARN http: snmehl_connect: connect failed to (hostname:): Connection refused (error = 111)” problem

Asanga – Enterprise Manager Error

18- How to inspect LUNs on Linux ?

Krishna Manoharan-Map Disk Block devices on a Linux host back to the SAN Lun

Blogroll Report 24/07/2009 – 31/07/2009–>

July 17, 2009

Blogroll Report 10/07/2009 – 17/07/2009

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

<—- Blogroll Report 03/07/2009 – 10/07/2009

Here are  this week’s technical highlights

1- Tablespace_name like _$deleted$ in dba_tab_partition Bug:8291493

Jeff Moss – $deleted$ tablespace names bug

2- Easy connect namins(EXCONNECT) with ORA-12504

Mark Williams – SQL*Plus, EZCONNECT, Password Prompt, and ORA-12504

3-Libray cache definition with libray example

Aman Sharma – Library Cache, A Distant Look….

4- CTAS and copied constraints

Laurent Schneider - CTAS and NOT NULL

5- How to do a clean XML DB installation

Marco Gralike – HOWTO: Do a clean XML DB installation…

6-  How to enable disable Row Shipping feature in 10.2.0.1>  (_enable_row_shipping parameter)

Mladin Madrakovic – Wide Table Select ( Row Shipping )

7- Review of July 2009 CPU

Integrity – Oracle Critical Patch Update July 2009 Pre-Release Analysis

8- Poor man’s data vault project

Chet Justice – DBA: Poor Man’s Data Vault

9- Proof of Transparent Data Encryption

Liang Gang Yu – Data Block Dump in Oracle – part 4 – vs. Transparent Data Encyption

10 -How to decode block dump with UTL_RAW

Dion Cho -Decoding block dump using UTL_RAW

11 – Restrictions on PL/SQL functions with DML content

Shailesh Mishra – Workaround the DMLs: PL/SQL function restrictions

12 – Why to use Autoallocate for tablespace growth

Hemant K Chitale – Sizing OR Growing a Table in AUTOALLOCATE

13 – How to encrypt compress and mask with Data Pump in 11G (New features)

Arup Nanda - Encrypt, compress, mask, and deliver information with Oracle Data Pump.

14 – How to avoid ORA-01652 after executing “alter table compress…”

Marko Sutic – How to avoid ORA-01652 after executing “alter table compress…”

15 – Demonstration for Delayed cursor invalidation for databases above 10G.

Harald van Breederode – Rolling Cursor Invalidation

16 – How to provide exact cardinality of a collection used in a TABLE() query, to CBO

Adrian Billington – Collection CARDinality

Oracle Forums  (Did not have time this weekend)

High library cache load lock waits in AWR

Unable to create public synonym

Blogroll Report 17/07/2009 – 24/07/2009—->

July 10, 2009

Blogroll Report 03/07/2009 – 10/07/2009

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

<—- Blogroll Report 26/06/2009 – 03/07/2009

This weeks technical post selections

1- How to get object name from using file# and block# by block dump

Dion Cho – Object Name from File and Block

2- How to run huge sql files from sqlplus by using FIFO

H.Tonguc Yilmaz – Oracleturk hints running huge sql files from sqlplus and deleting huge amount of data best-practices

3-  Performance of PLSQL Native Compilation

Pat Lehane – PL/SQL Native Compilation

4- Parallel execution interconnect performance on RAC systems. (When to use and when not to use parallel execution on RAC)

Greg Rahn – Oracle parallel execution interconnect myths and misunderstandings

5- How does optimizer_index_cost_adj parameter effects CBO decision when IO cost is active

Richard Foote – The CBO and Indexes optimizer_index_cost_adj Part I

6- How to diagnose SQL*NET tracefile with trcasst utility

Miladin Madrakovic – Troubleshooting SQL*NET

7-  Materialized Views for beginners

Uwe Hesse -Brief introduction into Materialized Views

8- atomic_refresh parameter and high redo generation with Meterialized Views

Amit Bansal – Mview Complete Refresh and Atomic_refresh parameter

9- How to manage Voting Disks in Oracle RAC

Brijesh Dubey – Voting Disk Management in RAC

10- Oracle bug –  gather_schema_stats fails with function based indexes

Amardeep Sidhu – GATHER_SCHEMA_STATS & ORA-03001: unimplemented feature

11- How to use cursordump for top truncated sql trace.

Tanel Poder – Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile

12- How to detect when a cursor was closed from SQL trace output?

Tanel Poder – How to detect when a cursor was closed from SQL trace output?

13- How to use/read/interpret Data Block Dump

Liang Gang Yu – Data Block Dump in Oracle – part 1 – how to dump block
Liang Gang Yu – Data Block Dump in Oracle – part 2 – how to read block dump file
Liang Gang Yu – Data Block Dump in Oracle – part 3 – object_id, data_object_id, block clean up

14- How to tune WHERE NAME LIKE ‘%ABC%’ queries with index hint

Laurent Schneider – How to tune WHERE NAME LIKE ‘%ABC%’


15- How to get rowcount faster – Fastest way to get rowcount

Martin Widlake – Counting the Cost #5 – accurate and fast


16- How to concatenate LOB columns for minimal resource usage

Jonathan Lewis – Concatenating LOBs


17-  _PGA_MAX_SIZE  parameter behaviour with PL/SQL

Husnu Sensoy – _pga_max_size = 200M : Maximum size of the PGA memory for one process ?!?


18- How to add tables to Oracle Stream between different Releases

Marcelo Lopes – Adding Tables to a Stream Between Oracle 9i and 10G


19- How to clone Oracle Home

Charles Kim – Cloning an Oracle Home after you tar the binaries from one server to another

Oracle Forums

1- Tuning PL/SQL Code

http://forums.oracle.com/forums/thread.jspa?threadID=925857

2- Which nologging way is better for performance?

http://forums.oracle.com/forums/thread.jspa?threadID=926001

3- SQL Query Statistics

http://forums.oracle.com/forums/thread.jspa?threadID=925935

Blogroll Report 03/07/2009 – 17/07/2009–>

« Newer PostsOlder Posts »

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 193 other followers