![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB management
文章平均质量分 75
tech2011
这个作者很懒,什么都没留下…
展开
-
AWR - Automatic Workload Repository
存档下,有时间再读~The AWR<br />To properly collect database statistics, the parameter statistics_level should be set to TYPICAL (the default) or ALL.<br />The Oracle database uses AWR for problem detection and analysis as well as for self-tuning. A number of diffe转载 2010-10-26 17:40:00 · 1340 阅读 · 0 评论 -
Brief introduction into Materialized Views
Brief introduction into Materialized Views<br />This week, I am teaching an Oracle Database 11g Data Warehouse Administration course in Munich. One of the focus areas of that course are Materialized Views, and I have developed some examples for that course转载 2011-02-23 16:59:00 · 375 阅读 · 0 评论 -
表空间使用率
<br />SELECT c.tablespace_name "表空间", ROUND(a.bytes/1048576,2) "表空间大小",ROUND((a.bytes-b.bytes)/1048576,2) "已使用空间",ROUND(b.bytes/1048576,2) "剩余空间",<br />ROUND(b.bytes/a.bytes * 100,2)||'%' "剩余百分比" FROM<br />(SELECT tablespace_name,SUM(a.bytes) bytes<br />FR原创 2011-01-08 20:21:00 · 508 阅读 · 0 评论 -
分区交换exchange
How to move or transport table partition using Transportable Table Space (TTS)? [ID 731559.1] -------------------------------------------------------------------------------- 修改时间 03-AUG-2009 类型 HOWTO 状态 MODERATED In this Document转载 2010-11-10 18:43:00 · 572 阅读 · 0 评论 -
归档日志的切换频率
<br />SELECT TRUNC (first_time) "Date", TO_CHAR (first_time, 'Dy') "Day",<br /> COUNT (1) "Total",<br /> SUM (DECODE (TO_CHAR (first_time, 'hh24'), '00', 1, 0)) "h0",<br /> SUM (DECODE (TO_CHAR (first_time, 'hh24'), '01', 1, 0)) "原创 2011-01-03 09:29:00 · 4123 阅读 · 0 评论 -
分区表(1)
<br />drop table tb_part_test;<br />drop table tb_part_test_singe1;<br /><br />create table tb_part_test(id number,name char(20),hire_date date)<br />partition by range (hire_date)<br />(<br /> partition P1 values less than (TO_DATE('2010-09-01 00:00:00',原创 2010-11-01 13:38:00 · 232 阅读 · 0 评论 -
Logmnr分析重做日志文件
<br />有三种方法能得到数据字典的方法:<br />1)、将数据字典提取到一个平面数据字典文件(DBMS_LOGMNR_D.STORE_IN_FLAT_FILE)<br />2)、将数据字典提取到重做日志文件(DBMS_LOGMNR_D.STORE_IN_REDO_LOGS)<br />3)、使用当前的数据库的联机数据字典(DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG),只能分析当前数据库的重做日志文件,此时就不需要平面字典文件。<br /><br />例子:<br />1转载 2010-10-30 17:46:00 · 834 阅读 · 0 评论 -
Understanding the SCN
<br />Understanding the SCN<br />In order to understand how Oracle performs recovery, it's first necessary to understand Oracle's SCN in terms of the various places where it can be stored and how it's used for instance and media recovery.<br />The SCN is a转载 2010-10-27 16:05:00 · 393 阅读 · 0 评论 -
redo
<br /><br />查看redo等待<br />Select Wait_Class, Event, Total_Waits, Total_Timeouts, Time_Waited, Round(Time_Waited / 100 / 60, 1) Time_Wait_Minutes,Average_Wait<br />From V$system_Event<br />Where Lower(Event) Like '%log%' Or Lower(Event) Like '%redo%'<br /原创 2010-10-27 10:22:00 · 466 阅读 · 0 评论 -
logmnr
<br />exec sys.dbms_logmnr.add_logfile(LogFileName=>'/u01/app/oracle/archivelog/1_82239_700244171.dbf',options=>dbms_logmnr.new); <br />exec sys.dbms_logmnr.add_logfile(LogFileName=>'/u01/app/oracle/archivelog/1_82246_700244171.dbf'); <br />exec dbms_logmn原创 2011-04-13 17:07:00 · 348 阅读 · 0 评论