NoCOUG Summer Conference, Aug. 19, 2004.ppt

James F. Koopmann N-years of IT/core RDBMS experience Oracle (V6-10g) 8i 9i OCP Writer Various Publications Portals Speaker : Here, There, Anywhere The DBA nightmare How do you detect DDL changes STREAMS overview STREAMS environment STREAMS setup STREAMS sample DDL session OEM Sweat Dreams for the DBA Running STREAMS The DBA Nightmare Your actions are reactive, not proactive, in nature The events that trigger an investigation are often very specific to an incident, narrow in scope, and the solutions typically do not take the full health of a database into consideration. Most of your time is spent in problem investigation detection, not problem solving Investigation detection inherently wastes money Customers / users drive the work flow of the database administrators Database administration group is seen as ineffective Has the issue been seen by others? Will someone benefit from you working on the issue? Are you solving a real problem that is causing pain for your users? Before solving the problem, are you be able to determine what was the true root cause? Will solving the problem eliminate it from recurring? The DBA Nightmare How Do You Detect DDL Changes The DBA Nightmare How Do You Detect DDL Changes How Do You Detect DDL Changes How Do You Detect DDL Changes How Do You Detect DDL Changes How Do You Detect DDL Changes Oracle Streams Oracle Streams Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup Streams Setup OEM OEM OEM OEM Sample DDL Session Sample DDL Session Sample DDL Session The DBA Nightmare Sweet Dreams for The DBA Running Streams CREATE/ALTER/DROP Tables includes table comments CREATE/ALTER/DROP Tablespace (requires global rules to be set) CREATE/ALTER/DROP Indexes CREATE/