Move Oracle Database Audit Trails To A New Tablespace Continued

  Create a new tablespace and size it large enough to hold the audit data:   SQL> CREATE tablespace "SYSAUD" datafile size 1G autoextend on;   Tablespace created.     Move the audit trail tables using procedure DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.   -- -- Move the SYS.AUD$ table -- SQL> exec DBMS_AUDIT_MGMT.set_audit_trail_location( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, audit_trail_location_value => [...]

2017-11-09T20:27:46+00:00 November 9th, 2017|Database, Uncategorized|0 Comments

Move Oracle Database Audit Trails To A New Tablespace

Move Oracle Database Audit Trails To A New Tablespace Auditing is the monitoring and recording of selected user database actions. For Oracle Database, the Oracle Database Audit Trails assist in the auditing process.  In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema [...]

2017-11-09T20:27:38+00:00 November 9th, 2017|Database, Uncategorized|0 Comments

Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS)

Case Study: Oracle GoldenGate for AWS - Migrate Oracle on premise to Amazon Web Services (AWS) A leading content streaming service required the live-migration of its critical 24X7 billing system with near-zero downtime. Performance Tuning Corporation designed a plan based on Oracle GoldenGate 12c to migrate the client’s on premise Oracle RAC database to a [...]

2017-09-20T06:32:05+00:00 May 9th, 2017|Performance Wire|0 Comments

Database Health Check

Database Health Check Offering at a Glance The PTC Database Health Check Service has been designed and approved by world renowned database experts. The offering is a quick, easy, and targeted service focused on arming you with clear evidence about the status of your database system performance and maintenance strategy.  Services Overview Performance and Maintenance Problems Identified with Recommended [...]

2017-09-20T06:33:04+00:00 April 20th, 2017|Performance Wire|0 Comments

Oracle RAC Deployment

Oracle RAC Deployment Performance Tuning Corporation has successfully implemented more than 300 Oracle Real Application Cluster (RAC) systems on UNIX, Linux and Windows. Below are some important things to consider before engaging your critical resources. Server, Storage and Network (SAN) Implementation Knowledge. Without these skills, it is impossible to properly configure and tune Oracle [...]

2017-09-20T06:33:14+00:00 April 20th, 2017|Performance Wire|0 Comments

Database Tuning Services

Database Tuning Services Service Overview This service is focused on determining the root cause or causes of existing Oracle or MS SQL Server database performance problems. At the end of this engagement a remediation proposal will be provided. PTC will apply its considerable expertise to determine the best course of action to get your database infrastructure running [...]

2017-09-20T06:33:24+00:00 April 20th, 2017|Performance Wire|0 Comments

Oracle Database Migration Service

Oracle Database Migration Service Basic steps for Migrating with Oracle GoldenGate The following tasks are high level steps to migrate to a new server using near-zero downtime with GoldenGate. Create project plan Identify transformations; i.e. new partitioning, new indexes, new security, etc.. Identify new hardware Configure OS on new hardware Install Oracle 12c (target) [...]

2017-09-20T06:33:36+00:00 April 20th, 2017|Performance Wire|0 Comments

Database Upgrade Service

Database Upgrade Service Offering at a Glance The Database Upgrade Service is intended for all customers looking to upgrade existing databases to the latest version. Cost and duration are dependent on a variety of factors and typically a consultative conversation is necessary. Services Overview Upgrade Pre-Implementation Planning A pre-implementation service, this cross functional planning [...]

2017-09-20T06:33:52+00:00 April 20th, 2017|Performance Wire|0 Comments

Oracle GoldenGate Consultant

[vc_row][vc_column][vc_column_text] Job Title: Oracle GoldenGate Consultant Description: We're looking for Oracle GoldenGate Consultants. The ideal candidate is someone who can work autonomously and independently. You possess at least three years experience with Oracle database design, Oracle Real Application Clusters (RAC), Data Guard, database administration and knowledge of Oracle backup & disaster recovery methodologies. Additionally, you have [...]

2017-09-20T06:34:47+00:00 April 17th, 2017|Jobs|0 Comments