Log miner procedures are given as follows:
The following two functions can also be used with log miners:
Alerts are traction based. Whenever, a traction causing event of interest commits, the alert is signaled.
You can use the dbms_scheduler package to create and schedule a database job.
Oracle has provided a package called dbms_fga to implement fine grained auditing.
It contains the following procedures:
You can use the dbms_metadata package to retrieve object definitions from data dictionary by specifying the following:
Flashback feature provides the following benefits:
Following procedures can be used to encrypt or decrypt data in different formats:
You can resize a datafile by using the ALTER DATABASE DATAFILE <file_name> RESIZE; statement.
Oracle provides a package called dbms_application_info. This package can be used to set information about current session.
A session can register itself for a specific type of alert or a alerts by using the register procedure. Such sessions are called waiting session.
The dbms_lock package can be used to create user defined locks.
The information processed by log miner is stored in the v$logmnr_contents view.
You can be use the dbms_logmnr.mine_value and dbms_logmnr.column_present procedures with the data in the v$logmnr_contents view to review the information.
You can use the dbms_profiler package to collect and store profile information about a PL/SQL application.
Oracle provides the dbms_aqadm package to create an advanced queue. This package can be used to create, alter, and drop AQ.
The procedure that provides these functions are given as follows:
This can be determined by using the fine grained auditing feature for the table.
You can use the fine grained auditing features of Oracle.
Flashback feature allows you to use a flashback version of the database, that is, you can query the database from a state in the past based on a specific System Change Number (SCN) or time in the past.
You can use the DBMS_LOGMNR.START_LOGMNR procedure to initialize the log miner.
The procedures available in the dbms_application_info package are set_module, sect_action, read_module, set_client_info, read_client_info and set set_session_longtops.
Oracle provides the dbms_flashback package to use flashback feature.
The package has the following procedures to facilitate this feature:
The operating system files generated by utl_file are owned by operating system user Oracle.
Yes, you can use the dbms_redefinition package to redefine a table online.
You can use the dbms_redefinition.can_redef_table procedure to determine if a table can be redefined.
Oracle provides a feature called log minner, which can be used to view data changes from previous tractions.
You can use the dbms_mview package to deal with materialized views. It is also called dbms_snapshot.
Some of the procedures provided by the dbms_mview packages are as given follows:
Oracle supports asynchronous notification using the dbms_alert package.
Oracle provides a package called dbms_aq package to queue the messages, which can be consumed by another session or application in order.
The dbms_stats procedure performs the following general functions:
Some of the procedures provided by the dbms_aq package are enqueue, dequeue, register and unregister.