Microsoft SQL Server Baselines – Why are they important?

The importance of SQL Server Performance Baselines No one loves to hear they have performance problems, especially when it comes to their production SQL Server databases. If a database performance problem should occur knowing where to start troubleshooting can be difficult. Once a SQL Server performance abnormality is found, how do you know if [...]

By |2018-08-30T22:50:06+00:00August 30th, 2018|Database, Uncategorized|Comments Off on Microsoft SQL Server Baselines – Why are they important?

Direct Path Reads in Oracle Database 11gR2 page 2

Direct Path Reads Solution Explained: So, how do you solve the “ direct path reads ” problem (where the same data is being constantly re-read from disk)?  There are a couple of suggestions. Put the table in question in the KEEP buffer cache.  This is a two-step process.  First allocate memory for the KEEP [...]

By |2018-05-18T16:40:00+00:00February 23rd, 2018|Database, Oracle|Comments Off on Direct Path Reads in Oracle Database 11gR2 page 2

Move Oracle DB Audit Trails To A New Tablespace

There are times when it is necessary to move Oracle DB audit trails to a new table space.  Auditing is the monitoring and recording of selected user database actions. In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema objects, and network and [...]

By |2018-01-18T20:34:36+00:00January 18th, 2018|Database|Comments Off on Move Oracle DB Audit Trails To A New Tablespace

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 => [...]

By |2018-05-18T16:40:56+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace Continued

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 [...]

By |2018-05-18T16:41:04+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace