Shulou(Shulou.com)06/01 Report--

Let me introduce a set of oracle database monitoring and management scripts.

The script for oracle monitoring is relatively comprehensive, easy to use, you can also expand their own functions on the basis of the script.

Directory installation monitoring script configuration database connection information window operating system linux | mac operating system connection database case configuration runtime parameters session monitoring Lock monitoring blocking Lock long unreleased Lock running slow SQL information session using PGA memory size session footprint undo space size session using cpu time session temporary tablespace size session temporary tablespace details session uses cursorsession overall situation Pre-wait event current non-idle wait event current hot block wait event current Hight Water wait event current specified wait event SQL monitoring and tuning analysis SQL execution plan analysis SQL operation information sql profile solidification outline solidification custom outline solidification custom outline2 view sql profile information SQL tuning sql text tuning v$sql_plan execution plan SQL ACCESS optimization 11g SQL monitoring SQL monitoring list SQL monitoring report SQL monitoring details automatic sql tuning report tracking event 10064trace 10046 event get trace file tkprof analysis trace file 100531050010237 cancel running SQL space and file monitoring tablespace usage temporary tablespace usage undo tablespace usage data file usage temporary tablespace file usage online log file information Table footprint information segment pair For example, segment object spatial analysis consultant data file IO information statistics segment object IO statistics ASM information target=) memory monitoring SGAPGA database buffer (db_buffer) shared pool (share_pool) object large query results cache in buffer (11g) tool script get DDL script get full-text index creation script get Object creation script get specific type object creation script get schema The creation script with an object checks how the index wrapper foot decrypts the encryption package to get the above script

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.