Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | 雲棲社區 | OSChina 博客 | Facebook | Linkedin | 知乎專欄 | Github | Search | About

第 70 章 Oracle 監控

目錄

70.1. Oracle日誌的路徑
70.2. SQL 日誌監控
70.2.1. 查詢性能分析
70.2.2. IO性能分析
70.3. session
70.4. SQL Monitoring Report

70.1. Oracle日誌的路徑

		
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER				         IS_
---------- ------- ------- ---------------------------- ----
	 3	   ONLINE  /opt/oracle/oradata/orcl/redo03.log	  NO
	 2	   ONLINE  /opt/oracle/oradata/orcl/redo02.log	  NO
	 1	   ONLINE  /opt/oracle/oradata/orcl/redo01.log	  NO

SQL>