Flashback | Oracle

Collaborate09 thoughts…

I’ve been meaning to write up my thoughts from this years IOUG Collaborate event. Ian Abramson, the president of the IOUG, has a nice series of write ups on the event itself – starting with day 1 through day 3 and then a wrap-up post. He describes it as a three day event – but [...]

August 11th, 2009 | Posted in ORACLE BLOGS | No Comments

Using Oracle Database 11g Hierarchical Profiler in SQL Developer

Oracle SQL Developer 1.5 exposes a few new Oracle 11g database features. These include the Flashback and the PL/SQL Hierarchical Profiler. For details on either of these feature it’s best to dive in the the 11g documentation, available online here. The PL/SQL Hierarchical Profiler…”identifies hot spots and performance tuning opportunities… It reports [...]

August 11th, 2009 | Posted in ORACLE BLOGS | No Comments

on recycle bin

more than one user may wondered who created those BIN$ when they first connected to a 10g database.

create table lsc_t(x number)
partition by range(x)
(partition LESS_THAN_ONE values less than (1));

drop table lsc_t;

select object_name, subobject_name, created
from user_objects
where object_name like 'BIN$%';
OBJECT_NAME SUBOBJECT_NAME CREATED
—————————— ————— ———
BIN$bh2VJ6FqFJ3gRAAUT+rFpg==$0 LESS_THAN_ONE 07-JUL-09

Ok, it is quite easy to get rid of it. Either at DROP time with [...]

August 11th, 2009 | Posted in ORACLE BLOGS | No Comments

ASM Hands-On Training, Lab 5, Using RMAN To Migrate a Database Into ASM

One of the ways to migrate a database to ASM is to use the Rman “Backup as Copy” command to create a database copy into ASM storage and then switch the database to the copy.
This technique can be used, combined with incremental backups, to move even very large databases into ASM.
The first backup [...]

July 10th, 2009 | Posted in ORACLE BLOGS | No Comments

Inside OCP – "More Ways to Flash Back"

Query history and recover from corruptions with Oracle Flashback technology.
Link to the original site

July 5th, 2009 | Posted in ORACLE TECHNOLOGY NETWORK | No Comments