/* ------------------------------------------------------------------------- * DBMS_SWRF_REPORT_INTERNAL PACKAGE * * This package will handle the reporting for AWR. The report main * routine will be called by the dbms_workload_repository.awr_report * function. * ------------------------------------------------------------------------- */ /* * ------------------------------------------------------------------------- * DBMS_SWRF_REPORT_INTERNAL error code summary * * -20001 : error in the report main, at the top of the error stack * -20002: internal error in ith_displayable_child routine when passed * invalid arg tree_idx * -20003: internal error in ith_displayable child routine when passed * invalid arg child_idx * -20004: invalid argument passed to dflt_align_for_type, internally * -20005: error initializing the report due to missing snapshot data * -20006: missing start value for dba_hist_librarycache * -20007: missing end value for dba_hist_librarycache * -20008: missing init.ora param * -20009: missing system stat * -20010: missing start value for dba_hist_waitstat * -20011: missing end value for dba_hist_waitstat * -20012: missing start time wait value for dba_hist_system_event * -20013: missing end time wait value for dba_hist_system_event * -20014: missing start value for DBA_HIST_LATCH gets and misses * -20015: missing end value for DBA_HIST_LATCH gets and misses * -20016: missing value for SGASTAT * -20017: Missing start value for DLM statistic * -20018: Missing end value for DLM statistic * -20019: invalid begin_snap/end_snap pair specified by user * -20020: invalid dbid/inst_num pair specified by user * -20021: missing start value for time model stat * -20022: missing end value for time model stat * -20023: missing start and end values for time model stat * -20024: failed to reset time zone * * -20100: invalid flush level specified to create_snapshot * -20101: no valid snapshots in range (bid, eid) for database id dbid * -20102: user name 'schname' is invalid * -20103: directory name 'dmpdir' is invalid * -20104: not allowed to specify the 'SYS' user * -20105: unable to move AWR data from schema to SYS * -20106: cannot move data from newer AWR schema * -20107: not allowed to move AWR data for local dbid * -20108: cannot move data from newer AWR schema * -20109: error encountered during move_to_awr * -20110: invalid Top N SQL value. not allowed to specify 0 or 1. * -20111: invalid Top N SQL string: topnsql * * -20500: Invalid input to generate ASH report * -20501: Invalid input to helper function to create report * * -20600: Invalid (dbid, version) for DB Feature Usage * -20601: Invalid (dbid, version) for High Water Mark */ create or replace package dbms_swrf_report_internal wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 9 9738 206d evIH7Hvw061aB+cWkM5JC6OuMFkwg1VMHscFYaeacjrVV7y3DcdJ3qL8THiQa1paBuxmiKyb jA9XGGLG7MWn6vETn7ADqvjhj5mPHXsaiVXaHinNLqTk/61XlnZ2qRqw/eqSNj4oD7zNFVX+ zQtTTLx+Yfi4gTQPSE8f9unGIBk0zI4zlr8cME7KoPeCveie+H9xW1tFthb/z9/mvJtOSWPr Jw3R+hF6LES/HPJpinIY4DhDo/7wJrn2H/Ua5rXOuQnzqgQM6S1iWzgeeBpddfBWgP675tm9 UEZ8Y3FbX7CAGx020gRw6JpAQM1K5tTynn1xCSbh9f1GIptxJOdeCJujaVf3MN15jx6oM1+e qWDGrtZYspHKtNbgLoI2+oBLeWJlJRd85vAvQfNG6CocB7zav1nZWIm9nP9Jwoz0S/L13mZl TfKV9eSPZavYNTnEBq953Y9hqyi5pjm/2giP0XBLg21b/srW+PRgdvWEMqSrXiTBkj56y7eZ DYFK3k7k162EXiwogCIlZAR7pK5bsMOFMJucH+WnAm9DJ5l01WvBqk/BZmVKxsp3efYGRoaT ypWW50Ff/muGxEI/X5D7Apof7r2yuom+7NRBsw4+NXDFNc9tG0JEpLUSIRzv0MTmgc61SsYS Z4w+bKMOvVosjZu2m2Vq1XpE/NEjrcHhJTpNmTS9n5Ee/5TZSVtLAegLo2XmUT5VsR2xZNSd PnByAyQ/yHNu1aq1TKz5uI9JiL/6mfxTayZbRX5RCTW3LBeMelYzmQE6wSfEmj7QEzsJqIv5 3g1en9n4cydO2H4cjXPrCfSnuU//3ubmSojB0h38gHIojruCVi58s2Vm5Z2Oh9+wJZOkOMup NdwuZOYw6D1TcMr3QcmBnj0v3bhXzw/5nTw6bIDefpgjaQGMhIk/J+nbFqiiPxotq/P43lpb QUnV9/DUUkBWD0BT4allZYXTB+ThDpFXCsnP9mViqA8ryF0mB//wkTDBZTvTCBfaxeClic7a JkDy+sTRx4x5sVhQrwGM+DvZU/zwPwbmsw3BglvqLg6NTYk+E3TLAB+A7NDlhw+dmBG3PWik wScdOV/7lXpytpdEpLW/H4MSY06HiDRJKvoSCZrt6iNdJFzw5OYe8Zr1XJvVDWP3Dyc7yzp5 sCqK7apeiOIdMlr77TMOhPqBEjYlHp8FRomDK7oQm5yjrl7aXSCYo4D9dBSgwxVLBbvM/2q8 g2Px5WrcmOlDeSg57TzKc2okKlhZCHV0/q7LocGQ5L6yqOuGfS/p7Qx0TQXfKt8iS/AO3OKf kpA1mLEpD+gFFAJWW1e4AN56bAozyHNpmsPS/U+K6fVf2XC+VyKdD5afmK4XbbsFgqemifPs VMvXBTdDezhw92dNYLWbd8nVmca35MY6ZPM+RTDjRhSs5JsIJnPVlqx57qZ8Nw+HsXba8xQB nAZln6jCs188GdNoI+mXo1IVwa37ZWUJ+zzVNaZygAuxTyk1qVmIuQGYR6Hd9eLPXRov3qFj yl3gygVaS7L7oqoPYT6ARTSuz1UTQDcirefPoVIU16OdAQ1V+2he1MhsfWlGDDdtgfweTrAD gZtSqujPDwCKTyKQ3jvEFz7pCWiDkZtHLwseb1h4p5OU/j1uM22WHmObAQMQVEgkkCY+CkgK Mhs4ovy89x4s12QyqQ/WvYnnLv6KxD2ixRuonFz0A1D5OIHOVJWg6MXlofGmNwHnYF6pkrmy sAz0IQXhVobFhlNDrLRnkTqFZvIYEi8J+o4pGz6q4NiiR0ls2bUPvEE+mPjX2ZvrMXPJECs1 yJL8Gkqwb4gAIJeTs61t8dnB5I6G0lCzF+NDeh4zDuJvldI7epa888zTJ17mfQQnrgVDhrAD qhRdpc9uzPG3hipr1gPdxung1VVTnh2c5IazoDBs1vTrGpmFP04JDTE+OqHB6WuMlXO7lz+M NvP0WvkWlevRFOxCr0zjAFXIF/yqF49Oqk3tPAF672H4sDem8gcUnuc34a6lGlP1lQKOtzdG fN0EOlY1Gvroaern4W8lWyzQ6K6ZDHsksCupt7gF7VaFCU2RQd+b9JoOj0usCwLIRG3Z8lt8 CgeuF2xYFOizVio+RFGn3mYJFSnvkdl3CEuS72uSoCMwVCKZJoDKZrJX5oBhboY6fiu/f6pe zRjC5eYx7T/4YbT5jX3WnAcYr8QVSmLJFNhUzMh82PqeeseT17haU8OIJEfRfPR0BZXnvC82 63bh4RVveVpGQUjmR0eV29kGqGs4RU7M76soE+pRlEHxMkx1HRSgBtHZVnb3Mhsh9QvyikLI 3X2BCFK+XF+Vc+ubF2CAGqknzGnRp3Iouwl7V8r6JbyeCCCpJo9z1mWjIIUV4+q1jfqssGvB JUdz/XDfzt4tTCIWGckD4hqsJ17615efSVmEyiwDeA+NWoQkSStmFM+RRawrkRTkQ2pgMQgD qNNURkBI4HU2CviVozHRHyiYR9vfAJXAG8q9ZgNoJGJBndGC0xnSy9ZjpUH5g43jrxFoziup /FDOvEzNrTWLdVa5RXnWknhOpFIr5pHXvWv4BDhw7P5vBaTGEvwTRM9sn0W0IhaWZvvgDLE3 ZUlhaHoXVPVtdKWSRvlxGZ2bJ5nPAHJTq6R+H3KYRNozL27ntpbsRrxCdRUFFkW/LSzz6S+E ztv9CcAiZYs/fYj7VsW5D8SYPSwM8UI89kN5YJUNeaO01jSvmtixD1p/vNXdQq3LFTFxM1gY NlJIuH33nstJF+YJI5q/X28Zfv4+9P0AbvCF/2oqL9TMquXs29eATFjwiZzNiz++BWKCzeyM fEvJUU/qCX+A8kuSYTS07YYIQHjGno6uOYC4OAFmBe79VZ5lzRyj6m7X/pUnctWJi/92lEK5 9d94Zr3Fxokf4coHZWwUjkrjQ0dQX5OUfIgeOmrEQ8TXM5bJk0oYefCPUbQKlroJqJSir7lX 48IvZ440QmjVVm1SjhEba9o4QYVrWeZ4S0J7YRwE62hG5bADtJokLfo0lMd/MqDOroU8KF3g /BFYFhHtMDEApTbwqTBttyUAyIxu104HiVadkV4LckJE2X1HZrpyv21kNJ9987QU51xp5+1j SckaqUn9mGxeVy7tneU+f4sQrazT4C1a0hETs3Na9BtdZhi2BaQpn4k9EIaDfsJbJk1zSR7X H8K4gOkGnBGktNG7nBSqF4gYwdBzLP9PjuHhvx0HtonXceWuZc7viNjP762ntFN+ZX+tdk/2 d+/EuiK7vkcShgeGrWFxW/FCIM8B5EWMCmni3OagHLAXESI12lpvXTKBbZ8aI8R9VZX4105O mz+u6mrGxj3twFIqI8Y6BC7tYQzlDRGqa27U1KHxh2jr6a46Dhbb29sZ/kcZ4Ab+s0eyadT5 W7ia8VTvOi1fmN7uCgszzsi+xiQoClW7vf5apnMj8TaIwCJPWaZz0GSXsRbdp3K1OkXPTMUP nNsdWvtrcc+G8ueXmqXekL/XJ/fvzk5Z7wCaIIzd3OYtGLVxjg4itdM8ZAVivVQEqk/ONwET SUNPWXPZHidzadcE62FMx5UMBLfPXNSce/0BWcRHCxJKsNfO3DBB9sKMP3GduUGns+k7okAU a8f7H64TUvmoksnAWnbXA27r/Lq4oJw9A0Z4IIrrTqerz9FUNIuvsGi0NC9cb09tG2T6td3b DC5Bf7DZEM6tLb4l4xJxREtmZ/Sb3r5YZKU7/ox195vu/lVPlunooCJ7lOsaJ/H/8SsJHMZk vYTm7wGrIPAKU2u2uIQvSLMCP8JvRPexR6U2sUMzpxmoEFR53pWVVnXDyOEfbVXV8lR3T7aG wiMihRd+mHhr886fFU29T8aBi5jm5YVznwOHtrEWuGWANELsk/p2f9YaIfrJZFqgGy5hKEP0 wpEaToAt12g+b6cqQFQDHuDENBc/jrBBZyjmBQ4FSA8oVv6lza2fjImvEe/9OqjN6KbRVWN8 2k2vO5AVR8y8u1Y3MgkEMb/4URsBrvfjfJocTDVw7XZ4nNqZid2SPlZTMuXPwuf9Gkt9FsoS 9fKe/eh8ICPB64r7BuhhMGiyVPIqTrcm3P1VIjn0JslKZmfLBmWuqIHWr8sfZ1PLsNxF5LYP ++5FUYjP0ogbF67b93f81rhYxBTthASdR0xZz1wdnDqZ7dP71N5iGcviHQ1PpzqZHo+9YZzu Zao1YYcdsW/O9IhxQNnkAt8iwTXeF2M2sUNOyblGw0DZ5EQDHe8jjq3hj5JsV+edRw/UIuZH MWDIOrJtVzbdDcf58X/aqV7HVzbbAfnmUZBTKnJpQPbBUnyq3hf55p4TL9r7nCMBU+Kp/QXY e+GPI0Q/GkZOKIZlqmvpgpXJVVmISGndAS0UagH55tnJfJ3cCqkdCB5NcWw1ElFXEsPpGOue TmrLDhkpoJnAFbhYnVmK880NAgTDCPWZV6RGHpS4t6ashnMCMoviNQhQiF1SSzJjgo64xxad SNXQ1gge5a2tf8hPp2rwqeSDrWgE4x5dQzYGRa3tZ8Gx2e56yp0/y1uQmsqWSS94jk6Pwa3h PdbtK8vqRU+WryatdnlLZ7ijQSxbie6D4f9b2TH67g4j+uQCDekIjmEZMyNoRZNbsR8z1Y8Q ZyDKucfCjFEdV6idyNN523l+ARNTbw+qIwRYfK34ce0TmsEMUuxpqhgCCnScOtloZkQABJw6 mZjf+9S9gdFkRx1TRw9Rmft6aUAexx6YARWBWDpt6TmtTogvnDoMN5D1/v86DGJxi5bS83wF YN90nDrZKpsCx3Ct0U6cJgzSUR3+gNbLF1vzbMYy6dqpOoHOzhOTy4kPi5b6OFsRT4IEjlLI 5GWF5ESu0nxQc72szoHIHp13FQH5Zb9ZeG4uyQ7O/SfPaKtF6iNYOzaxi05Ism5TT0CGRc9P TTnixjoXfNaGU0iQ7tfuU/udroH68Znb9HN7fNx5DVMCg53i+8M6pEikDhtTfX3Rj0ie8jdY cnCWnmzPeeapkHG6dSCs8jdMGatSW/02jmjU4bAqDT0fkjlPedk24Vt6UBOH1q3LDHsu71rG 3052e4SCZvv75WxnNvvJQYS1AYz2kWpXYQypykqk4jTdNjtyel4oUDhwi603/X3fhIMtjAw3 cftZQAIUEIagxY3h+K1JwfcJysQBZsirYviosHbC/+fXYN5yvFw5oqZwi621aw8ej7nolw0Q gsrb+yEZx88acnzGw56KiR2zNXB4xFHm168NP4xslHSKwTzDfLjIusOv3agPAj2mwM0PwuU8 ++U6Mo0dDDejPzgC4QU6ApSeil0fKxZ8xAesue3D4r12aJLfME5jYfhmL/9S3fs73UBIBcPi KHb7NxB0DevFfrQ18HANjG+pbB//2ansEcvu3rY+S2InlMuKXYleI9Y0dLRiR39OrT5LSf/M 41o+fE52xU0E+gnKv0EuKK2P3UfHX25tLFe+eQjdcX9JROV6ac+0WstWfuVLKh37mZjFFktL O6zhmfjFFktLLazhmdrVFml+Vcgkzkt9fRgSUoOuWK//uZXXMLLKse0tgam8lucwumdUO3za 8C7+6glwi63/z6cSkvKeiufVwh6cIkFUOYqbZ4ol/nZwL8hyrc7LvH24AODZoMyycIutzstq KLVc4gx+vjo/TdIzYAw07zZvDXKxrUU+dtDZN+znNrtUvtwtC4gqoJcNGBD8Uqw/Gt1Hx3Fx mbTVcQbngLbjTRDuPFqyysTVT4g+BKZ2p1tlgk3S+dwMWitFeZg5EW3bMl+CytvqW+AksDnG n70v2y1dyKh2rqbdSL24NvszosqYrJ5SpuIgWTNd0vvJcH8kL8voSI+YqTe0vSFEGtI5nDAy ZDlpYrhGXIWEO93z513FkRCil8tbxSeAj+edPIWB0AtK3dKFKsgdfluluZ6xNWHUhqt5WDiv x6nwk+IHbhGUkcvwHqjG3MuGTQgAkSxqEoWjbZ2nXJm0/8dGAo08/F2t5jdxkAua3a4cIeIH dvtr6u++HMIXhmi+Ao5XL6kGrwKOV46eFAjJY9JvF22WyCdH9x6ogGdNKzqZapFKZlSefsGt FTOk7JdPIs7i8N3Hip5CgYLkSH6uNua/Q+yDlqYMHE6WHZ6txpQBjeEHrcqWCtIcIArnVrwa a3QW4itPa9lu6N5EylYAJ81uTXoMPkteNqxHa71Bxx3+di0Hzx3+djsPpuHplOoKq4sEb6l8 x6C66UmuhJOed/Jx0TXyN81RwHB2RFt87jg9uYupUEsn/hhnaVQN+K3Kd/oF1mYvXa3NOPRN L8eiO49d9BuaDvanuDC9QlH01vtPNlpw2LI2GXXE6QT1CH0UfPXX7ZThzqK2kAWiZGvxhxw5 XqFP6xre8B4As12AnDHJ4vSKdM+l9Bvhgs2TskhS9Oa4vEhfeXvte64h83bzJXVCUEmUw2IH 1mETXq5SmRl0MFE+ajcFBYjRZP9qriFjLExwKGwlnNlU/7Rj+MuSqEQz5mCSskSSVeJ9QumS Q2O6AfWcEKN+aQg4Lc5j7GjEpODRXscJcN0kq1jChaq+N/hoHRKQUkFa8lMYprWQvTVmknto fc23s9nqjQYXFFe9XqG0xmJROPrPQ1PTQIqUPCJlFvHkTx4TH/q3a4pk8WRVFkfnuwJ4jcL7 MR8kUbukNHLeJP30bia5Sx90gO+aTMUHD5LMZsCbUZoVcQzojT4A6Ld91og7YZkaIO1f5I1V BzwA0D/98LCUqjqobLd4rGfKpe00m8anLA9U0DKXP236432UQ+Qgtx9kF6NDrVAo5MOhWFJb +t5RUof/zrwBq23t/5j+JtZwv7m29m3F2JL5T90bkmCiNcMbqWhlX1mgom8RpQmsfaKxDzKY WsUgD73zPLpWbBUZ8B99giiPSAgk0hO40mPPi2iA8uSoJGpgRYL+ntYDN7MFDxHJqBzd09jA OFjERnmvV0RKik8IaDhP5zggzNAx//XZvksDuutGBLuNlCTf2seMFwxwZyOuq55nMvvigEkH ranmcS5PBTcl8eYdeBo+SYsqwEwnGI79zsfSSj8EvUTHmvPTrjVyJkCMu2Jvw9g8dS+wkZTL oVjdqE0iRv/p9t8fOzxxoJLHJlvufg+azql8bZrsMsOgjTmkqLkSszF4TPCMcu5Qw0TvXIJ2 E2BDCK9CmwRibXfy1SaBwezQBYx0PRRRE1ufTs7RKE62WUz2eoFghYYlNeStLXfEG+OQYgkf mMoNhJth12pm96+jP3zGeJKVAfeo8w95DaPOFcDi63iTicxaGE3Fq6Owb/DYV5auRjDF26fg wRzr5e0Yd0b0nDO9XxmSIlOnIftjQtyOyFzOS88XB7Sf1qXUZYyun3hrr5hS/42Ur1goGGZ6 YyvFGILEzdaREYDdXYUUvF7QdNrYriRTsXV0YPkq7QVlPSlOTfBJKsfXQp/k61SrVY+aZiV1 Xzi60ulMkzizX18XXrqz/iVopIRAYf3miv3CfGldWKDF94nYPS5OoTKjrSND5U/aSvraSVkk SUfmsC5gsNehsC4usNdpsC7DsNfqsC66sNeHsC7gsJcBAjuAPLPu/GbZLaxt/CHoNDqaoXBc WAzMiSzMYlxddUBcoYbFGlJVs0slEXGTIeJsq+oo8B4CXsPnuxhjZ96lUK5KKflMA//yzYfJ 0dwOmSEfZrhaLXnAL8ODPj6zFA/qfwGjyy66C9nLyKqvuSYDmqVgjYrKClpe/s61sfbcLENA I+SdohJ7LOboAgC6nYwDa23p5ERSR9yU2zbVHHypb//PVZz6y9bBGDEjbBA/gGn9YlZNDbOA fmAwIH5Gbxll3ca5AWMsuH+SqvHyHv6J/SpR/UbN3gOlNY474YRP7cM7xXdDlGPBty/XGS7y T3j2z49Qhezwcm+rHGIhZUqR91nin12YUYsResbGHIa0Mbp1j8swdzH6f/YHDl/CY3PUpU55 BIT+5z6O6Mw5JK5+aVDQS2pMRkYs0983oUUELqcGVpGtYtQT3aqybOFhz0OFv0v6ydWyJJp7 MW5PuDuBQLeYPPHrL8axf/AryMJWMlrtXP6hxeEw4EbEgmFnZb7ybeTotbgCOZ7TQK93gDD8 gxsr0bQ7K9iJbFe4T0CKui8rSow3s5HUFK0YOQWbLOnvyslwlgPap0A/Em4iIgWzVc0LEVkX EZ8aTAZcA/KwfsdtdrdWJYJ2Bv2qbmzDwpwy9fibmvlbalVnog== / SHOW ERRORS;