The social network for Oracle people

Uwe Hesse Male Viersen, NRW Germany: Share; Share on Twitter; Share on Facebook

Blog Posts (11)
Discussions (1)
Events
Groups (5)
Featured Photos
Photo Albums
Featured Videos

Uwe Hesse's Apps (3)

Uwe Hesse's Friends

View All

Uwe Hesse's Groups

RAC SIG

131 members
Bloggers

100 members

Database Admins

308 members
Oracle Certified Master

37 members

Oracle University

38 members

View All

Uwe Hesse's Discussions

Incremental backup or scheduling full back up

Replied Aug. 12, 2009

View All

Uwe Hesse's Page

Posted about "How to change the size of Online Redologs" http://ning.it/5T2q7t Jan 22

Gifts Received

Uwe Hesse has not received any gifts yet

Give Uwe Hesse a Gift

Latest Activity

Uwe Hesse added a blog post

Data Guard & Oracle Restart in 11gR2

About the interaction of Oracle Restart (11gR2 New Feature) and Data Guard:http://uhesse.wordpress.com/2010/09/06/data-guard-oracle-restart-in-11gr2/

on Tuesday

Uwe Hesse added a blog post

Reorganizing Tables in Oracle – is it worth the effort?

This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. Short answer: Probably nothttp://uhesse.wordpress.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort/

August 25

Uwe Hesse added a blog post

Using Flashback in a Data Guard Environment

If Logical Mistakes happen, we can address them with the Flashback techniques, introduced in Oracle Database 10g already, even if in an Data Guard Environment. In case of “Flashback Table To Timestamp” or “Flashback Table To Before Drop”, there is n…

August 16

Uwe Hesse added a blog post

Performance Monitoring: Active Session History at work

Imagine you are a DBA on a production system and get an emergency call like “The Database is dead slow!”. You are supposed to spot the cause as soon as possible. ASH kicks in here: We sample the Wait-Events of active sessions every second into the A…

July 15

Uwe Hesse and Ulfet Tanriverdiyev are now friends

May 20

Uwe Hesse added a blog post

Restoring old Optimizer Statistics for troubleshooting purpose

May 19

Uwe Hesse added a blog post

Performance Impact of Logical Standby on the Primary

http://uhesse.wordpress.com/2010/04/21/performance-impact-of-logical-standby-on-the-primary/

April 21

Uwe Hesse added a blog post

Retrieve SQL and Execution Plan from AWR Snapshots

A handy little script that queries the AWR Snapshots for SQL statements and sorts them by elapsed time:http://uhesse.wordpress.com/2010/03/26/retrieve-sql-and-execution-plan-from-awr-snapshots/

March 29

Profile Information

About Me:

My name is Uwe Hesse and I live in Viersen (Germany) together with my wife Mitra and our little daughter Donya. I am working for Oracle since 2000 after several other engagements in the IT business. The line of business I am working in for the corporation is Oracle University, where I reached the grade of a Principal Instructor.

My Blog:

http://uhesse.wordpress.com/

Uwe Hesse's Blog

Data Guard & Oracle Restart in 11gR2

About the interaction of Oracle Restart (11gR2 New Feature) and Data Guard:
http://uhesse.wordpress.com/2010/09/06/data-guard-oracle-restart-in-11gr2/

Posted on September 7, 2010 at 11:00am —

Reorganizing Tables in Oracle – is it worth the effort?

This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. Short answer: Probably not
http://uhesse.wordpress.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort/

Posted on August 25, 2010 at 10:42am —

Using Flashback in a Data Guard Environment

If Logical Mistakes happen, we can address them with the Flashback techniques, introduced in Oracle Database 10g already, even if in an Data Guard Environment. In case of “Flashback Table To Timestamp” or “Flashback Table To Before Drop”,
there is nothing special to take into account regarding the Standby
Database. It will simply replicate these actions accordingly.

If we do “Flashback D

… Continue

Posted on August 16, 2010 at 7:19am —

Performance Monitoring: Active Session History at work

Imagine you are a DBA on a production system and get an emergency call
like “The Database is dead slow!”. You are supposed to spot the cause as
soon as possible. ASH kicks in here: We sample the Wait-Events of
active sessions every second into the ASH-Buffer:

http://uhesse.wordpress.com/2010/07/08/performance-monitoring-active-session-history-at-work/

Posted on July 15, 2010 at 7:44am —

Restoring old Optimizer Statistics for troubleshooting purpose

Since 10g, we do not simply overwrite old optimizer statistics by gathering new. Instead, the old optimizer statistics are automatically historized and kept for one month by default, so that they can be restored easily if that should be desired. Here we go with a short demonstration of restoring historic optimizer statistics
http://uhesse.wordpress.com/2010/05/18/restoring-old-opt… Continue

Posted on May 19, 2010 at 8:10am —