Method and device for restoring parameters in Oracle database access traffic

Abstract

The invention discloses a method for restoring parameters in Oracle database access traffic, which comprises the following steps: analyzing a received access traffic packet aiming at an Oracle database to obtain client information of a sending end corresponding to the access traffic packet; judging whether the client side information contains the PL / SQLDEVELOPER information or not; if yes, obtaining an SQL statement request from the access traffic packet; judging whether the SQL statement request contains lock information or not; if yes, acquiring a parameter type set contained in the access traffic packet; judging whether the parameter type set contains a special character string type or not; and if yes, performing parameter reduction according to a preset parameter reduction sequence. According to the invention, the parameters contained in the access traffic packet are accurately restored, and the audit effect of the access traffic packet is improved. The invention further discloses a device, equipment and a storage medium, which have corresponding technical effects.

Description

technical field [0001] The present invention relates to the field of storage technology, in particular to a parameter restoration method, device, equipment and computer-readable storage medium in Oracle database access traffic. Background technique [0002] When the client needs to access the Oracle database, when the Oracle database receives the access traffic packet, it needs to analyze and obtain the content to be queried specifically contained in the access traffic packet, and audit the content to be queried. Only when the audit passes, can the Respond to access requests. [0003] However, when collecting operation and maintenance records at present, it is found that the parameter value list submitted after the SQL statement is easy to appear in the PL / SQL Developer information, which leads to the inability to accurately restore the parameters contained in the access traffic package, which affects the access traffic package. audit effect. [0004] To sum up, how to eff...

AI Technical Summary

Problems solved by technology

[0003] However, when collecting operation and maintenance records at present, it is found that the parameter value list submitted after the SQL statement is easy to appear in the PL / SQL Developer information, which leads to the inability to accurately restore the parameters contained in the access traffic package, which affects the access traffic package. audit effect

Images