warehouse客栈

ITPUB认证区版主

  • 博客访问: 4682549
  • 博文数量: 851
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-07 15:08
  • 认证徽章:
个人简介

了解并联系warehouse: http://blog.itpub.net/19602/viewspace-1059211/

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(851)

文章存档

2017年(7)

2016年(20)

2015年(19)

2014年(42)

2013年(65)

2012年(66)

2011年(87)

2010年(68)

2009年(103)

2008年(140)

2007年(142)

2006年(38)

2005年(53)

2004年(1)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

发布时间:2010-08-23 15:18:28

看到一位puber提出来的疑问,简单的测试了一下,发现确实存在这个问题,原帖:http://www.itpub.net/viewthread.php?tid=1340189&pid=16296004&page=1&extra=page%3D2[@more@]--nocatalog的情况RMAN> backup as compressed backupset full database ;启动 backup 于 23-8月 -10使用通道 ORA_DISK_1通道 ORA_DISK_1: 启动压缩的全部数据文件备份集通道 ORA_DISK_1: 正在指定备份集中的数据文件输入数据文件 fno=00001 name=E:ORACLETESTSYSTEM01.DBF输入数据文件 fno=00002 name=E:ORACLETESTUNDOTBS01.DBF输入数据文件 fno=......【阅读全文】

阅读(3560) | 评论(0) | 转发(0)

发布时间:2010-08-22 18:01:33

原文连接:http://www.remote-dba.net/oracle_10g_tuning/t_oracle_cpu_costing.htmhttp://itspace.javaeye.com/blog/644780http://www.eggheadcafe.com/software/aspnet/35989389/what-does-the-costcpu-in-explain-plan-mean.aspxhttp://jonathanlewis.wordpress.com/2006/12/11/cost-is-time/[@more@]Oracle CPU CostingOracle Tips by Burleson ConsultingTurning on CPU CostingThe default setting for the optimizer cost model is CHOOSE, meaning that the presence of CBO statistics will influence whether or not CPU costs ......【阅读全文】

阅读(3638) | 评论(0) | 转发(0)

发布时间:2010-08-18 15:56:10

因为有图,所以没发把内容直接贴过来,直接看连接吧[@more@]http://www.itpub.net/thread-1338428-1-1.html......【阅读全文】

阅读(2456) | 评论(0) | 转发(0)

发布时间:2010-08-15 17:18:00

非常荣幸的受到作者谭怀远(网名:alantany)先生的邀请为他的著作写一个书评,我的书评与其他几位重量级人物的书评相比显的有些片面和单薄,我为该书的书评如下:据我所知作者是中国独立撰写Oracle性能优化书籍的第一人,该书几乎涵概了Oracle性能优化的所有主题,在国内数据库性能优化领域的书籍中实属罕见。 ——谢永生(warehouse) 资深Oracle培训讲师 我对该书的评价其实不够准确,该书还没有完全涵盖oracle性能优化所涉及的所有主题,作者主要介绍的其实是sql优化的主题较多,实例和系统一级的优化似乎提及的不多,不管咋说,这确实是......【阅读全文】

阅读(2925) | 评论(0) | 转发(0)

发布时间:2010-08-10 13:18:13

Like indexes, IOTs are subject to inserts, deletes, block splits and coalsces, all of which affect the rowid. This means a standard rowid cannot always be used to retrieve an IOT record from a secondary index. For this reason secondary indexes on IOTs use a logical rowid which is made up of the original rowid and the primary key of the row. When a secondary index is referenced the rowid is used to find the block. If the block is not present at that disk address the primary key is used to find th......【阅读全文】

阅读(2543) | 评论(0) | 转发(0)

发布时间:2010-08-09 13:01:07

测试的缘由是基于下面一个问题:http://www.itpub.net/thread-1333706-1-1.html[@more@]RMAN> configure exclude for tablespace users;今后的全部数据库备份将排除表空间 USERS已成功存储新的 RMAN 配置参数RMAN> show all;RMAN 配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaul......【阅读全文】

阅读(3979) | 评论(0) | 转发(0)

发布时间:2010-08-07 15:19:11

Type of block corruption in the datafile: ALL ZERO - Block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block.FRACTURED - Block header looks reasonable, but the front and back of the block are different versions.CHECKSUM - optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it ......【阅读全文】

阅读(2553) | 评论(0) | 转发(0)

发布时间:2010-08-07 11:52:37

按照oracle的说法是before images of data blocks[@more@]Flashback Database is implemented using a type of log file called Flashback Database logs. TheOracle database periodically logs before images of data blocks in the Flashback Database logs.Block images can be reused to quickly back out the data file changes to any time at whichflashback logs were captured just before the desired target time. Then, changes from the redo logfiles are applied to fill in the gap. The Flashback Database logs are au......【阅读全文】

阅读(2559) | 评论(0) | 转发(0)

发布时间:2010-08-07 11:17:34

讲课时随手的一些总结[@more@]SQL> col member format a40SQL> select group#,member from v$logfile; GROUP# MEMBER---------- ---------------------------------------- 2 D:ORADATATESTREDO02.LOG 3 D:ORADATATESTREDO03.LOG 1 D:ORADATATESTREDO01.LOGSQL> select group#,members,status from v$log; GROUP# MEMBERS STATUS---------- ---------- ---------------- 1 1 CURRENT 2 1 INACTIVE 3 1 INACTIVESQL> alter database add......【阅读全文】

阅读(2555) | 评论(0) | 转发(0)

发布时间:2010-08-07 10:49:54

讲课时随手的一些总结[@more@]要想启动flashback database的功能需要满足3个条件:1.要求db在archivelog2.startup mount3.使用flash recovery area,因为flashback log必须要求放在flash recovery area里--======================SQL> select flashback_on from v$database;FLASHBACK_ON------------------NOSQL> archive log list;数据库日志模式 存档模式自动存档 启用存档终点 USE_DB_RECOVERY_FILE_DEST最早的联机日志序列 4下一个存档日志序列 7当前日志序列 7SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACL......【阅读全文】

阅读(2946) | 评论(0) | 转发(0)

发布时间:2010-08-01 11:04:26

The large pool must be explicitly configured. The memory of the large pool does not come out ofthe shared pool, but directly out of the SGA, thus adding to the amount of shared memory theOracle server needs for an instance at startup[@more@]--===========================SQL> show parameter largeNAME TYPE VALUE------------------------------------ ----------- ------------------------------large_pool_size big integer 0SQL> show parameter sgaNAME TYPE VALUE------------------------------------ -......【阅读全文】

阅读(3890) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册