Coskan’s Approach to Oracle

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

About these ads

4 Comments »

  1. [...] Blogroll Report 11/09/2009 – 18/09/2009 –> Comments (2) [...]

    Pingback by Blogroll Report 04/09/2009 – 11/09/2009 « Coskan’s Approach to Oracle — September 19, 2009 @ 6:03 pm

  2. [...] Blogroll Report 18/09/2009 – 25/09/2009 Filed under: Blogroll Report — coskan @ 8:41 pm <—- Blogroll Report 11/09/2009 – 18/09/2009 [...]

    Pingback by Blogroll Report 18/09/2009 – 25/09/2009 « Coskan’s Approach to Oracle — September 27, 2009 @ 8:41 pm

  3. [...] Blogroll Report 25/09/2009-02/10/2009 Filed under: Blogroll Report — coskan @ 7:34 pm <—- Blogroll Report 18/09/2009 – 25/09/2009 [...]

    Pingback by Blogroll Report 25/09/2009-02/10/2009 « Coskan’s Approach to Oracle — October 14, 2009 @ 3:22 pm

  4. The roll off dumpster is nothing but an open top container that comes along with wheels which facilitate the rolling of the dumpster in a specific place.
    Many of today’s modern portable restrooms include running water, a flushing toilet, urinals, a flushing toilet,
    mirrors and lighting. If you are a car camper or family camper then the propane stoves give you
    the best options.

    Comment by portable restrooms new jersey — September 22, 2014 @ 12:19 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Theme: Silver is the New Black. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: