Tag: Database & Technology

Learn about what to audit and why during database auditing.

To recap where Part 1 of this article series ended, we finished using Database Workload Capture to collect two different workloads from an Oracle 11.2.0.3 database — one OLTP workload, and one DSS workload — and saved the resulting shadow capture files for eventual transference to a new platform for Database Workload Replay testing and evaluation.

To recap where Part 1 of this article series ended, we finished using Database Workload Capture to collect two different workloads from an Oracle 11.2.0.3 database — one OLTP workload, and one DSS workload — and saved the resulting shadow capture files for eventual transference to a new platform for Database Workload Replay testing and evaluation.

To recap where Part 1 of this article series ended, we finished using Database Workload Capture to collect two different workloads from an Oracle 11.2.0.3 database — one OLTP workload, and one DSS workload — and saved the resulting shadow capture files for eventual transference to a new platform for Database Workload Replay testing and evaluation.

Code boxes for Exadata Security

Listing 1: Database Workload Capture: Setup and Execution Listing 2: Terminating OLTP Workload Capture Listing 3: Query for Displaying Workload Capture Results Listing 4: Workload Capture Results

Listing 1: Preparing for Database Workload Replay Listing 2: Combining OLTP and DSS Workloads for Database Workload Replay Listing 3: Initializing Database Workload Replay Listing 4: Starting Workload Replay Client Sessions Listing 5: Starting a Consolidated Workload Replay Listing 6: Tracking Consolidated Workload Replay Progress Listing 7: Consolidated Workload Replay Statistics Listing 8: Workload Replay…

Listing 1: Preparing for Database Workload Replay Listing 2: Combining OLTP and DSS Workloads for Database Workload Replay Listing 3: Initializing Database Workload Replay Listing 4: Starting Workload Replay Client Sessions Listing 5: Starting a Consolidated Workload Replay Listing 6: Tracking Consolidated Workload Replay Progress Listing 7: Consolidated Workload Replay Statistics Listing 8: Workload Replay…

Security is a major topic in today’s world. As I’m writing this, I have just completed another quarterly security audit on critical systems. This doesn’t sound like the traditional job of a DBA, but managing storage, backups, monitoring, patching, performance tuning and, yes, security are all DBA tasks.

By Ian Abramson In sports, we talk about defense being a team game. One person alone cannot save a team from defeat; the entire team must work together to support a strong defense in order to win. It takes more than a hot goalie to win. The same can be said in the age of…