Videos on Flashback in Oracle Database 10g and 11g
Dan Morgan, the author of Morgan’s library, has just posted three videos on Flashback in Oracle database 10g and 11g:
Watch the FlashBack Database video (20 min) on how to return the database to a point in the past using either the SCN (system change number) or a specified time. Go to the FlashBack Database webpage on Morgan’s library to try the code yourself.
Watch the FlashBack Drop video (11 min) on how to recover a dropped table. Go to the FlashBack Drop webpage on Morgan’s library to try the code yourself.
Watch the FlashBack Query video (9 min) on how to run queries against the database at any specific time in the past. Go to the FlashBack Query webpage on Morgan’s library to try the code yourself.
These are excellent videos (with nice classical introductory music) and I hope that Dan will post more videos on more Oracle topics in the future.
Note: You need the free RealMedia Player to watch the videos.
Comments Off | Filed in Oracle | Tags: 10g, 11g, flashbackOracle Database 11g Overview Presentation
I have stumbled upon the following presentation by Mark Townsend, the vice president of database product management, titled The Future of Database Technology. Towards the middle of the presentation, there is a high level overview of many Oracle database 11g features like SQL replay, online table and index redefinition, automatic diagnostic workflow, support for online hot patching and other highlights.
Here is the full document: Continue reading…
2 Comments | Filed in Oracle | Tags: 11gOracle Database 11g to Launch on July 11
Here is the email I received from Oracle:
Dear Edward Awad,
The history of information technology is a journey, defined by innovations such as the internet and grid computing. Oracle would like to personally welcome you to see the next generation of innovation by inviting you to the launch of Oracle Database 11g.
This is your opportunity to join Oracle President Charles Phillips and Oracle Senior Vice President Andy Mendelsohn, as well as leading industry experts from some of the most innovative companies of our time. Collectively, they will help you understand what’s needed to compete at this point in history, and how Oracle’s latest database release will help meet those needs.
The launch event is going to take place on July 11 in New York city.
Moreover, watch for 11g demos up on Morgan’s Library within a week of the production release.
1 Comment | Filed in Oracle | Tags: 11g, OracleWhat’s new is important
What is the first thing you do when a new version of an Oracle database (or any software) is released? You immediately look for the “what’s new” document, right?
I believe that the “What’s new” document is very important because it informs you of new (or modified) features that is supposed to make your life easier and your applications more powerful.
Take advantage of “what’s new”. After all, you’re paying for these new features (I assume), so use them or lose them.
To that end, here is a list of “what’s new” links. They will take you straight to the corresponding section of the Oracle documentation:
What’s new in Oracle Database version:
What’s new in SQL in Oracle Database version:
What’s new in PL/SQL in Oracle Database version:
Here is a list of useful “What’s new” articles:
- What Oracle bloggers are saying about Oracle Database 11gR2
- Oracle Database 11g: The Top New Features for DBAs and Developers
- Tom Kyte talks about his first experience with Oracle Database 10g Release 2
- ORACLE-BASE – Articles on Oracle 10g new features
- Oracle Database 10g: The Top 20 Features for DBAs
- What’s New in PL/SQL in Oracle Database 10g
- Announcing the New MODEL
- Oracle 10g Adds More to FORALL
