cbruhn2's blog

cbruhn2's picture

Getting information about previously run commands with statspack

articles: 

Information


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)
cbruhn2's picture

Enabling plan_sql from statspack

articles: 

Information


When you setup statspack with level 6 you can have information on the sql_plan associated with a sql.
cbruhn2's picture

Experimenting with the continous mining

articles: 

Today I have been experimenting with the new feature of continous mining with logmnr.

My setup

  • 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;

cbruhn2's picture

Strange behavior from resetlogs.

articles: 

During a test of some backup setup with rman I ran into problem running the restore / recover command.

Subscribe to RSS - cbruhn2's blog