Starting workload capture hangs – is it really problem with RAT?

Originally posted on “Databases at CERN” blog

If you plan to introduce changes in your environment and want to estimate their impact, Real Application Testing feature seems to be one of the best options. As we needed to check the influence of changes planned in our databases, I’ve started to look for good candidates to capture the workloads. I wanted to capture only workloads associated with small number of schemas, but from several databases, to be able to properly simulate as much types of production workloads existing in our databases as possible. This strategy would also allow us to use/test new Consolidated Replay feature of RAT. Ideal set of schemas should be responsible for quite a big amount of workload in the database, but should not be too big in terms of space – to be easily exportable using EXPDP with FLASHBACK_SCN option.

Continue reading “Starting workload capture hangs – is it really problem with RAT?”

Advertisements

Migrating to Oracle Database 12c – what to do with auditing?

Originally posted on “Databases at CERN” blog

If you consider migrating to Oracle Database 12c, no matter if you think of development, testing or production environments, one of many decisions you need to take is to define what to do with the auditing. The biggest new feature in this area is so-called Unified Auditing, which captures auditing information from different sources, like for example “normal” and FGA audit records, application contexts, RMAN or DataPump plus few others and stores it in common format and place, which is read-only, partitioned table in AUDSYS schema, by default residing in SYSAUX tablespace and using Oracle SecureFiles feature.

Continue reading “Migrating to Oracle Database 12c – what to do with auditing?”