Monthly Archives: novembre 2014

Fine grained audit
  • 26
    Nov

Fine grained audit

Feature introduced from the RDBMS 9i release. Fine grained auditing extends Oracle existing auditing capabilities. Main features: - Regular auditing must be enabled using the parameter AUDIT_TRAIL. FGA does not require any parameter change . - Sql bind variables are captured by default in FGA - In FGA auditing is more flexible when certain columns are accessed, when...

Read More
RMAN detect corruption
  • 17
    Nov

RMAN detect corruption

You can validate your database using Oracle Recovery Manager command BACKUP VALIDATE. RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL; No backup is created. If there are block corruptions you can find them in the dictionary view V$DATABASE_BLOCK_CORRUPTION . By default the execution of “backup validate” only check physical corruption. You must add the CHECK LOGICAL clause if you want...

Read More
ORA-01555  Snapshot too old
  • 10
    Nov

ORA-01555 Snapshot too old

ORA-01555 is caused by Oracle read consistency mechanism. When you run a select all data refer to the same "Instant", from the first to the last selected row, for the entire duration of the processing and for how many changes are made on the selected tables from other transaction. When read consistency is not more possibile, the error...

Read More
Creating Tablespaces in ASM
  • 4
    Nov

Creating Tablespaces in ASM

When ASM creates a datafile for a permanent tablespace (or a temporary file for a temporary tablespace), the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the...

Read More