Solution : https://service.sap.com/sap/support/notes/1438410 (SAP Service marketplace login required)
Summary :
This SAP Note addresses limitations in accessing restricted Oracle database information through standard functions during SAP's Technical Performance Optimization or System Administration for Oracle. It provides an archive with crucial SQL statements intended to aid complex problem analysis. Users can modify certain parameters within the BASIS_INFO section, although default settings (-1 for NUMBER and '%' for STRING parameters) suggest minimal usage. The note emphasizes that no official documentation or support is provided for these scripts, liability for their accuracy remains with the user, and further details should be discussed within SAP’s specialized services.
Key words :
sap technical performance optimization - oracle sap system administration - oracle, oracle database analysis, analyze complex problems, important sql statements, determine database information, sap services, determine information, restricted manner, standard functions, normal functions
Related Notes :
| 1269911 | FAQ: Chained Rows |
| 1257075 | SQL_ID Data Collector (Oracle 10.2.0.2 or higher) |
| 927813 | Oracle 10g: Using Oracle Segment Advisor to optimize space |
| 771929 | FAQ: Index fragmentation |
| 706478 | Preventing Basis tables from increasing considerably |