如何收集表的部分统计信息
如果表很大,收集表的统计信息需要花很长的时间,这时可以仅收集表的部分统计信息提供优化器统计信息
收集表的5%的大小作为统计信息
Analyze table m estimate statistics sample 5 percent
如何分析在线日志或归档日志中的内容
Sqlplus “/ as sysdba”
SQL> select member from v$logfile;
MEMBER
--------------------------------------------
/home/oracle/oradata/fanu10/redo01.log
/home/oracle/oradata/fanu10/redo02.log
/home/oracle/oradata/fanu10/redo03.log
Sqlplus “/ as sysdba”
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/home/oracle/oradata/fanu10/redo03.log',
DBMS_LOGMNR.NEW); -----这里也可以是归档日志的绝对路径。
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE('/home/oracle10/oradata/orcl/redo02.log',DB
MS_LOGMNR.ADDFILE); ------这里可以增加多个分析内容的日志路径。
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(options=>16);
PL/SQL procedure successfully completed.
SQL> select sql_redo from v$logmnr_contents;
SQL_REDO
-------------------------------------------------------------------
delete from "SYS"."COL_USAGE$" where "OBJ#" = '324044' and "INTCOL#" = '1' and "
EQUALITY_PREDS" = '0' and "EQUIJOIN_PREDS" = '1' and "NONEQUIJOIN_PREDS" = '0' a
nd "RANGE_PREDS" = '0' and "LIKE_PREDS" = '0' and "NULL_PREDS" = '0' and "TIMEST
AMP" = TO_DATE('05-6月 -07', 'DD-MON-RR') and ROWID = 'AAAAHZAABAAAA1bABG';
delete from "SYS"."COL_USAGE$" where "OBJ#" = '324046' and "INTCOL#" = '1' and "
EQUALITY_PREDS" = '0' and "EQUIJOIN_PREDS" = '1' and "NONEQUIJOIN_PREDS" = '0' a
nd "RANGE_PREDS" = '0' and "LIKE_PREDS" = '0' and "NULL_PREDS" = '0' and "TIMEST
AMP" = TO_DATE('05-6月 -07', 'DD-MON-RR') and ROWID = 'AAAAHZAABAAAA1bABH';
发表评论
-
compile_6i
2010-10-12 21:35 535for %%i in (*.rdf) do start /w ... -
compile bat
2010-10-12 21:33 826compile_pll_form.bat for %%i i ... -
test26_7
2010-06-30 16:33 1315 使用索引:索引未用上?是否为表和相关的索引搜集足够的统计 ... -
test26_6
2010-06-30 16:32 1414 使用索引:索引未用上?检查被索引的列或组合索引的首列是否 ... -
test26_5
2010-06-30 16:31 64413 使用索引:合理的索引针对如何用上合理的索引,以下举ORA ... -
test26_4
2010-06-30 16:30 59111 使用索引:建立索引的原则1、索引字段需要建立NOT NU ... -
test26_3
2010-06-30 16:29 5419 索引种类:位图索引Create BITMAP index ... -
test26_2
2010-06-30 16:28 5147 索引种类:反向索引Create index indexna ... -
test26_1
2010-06-30 16:26 6634 索引概述:什么是索引索引是建立在表的一列或多个列上的辅助对 ... -
test26_0
2010-06-30 16:25 5421 Oracle 索引 2 Contents索引概述什么是索 ... -
test24
2010-06-30 15:53 565处理exp Exporting questionable st ... -
test23_1
2010-06-30 15:49 623Argument Name ... -
test23
2010-06-30 15:47 531回收表的高水平位 表的高水平位(High water mar ... -
test22
2010-06-30 15:29 572dblink的使用1、现象、问题描述 在local服务器上有 ... -
test21
2010-06-30 15:29 589如何查询长时间的操作何时结束 数据库中有一个视图中v$ses ... -
test20
2010-06-28 16:48 504如何只恢复经过多次commit后的某个事务 SQL> ... -
test19_1
2010-06-28 16:45 499但ORACLE又提供了另外一种机制:从redo日志或归档日志中 ... -
test19_1
2010-06-28 16:43 439但ORACLE又提供了另外一种机制:从redo日志或归档日志中 ... -
test19
2010-06-28 16:43 666如何恢复删除并且commit ... -
test18
2010-06-28 16:39 482如何使一个经常用的小表一直保留在内存中? SQL> s ...
相关推荐
WIN32 release 25 September 2008 - Changes to investigate a BurnInTest crash problem on XP SP3. Release 5.3 build 1028 WIN32 release 11 September 2008 - Two 2D Video memory test crash bug workarounds ...
M25P16读写FLASH驱动FPGA代码,具有参考意义
Design Docs 25 Interfaces and Protocols 27 Automation Planning 28 Testability 29 SET Workflow: An Example 32 Test Execution 40 Test Size Definitions 41 Use of Test Sizes in Shared Infrastructure 44 ...
载入obj文件绘制了点,并改变颜色和位置
English | 25 Aug. 2016 | ISBN: 1491924136 | 250 Pages | AZW3/MOBI/EPUB/PDF (conv) | 16.77 MB By teaching you how to code machine-learning algorithms using a test-driven approach, this practical book ...
25_ov7725_rgb565_640x480_vga 26_ov7725_rgb565_640x480_lcd 27_ov5640_rgb565_1024x768_vga 28_ov5640_rgb565_lcd 29_top_sd_rw 2_key_led 30_top_sd_photo_vga 31_top_sd_photo_lcd 32_top_traffic 33_hs_ad_da ...
25_ad7606_vga_test.zip
SPI_TEST_BIN.2009.11.25.rar
单片机stm32vet6对闪存芯片操作 spi接口
1.敏捷开发强调测试先行,因为先编写测试代码,就可以有目的的预防某些bug的产生,要知道,治病不如预防!...相互独立的测试(Isolated Test) ……..... …·…….......... …………………………...... …………….......
These are the base requirements to build and use Google Test from a source package (as described below): GNU-compatible Make or gmake POSIX-standard shell POSIX(-2) Regular Expressions (regex.h) A ...
资料-AA24830L DVT3 Full test(25癈)_#8_DVT3.xmltd.zip
资料-AA24830L DVT3 Full test(25癈)_#8_DVT3.xmltd.xls
本帖最后由 yidi11 于 2012-5-25 17:44 编辑 使用PSO工具箱时,提示下列错误: ??? Subscripted assignment dimension mismatch. Error in ==> pso_Trelea_vectorized at 298 bestpos = gbest; Error in ==> ...
AEC-Q100-007B:2007 Fault Simulation and Test Grading - 完整英文电子版(25页).zip
vhdl实现spi对M25P80flash进行操作。
Code for Test_Uart to transfer data from computer to board
Title: Test-Driven Development with Python, 2nd Edition ...Chapter 25. The Token Social Bit, the Page Pattern, and an Exercise for the Reader Chapter 26. Fast Tests, Slow Tests, and Hot Lava
资源分类:Python库 所属语言:Python 资源全名:large-image-source-test-1.9.1.dev25.tar.gz 资源来源:官方 安装方法:https://lanzao.blog.csdn.net/article/details/101784059
test_repos_25