cbruhn2's blog
Submitted by cbruhn2 on Wed, 2007-02-14 08:59
When you setup statspack with level 6 you can have information on the sql_plan associated with a sql. (statpack on oracle db version >=9i)
Submitted by cbruhn2 on Wed, 2007-02-07 04:58
When you setup statspack with level 6 you can have information on the sql_plan associated with a sql.
Submitted by cbruhn2 on Wed, 2007-01-17 10:38
Today I have been experimenting with the new feature of continous mining with logmnr.
- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
- ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
or we don't see the funny things in the redologfiles
I now starts the logminer session in one window with :
[code]
BEGIN
dbms_Logmnr.Start_Logmnr(StartTime => SYSDATE - 1 / 24, Options => dbms_Logmnr.dict_From_OnLine_Catalog + dbms_Logmnr.Continuous_Mine);
END;
/
SELECT *
FROM v$Logmnr_Logs;
Submitted by cbruhn2 on Fri, 2007-01-12 09:15
During a test of some backup setup with rman I ran into problem running the restore / recover command.
|
