Tag: Database

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.

Original Broadcast: December 1, 2016 Monster VM’s was a Top 10 VMWorld 2016 presentation. This presentation will cover both Oracle and Microsoft SQL Server. Due to the high amount of content it will be broken into 2 parts. Databases by their very nature are Monster VM’s. If Monster VM’s are not virtualized properly they will…

Original Broadcast: December 1, 2016 Monster VM’s was a Top 10 VMWorld 2016 presentation. This presentation will cover both Oracle and Microsoft SQL Server. Due to the high amount of content it will be broken into 2 parts. Databases by their very nature are Monster VM’s. If Monster VM’s are not virtualized properly they will…

Original Broadcast: December 1, 2016 Monster VM’s was a Top 10 VMWorld 2016 presentation. This presentation will cover both Oracle and Microsoft SQL Server. Due to the high amount of content it will be broken into 2 parts. Databases by their very nature are Monster VM’s. If Monster VM’s are not virtualized properly they will…