INSIDE ORACLE seminar

This week I have delivered my INSIDE ORACLE special seminar for the first time.
The seminar is a two day event which deals with Oracle 10g key features and upgrade issues.
I had 18 delegates with different backgrounds who were highly interested in memory management, new performance tuning techniques and backup strategies.
In between the paticipants had the opportunity to test some of the features hands on in the seminar room where we had a munber of system instaled with Oracle 10g database.
I have received a number of emails with very positive feedback in the meentime.
This seminar is available internationnally from now on and I already have the first bookings for it.
In May I will be delivering in Germany and Turkey and Greece hopefully as well.
And there are other talks going on in the background at the moment.

connect lutz hartmann as sysdba

statistics_level translated

I just found my blog translated into another language:
http://translate.google.com/translate?hl=ja&sl=en&u=http://luhartma.blogspot.com/2006/09/statisticslevel-in-oracle-10gr2.html&sa=X&oi=translate&resnum

Can anybody tell me which language this is?

connect lutz hartmann as sysdba

Enterprise Manager Packages Petition

Today I received a comment on my post about licensing of the Enterprise Manager packages.
Edgar pointed out a petition which has already been signed by 140 people.
This petition requests that Oracle Corporation should make all of its Enterprise Manager management packs available to all of its customers at the same price, regardless of the edition of the Oracle product that they have purchased.

I am not sure if this will be successfull but it is worth a try, don’t you think so?
=;-)

connect lutz hartmann as sysdba

new OCPs and OCAs

This week I have deliverd a specially condensed 10g New Features with Exam course for Oracle Partners.
After 4 days of exam cram three of the delegates have managed to pass the examinatin tests in teh Oracle University testing center in Baden.
Here you can see the two new OCPs Klaus and Martin as well as the new OCA Renato.
Congratulations!

connect lutz hartmann as sysdba

Enterprise Manager Packages Licensing Information Part II

A few weeks ago I have already posted about the licensing agreements for the Oracle 10g Enterprise Manager Packages.
I have pointed out that you use these packages implicitly if you even do not use Enterprise Manager at all, but only
- run certain scripts from $ORACLE_HOME/rdbms/admin/
or
- call certain procedures from certain packages
and so on
Pls see my first post about this for a detailed list of functionalities which use these packages implictily..

Just recently I received a comment on this post by Russel who asked about ADDM in Standard Edition, which made me wonder..
First of all I looked up the licensing information in the Online Ducumentation where I found the Table 1-1 Feature Availability for Oracle Database Editions which shows me:

Feature/Option SE1 SE EE Notes

Manageability
Oracle Change Management Pack	N	N		Y	Extra cost option
Oracle Configuration Management Pack	N	N		Y	Extra cost option
Oracle Diagnostic Pack	N	N		Y	Extra cost option
Oracle Tuning Pack	N	N		Y	Extra cost option, also requires the Diagnostic Pack
Duplexed backup sets	N	N		Y
Database Resource Manager	N	N		Y

The Documentations explains to us the following about Table 1-1:
Table 1-1 lists feature availability for Oracle Database Standard Edition One (SE1), Standard Edition (SE), and Enterprise Edition (EE). The Y value in a column means that the feature is available in the specified release; N means that it is unavailable. This table can help you understand the difference between the editions and determine whether you require Enterprise Edition (or Personal Edition for a single-user environment).

Russel had asked in his comment about addmrpt.sql script for Standard Edition.
So I have installed SE under Linux and found out to my surprise that all the Enterprise functionalites where there ADDM, AWR, all the Enterprise Manager Packages which are not available, as the docu says. They were all in place and functionable in SE!
So I called Oracle support and here is what I was told:

SE has the same code base as EE, and all the EE-functionalities are also working in SE, they are even used by ORACLE internally for self tuning ,
BUT,
you are not allowed to use them.

And now you maybe should look at my first post again in order to find out what is not allowed and what brings you in danger od needing even not only an additional license for the packages but, also you might need a license for Enterprise Edition on top because the packages which are not available as of the Docu, but which are in place and functionable, and are implicitly used if you just klick to one little link in the browser or call just one procedure or run only the wrong skript from $ORACLE_HOME/rdbms/admin, are not combinable with an SE license.

The nice new functionality called database usage statistics high water marks will let you and everyone who can look at it know, which feature was used in the past and how often and so forth:
Haved a look at DBA_FEATURE_USAGE_STATISTICS and you will know if you already need a license for Enterprise Edition.

Thanks a lot for asking Russel!!!!
I was not aware of this.

connect lutz hartmann as sysdba

Brand new book on RMAN Backup & Recovery out!

Finally it has been published:
the ultimat RMAN book for Oracle 10g
by M. Hart & R. Freeman!

I have been waiting for the 10g version of the book since quite a while already.
It was one of the very good books for Oracle 9i and I can tell you that the new one is as good. http://www.mhprofessional.com/product.php?cat=112&isbn=0072263172

ISBN: 0072263172 / 9780072263176

What I like most about the book:
- It contains a number of workshop for advanced recovery scenarios and
points out all these RMAN functionalities which are much too less used and know like BLOCK RECOVERY, PROACTIVE CHECKING FOR CORRUPT BLOCKS and so on.
- it has good index
- it contains info about memory utilization of RMAN for tuning

The book also covers new 10g features, such as Flashback, Transportable Tablespaces Cross Platform …

It is a must for everybody who needs to know how RMAN works and how to utilize it to the max.

Table of contents
Part I: Getting Started with RMAN in Oracle Database 10g

Chapter 1: Oracle Database 10g Backup and Recovery Architecture Tour

Chapter 2: Introduction to the RMAN Architecture

Part II: Setup Principles and Practices

Chapter 3: RMAN Setup and Configuration

Chapter 4: Media Management Considerations Chapter

5: Oracle Secure Backup

Chapter 6: Enhancing RMAN with VERITAS NetBackup for Oracle Chapter

7: Configuring EMC NetWorker Module for Oracle Chapter

8: RMAN and Tivoli Storage Manager

Part III: Using RMAN Effectively Chapter

9: RMAN Backups Chapter

10: RMAN Restore and Recovery Chapter

11: Using Oracle Enterprise Manager for Backup and Recovery Chapter

12: RMAN Advanced Recovery Topics Chapter

13: Surviving User Errors: Flashback Technologies Chapter

14: Maintaining RMAN Chapter

15: Monitoring and Reporting on RMAN Chapter

16: Performance Tuning RMAN Backup and Recovery Operations

Part IV: RMAN in the Oracle Ecosystem

Chapter 17: Duplication: Cloning the Target Database

Chapter 18: RMAN and Data Guard

Chapter 19: RMAN and Real Application Clusters

Chapter 20: RMAN in Sync and Split Technology

Chapter 21: RMAN in the Workplace: Case Studies

Part V: Appendixes

Appendix A: RMAN Syntax Reference Guide

Appendix B: Exploring the Recovery Catalog

Appendix C: Setting Up an RMAN Test Environment

INDEX

connect lutz hartmann as sysdba

Oracle Database 10g Real Application Clusters Handbook

I have just received the recent new book (FEB. 2007!)
by K. Gopalakrishnan
Oracle Database 10g Real Application Clusters Handbook 

Gopalakrishnan is a Senior Principal Consultant in Oracle Corporation and was avarded “Oracle Author of the year 2005” by Oracle Magazine in for his 2005 published book “Oracle Wait Interface”, which was one of the few books of the last year about Oracle which were really worth their money. Pls see my post about this book also.

After having a first glance at the new book I am very enthusiastic about it, because it contains large chapters about cache fusion (36 pages!) and the Global Resource Directory GRD (>20 pages) explained from scratch , amoung other intereseting chapters about troubleshooting RAC, RAC deployment…
Again we find the high quality we already have enjoyed in Gopalakrishnan´s Wait Interface book, and I bet it will be a success story as well.

Table of contents

Part I: High Availability Architecture and Clusters
Chapter 1: Introduction to High Availability and Scalability
Chapter 2: Clustering Basics and History
Chapter 3: RAC Architecture
Part II: Installation, Configuration, and Storage
Chapter 4: RAC Preinstallation
Chapter 5: RAC Installation
Chapter 6: Automatic Storage Management
Part III: RAC Administration and Management
Chapter 7: RAC Basic Administration
Chapter 8: RAC Advanced Administration
Chapter 9: RAC Backup and Recovery
Chapter 10: RAC Performance Management
Part IV: Advanced Concepts in RAC
Chapter 11: Global Resource Directory
Chapter 12: A Closer Look at Cache Fusion
Chapter 13: Workload and Connection Management
Chapter 14: RAC Troubleshooting
Part V: Deploying RAC
Chapter 15: RAC Extensions
Chapter 16: Developing Applications for RAC
APPENDIX A: RAC REFERENCE
APPENDIX B: ADDING AND REMOVING CLUSTER NODES
APPENDIX C: REFERENCES
INDEX

ISBN 007146509X / 9780071465090

Paperback, 421 pages

connect lutz hartmann as sysdba

INSIDE ORACLE 10g special seminar

At the moment I am preparing a special two day seminar about Oracle 10g.
I have entirely created it on my own.

Its title will be INSIDE ORACLE 10g
and I will deliver it for the first time on
February 19th./20th. in Zurich.

on the first day of seminar I deal with the following topics:
- Memory Management:
- manual & automatic Shared Memory management
- manual & automatic Process Memory management
- temporary tablespace usage
- managing optimizer statistics and upgrade issues

On the second day I will talk about:
- New Performance Tuning Approach in 10g
- New RMAN Features and how they work
- The new ORACLE recommended backup strategy
- FLASHBACK Functionalities in 10g

The seminar will take place at Digicomp Academy in Zurich
and is handled by Oracle University.
The number of seats is limited to 30.
The prise is 1700 CHF for the two days.
There are already several bookings placed.

If you are interested in attentding you can book simply
through my company sysdba database consulting GmbH
by cutting and pasting the below lines, filling them in with your data and sending them to
sysdba database consulting GmbH by FAX
under the following number: +41 56 470 2264

Order Form for the two day seminar INSIDE ORACLE 10g
on February 19th./20th. 2007 in Zurich:

Yes, I want to enroll
LAST NAME………………………………………………………
FIRST NAME…………………………………………………….
COMPANY…………………………………………………………
Number of Seats…………………………………………………
Telefone Number:………………………………………………
FAX Number……………………………………………………..

DATE…………………………………………………………………

SIGNATURE……………………………………………………..

connect lutz hartmann as sysdba

Certifying CERN again

This week I am in Geneva again,
delivering a special certification event for Oracle University.
Again a bunch of DBAs want to get certified for Oracle 10g.
We compress a pensum of 10 normal education days into 5.
I guess that again this will be no problem for these guyes -
they are CERN!
I am looking foreward to these delicious Sushis in the basement of Cornavin Station.

connect lutz hartmann as sysdba