Shulou(Shulou.com)06/01 Report--

Talk about how to do the sql audit of oracle database: 1. How to do the syntax check in advance? first of all, you should be familiar with the complicated oracle syntax specifications and be able to report errors in advance (this is not a problem). 2. The check of the column of DDL statements and the check of the index will only be found by direct implementation. Do you want to export all the structure of the table and check the operation again?

(seemingly feasible) then prepare an oracle database to store other database table structures

How does the 3.DML statement check for data conflicts? You can check without submitting things, but what if you encounter operations with a large amount of data? It will cause a lock of 4. How do I record a rollback statement? Can you parse the log? writing the log to redo,logminer first will reduce oracle performance, but do not roll back DDL statements, and insert, delete statements, mainly to prevent update statements, so back up the data select of pre-update statements in advance instead of directly generating rollback update.5. What does this workflow look like? a. The metadata of the target library is backed up to the audit library b. External parameters are passed to the audit program, including (ip,port,username,password,sql, backip,backport, backuser,backpass) c. The audit program is pre-executed in the audit library to see if there are any syntax errors. It is updated directly for DDL statements and directly executed for insert statements, d. Check the syntax for delete statements, so before delete, you have to back up and import to the audit library, and you can't check whether the data exists, e. For update statements, you can only check the syntax to import them into the backup library, because multiple tables cannot be exported for update with multiple table dependencies.

After the inspection, it means that it is passed, and you will operate the online library.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.