Small knowledge, big challenge! This article is participating in the creation activity of “Essential Tips for Programmers”.

Oracle AWR reports are used to analyze database failures and performance indicators report!

Awr reports are usually generated on the database server side by executing commands under the Oracle user:

sqlplus / as sysdba @? /rdbms/admin/awrrpt.sqlCopy the code

After execution, generate an HTML report, Linux server cannot view it directly, need to be removed from the server!

However, there are exceptions, some database servers prohibit fetching files! What to do?

At this point, we can connect to the database through PL/SQL Developer, do local export, or configure the Oracle client to do local export!

⭐️ The following shows how to use PL/SQL Developer to export AWR reports:

If executed in command, the following error is reported: So, how to solve it?

Need to find a database server that can retrieve files, will$ORACLE_HOME/rdbms/adminFour files are retrieved from the directory:Then you can execute.

This is the end of sharing ~

If you think the article is helpful to you, please like it, favorites it, pay attention to it, comment on it, and support it four times with one button. Your support is the biggest motivation for my creation.

❤️ technical exchange can follow the public number: Lucifer think twice before you do ❤️