Home

cbruhn2's blog

Getting information about previously run commands with statspack

Submitted by cbruhn2 on Wed, 2007-02-14 08:59.
cbruhn2's picture

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)

»

Enabling plan_sql from statspack

Submitted by cbruhn2 on Wed, 2007-02-07 04:58.
cbruhn2's picture

Information


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

»

Experimenting with the continous mining

Submitted by cbruhn2 on Wed, 2007-01-17 10:38.
cbruhn2's picture

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;

»

Strange behavior from resetlogs.

Submitted by cbruhn2 on Fri, 2007-01-12 09:15.
cbruhn2's picture

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

»