Diagnostic and Tuning Tools(4)
来源:互联网 发布:男士围巾知乎 编辑:程序博客网 时间:2024/06/05 11:50
TS and Tuning
Instance/database:
v$database
v$instance
v$option
v$parameter
v$backup
v$px_process_sysstat
v$process
v$waitstat
v$system_event
Disk:
v$datafile
v$filestat
v$log
v$log_history
v$dbfile
v$tempfile
v$tempstat
v$segment_statistics
Contention:
v$lock
v$rollname
v$rollstat
v$waitstat
v$latch
Memory:
v$buffer_pool_statistics
v$db_object_cache
v$librarycache
v$rowcache
v$sysstat
v$sgastat
User/Session
v$lock
v$open_cursor
v$process
v$transaction
v$px_sesstat
v$px_session
v$sesstat
v$session_event
v$sort_usage
v$session_wait
v$session
v$session_object_cache
每一个资深DBA手头都有一大堆脚本,都对这些了如指掌,也就是有自己的工具箱。
Level of Statics Collection
The initialization parameters that determine the level of statistic collection are:
1.STATISTICS_LEVEL
2.TIMED_STATISTICS
3.TIMED_OS_STATISTICS
4.DB_CACHE_ADVICE
Instance/database:
v$database
v$instance
v$option
v$parameter
v$backup
v$px_process_sysstat
v$process
v$waitstat
v$system_event
Disk:
v$datafile
v$filestat
v$log
v$log_history
v$dbfile
v$tempfile
v$tempstat
v$segment_statistics
Contention:
v$lock
v$rollname
v$rollstat
v$waitstat
v$latch
Memory:
v$buffer_pool_statistics
v$db_object_cache
v$librarycache
v$rowcache
v$sysstat
v$sgastat
User/Session
v$lock
v$open_cursor
v$process
v$transaction
v$px_sesstat
v$px_session
v$sesstat
v$session_event
v$sort_usage
v$session_wait
v$session
v$session_object_cache
每一个资深DBA手头都有一大堆脚本,都对这些了如指掌,也就是有自己的工具箱。
Level of Statics Collection
The initialization parameters that determine the level of statistic collection are:
1.STATISTICS_LEVEL
2.TIMED_STATISTICS
3.TIMED_OS_STATISTICS
4.DB_CACHE_ADVICE
- Diagnostic and Tuning Tools(4)
- Oracle diagnostic and tuning tools
- Diagnostic and Tuning Tools(1)
- Diagnostic and Tuning Tools(2)
- Diagnostic and Tuning Tools(3)
- tuning 2 Diagnostic and Tuning Tools
- ORACLE9i_性能调优基础一(Diagnostic and Tuning Tools)
- Diagnostic Pack & Tuning Package
- MySQL Performance Tuning: Tips, Scripts and Tools
- OVERVIEW OF DIAGNOSTIC TOOLS
- Ubuntu Hacks : Tips & Tools for Exploring, Using, and Tuning Linux
- 16 Tools for Server Performance Tuning and Monitoring
- Performance tuning tools
- Mysql Tuning tools
- OReilly.Ubuntu.Hacks.Tips.and.Tools.for.Exploring.Using.and.Tuning.Linux.Jun.2006.eBook-BBL
- 4-Gigabyte Tuning: BCDEdit and Boot.ini
- javax.tools.Diagnostic 类使用示例
- Checkpoint Tuning and Troubleshooting
- Diagnostic and Tuning Tools(1)
- 我的MP3
- Diagnostic and Tuning Tools(2)
- c中数组置空和数组拷贝函数
- Diagnostic and Tuning Tools(3)
- Diagnostic and Tuning Tools(4)
- JSP语法和指令以及乱码问题
- 鼠标移动到button上时候,会引发OnEraseBkgnd和nCtlColor消息
- c语言的点点滴滴
- 黑客的常用攻击方法及预防措施
- IE出现运行错误,怎么办?
- linux socket program
- CSDN网页IE错误
- Unable to find explicit activity class