The invention discloses an automatic performance identification tuning
system based on an
Oracle database, belonging to the technical field of
database management. The
system comprises a performance acquisition module, a performance analysis module and a
performance tuning module and is characterized in that: the
performance tuning module comprises an
SQL (structured
query language)
sentence-level tuning module, an instance-level tuning module, a logic object-level tuning module and a
system-level tuning module, wherein the
SQL sentence-level tuning module, the instance-level tuning module, the logic object-level tuning module and the system-level tuning module in the
performance tuning module are connected with the performance analysis module respectively; and the performance analysis module is connected with the performance acquisition module. The system disclosed by the invention has the beneficial effects that: intelligent analysis and tuning on the
Oracle database are realized, the traditional optimization method simply using manual and artificial judgment is changed, the DBA is released from the complicated operation and maintenance environment, the
operational stability of the database is greatly improved, and the labor cost is saved.