Why Use Fine Grained Auditing? Configuring Oracle FGA FGA Parameters Create FGA Policy Event Handling, Alerting More FGA Procedures FGA Monitoring Views Purging FGA Audit Data Why use Oracle Fine Grained Auditing? In addition to the Oracle Standard auditing, Oracle also provides Fine Grain Auditing to audit use of the objects at a more granular.
DBMS_ASSERT to protect against SQL injection
What is DBMS_ASSERT? NOOP function Check Function SIMPLE_SQL_NAME Check Function QUALIFIED_SQL_NAME Check Function SCHEMA_NAME Check Function SQL_OBJECT_NAME Enquote with ENQUOTE_NAME Enquote with ENQUOTE_LITERAL What is DBMS_ASSERT? The problems stemming from SQL injection has a long history. Intruders have used this package to hack into database systems and upgraded their privileges, obtaining access in areas they.
Upgrade Classic Extract to Integrated Capture
Upgrading Classic Capture Place the parameter file for the new extract XVST1 in the $GG_HOME/dirprm directory. Add and Register the Extract From GGSCI add the extract process. Then register the extract process in the database. Upgrade Classic Extract to Integrated Capture Try upgrading the registered process. An error will be returned. Reset to the process.
Temporary Tablespace Management
A couple of new features have been added in Oracle database 11g to make it easier to manage temporary tablespace use. The first one allows the shrinking of the temporary tablespaces and the second one allows the assigning temporary tablespaces to the global temporary tables. In this article we will look at both of these.
Introduction to Golden Gate. How it is different from Data Guard?
When the economy is still faltering and unpredictable, what more could you wish for, than to have a gate made up of Gold. Though Oracle Goldengate may not be the physical gold but the ease with which it solves the peer to peer replication problems amongst other things certainly makes it worth of Gold. It.




