How to set Statspack to display complete SQL statements

This article mainly introduces "how to set Statspack to display complete SQL statements". In daily operation, I believe many people have doubts about how to set Statspack to display complete SQL statements. Xiaobian consulted all kinds of information and sorted out simple and easy to use operation methods. I hope to help you answer the doubts of "how to set Statspack to display complete SQL statements"! Next, please follow the small series to learn together!

When statspack file is generated with spreport.sql in 10g, SQL statement only shows 5 lines, which is often incomplete, sometimes complete SQL is needed to further analyze SQL performance problems. Tuning specific SQL statements.

Look at the/oracle/oms/102_64/rdbms/admin/spreport.sql statement in Oracle10g, which calls the sprepins script, which calls the sprepcon.sql script. In sprepcon.sql script, define num_rows_per_hash=4; //means that each SQL can display at most 4 lines. If some SQL is long, you can set num_rows_per_hash=100;//short SQL, all SQL will be displayed. If the sql is long, it can display up to 100 lines.

At this point, the study of "how to set Statspack to display complete SQL statements" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!