ITPub博客

我认为我替大家弄ocp证书的优势在于我很专业，价格也比较低，而且你们也比较省心，同时考试也比较灵活吧。不像其他一些机构忽悠的成份大一些，毕竟我自己也做技术、也是dba。从我这儿报名考ocp、ocm的免费永久享受我给企业做培训时录制的所有视频。[@more@]1、我是搞oracle的、是做技术的，我对oracle不论是技术上还是商务上都非常了解。我的blog：http://warehouse.itpub.net2、我公司拿过wdp授权业务，我对通过wdp途径考证流程非常清楚；3、我对通过原厂培训之后获得ocp证书的流程非常清楚；4、vue注册的流程我很清楚；5、vue预约的流程

To grant a system privilege, you must either have been granted the system privilege with the ADMIN OPTION or have been granted the GRANT ANY PRIVILEGE system privilege.To grant a role, you must either have been granted the role with the ADMIN OPTION or have been granted the GRANT ANY ROLE system privilege, or you must have created the role.To grant an object privilege, you must own the object, or the owner of the object must have granted you the object privileges with the GRANT OPTION, or you mu

好多人说韩系和日系车如何如何，我觉得没开过的话就不要说三道四；喜欢这款车好久了，大约从它出来就喜欢上了，喜欢它的外形，大气，厚实；花轿车的价格买了SUV我觉得性价比不错，在不降价之前我觉得不太划算，现在还好，尽管出差依然不少，但是不出差的时候也经常跑客户那儿，公司的一些杂七杂八的事情也需要处理，总之没有个代步的工具总觉得不是很方便，尽管停车比较困难...留个纪念，2011年5月28日（星期六）...新起点、新征程！[@more@]接下来的工作就是练了...

原文连接：http://www.oracledba.org/11g/rac/11g_RAC_Admin_Utilities.html#Various_Timeout_Settings_in_Cluster:[@more@]11g RAC Administration and Maintenance Tasks and Utilities:Task List:Checking CRS StatusViewing Name Of the ClusterViewing Nodes ConfigurationChecking Votedisk InformationChecking OCR Disk informationTimeout Settings in ClusterADD/Remove OCR filesADD/Remove VotediskBacking Up OCRBacking Up VotediskRestoring OCR DevicesRestoring Voting Disk DevicesChanging Public IPs as well as Virt

网上看的一篇不错的文章，记录一下[@more@]The voting disk is a shared raw disk partition or file on a clustered file system that is accessible to all nodes in the cluster. Its primary purpose is to help in situations where the private network communication fails. When that happens, the cluster is unable to have all nodes remain available because they are no longer able to synchronize I/O to the shared disks. Therefore, some of the nodes must go offline. The voting disk is then used to communicate

锁的一点分析、总结和理解。[@more@]session 1:SQL> select * from tt; ID NAME AGE---------- ---------- ---------- 1 c 30 2 bSQL> select distinct sid from v$mystat; SID---------- 159SQL> update tt set name='a' where id=1;已更新 1 行。SQL>--============================session 2:SQL> select distinct sid from v$mystat; SID---------- 142SQL> update tt set age=30 where id=1;等待--===============================

随手记录。。。[@more@]21:29:17 SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。21:29:47 SQL> startup mountORACLE 例程已经启动。Total System Global Area 314572800 bytesFixed Size 1248768 bytesVariable Size 109052416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7139328 bytes数据库装载完毕。21:29:53 SQL> alter database noarchivelog ;alter database noarchivelog*第 1 行出现错误:ORA-38774: 无法禁用介质恢复

segment size<=1m extent 按照64k分配；segment size<=64m extent 按照1m分配；segment size<=1g extent 按照8m分配；segment size>1g extent 按照64m分配；以前看doc这么介绍的，今天正好创建一了一个14g的大表，顺道观查了一下，做个记录[@more@]16:54:38 SQL> select bytes/1024/1024/1024 from dba_segments where segment_name='T' and owner='SYS';BYTES/1024/1024/1024-------------------- 14.25已用时间: 00: 00: 00.1816:54:48 SQL> select distinct bytes/1024/1024 extent_size from dba_

版本11gR1,在客户的db alert日志中看到了这一现象，记录一下。[@more@]Expanded controlfile section 19 from 818 to 8180 recordsRequested to grow by 7362 records; added 10 blocks of recordsTue Apr 19 14:48:49 2011

以前是发mail，从2011年5月23日开始mail将被废弃，下面是oracle说mail废弃的说明--===============================Note: The ocp-fulfillment_ww@oracle.com mail box will be decommissioned on 23-May-2011, you will not receive any reply from this mail box. For all your Certification questions or issues, please submit a Service Request - http://education.oracle.com/pls/eval-eddap-dcd/OU_SUPPORT_OCP.home?p_source=OCP and an OCP customer service representative will contact you.--=============================

原文连接：http://blog.csdn.net/tianlesoftware/archive/2009/10/16/4674224.aspx[@more@]防止网页失效，拷贝过来保留一份：一. 官网说明1. Oracle 10g文档如下：http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#i1010293 Data Pump ComponentsOracle Data Pump is made up of three distinct parts:（1）The command-line clients, expdp and impdp（2）The DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API)（3）The DBMS_METADATA PL/SQL package (also known as the Metadata API)

以前对临时段的认识到底是出现了错误还是oracle 10g有变化，发现临时段在sort之后查询结束释放了。[@more@]下面这些doc都是来着oracle官方文档，都是介绍临时段的，可以参考。Introduction to Temporary SegmentsWhen processing queries, Oracle often requires temporary workspace for intermediate stages of SQL statement parsing and execution. Oracle automatically allocates this disk space called a temporary segment. Typically, Oracle requires a temporary segment as a database area for sorting. Oracle does not cr

不论是sga自动管理还是手动管理，共享池都是由2部分内存组成的，一部分是供我们用户使用，这部分就是我们熟悉的library cache和dictionary cache，另一部分就是oracle内部使用的，比如参数process的大小直接决定了使用这部分内部使用的内存大小。[@more@]Specifying the Shared Pool SizeThe SHARED_POOL_SIZE initialization parameter is a dynamic parameter that lets you specify or adjust the size of the shared pool component of the SGA. Oracle Database selects an appropriate default value.In releases before Oracle Dat

更详细的内容可以参考doc：http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1.htm#sthref247本文只针对RETENTION POLICY和BACKUP OPTIMIZATION以及结合043中的一道题做一个简单的说明，这道题在群内问起的人很多，确实不是很好理解。[@more@]先看一下doc吧：If backup optimization is enabled, and if a recovery window retention policy is ineffect, then when performing SBT backups RMAN always backs up datafiles whosemost recent backup is older than the recovery window. For example, assume that

实例恢复的过程中事务恢复（也就是rollback掉那些没有提交的事务）到底是在open之前还是open之后做呢貌似oracle没有给出一个明确的说法，我以前一直认为是首先前滚然后open db之后再做rollback（事务恢复），但是通过alert里面实例恢复的过程来观查发现应该是在open之前就做了rollback（SMON: enabling tx recovery）。 从alert中记录的日志来看open的过程中先后做了前滚和回滚之后才能open db。[@more@]Shutting down instance (abort)License high water mark = 12Instance terminated by USER, pid = 5688Sun Mar 27 11:24:26 2011Adju

doc的原话，记录一下[@more@]Overview of Instance and Crash RecoveryCrash recovery is used to recover from a failure either when a single-instance database fails or all instances of an Oracle Real Application Clusters database fail. Instance recovery refers to the case where a surviving instance recovers a failed instance in an Oracle Real Application Clusters database.The goal of crash and instance recovery is to restore the data block changes located in the cache of the terminated instance and t

实例恢复是否需要经过buffer cache一直是我心中的疑问，oracle doc上提到了cache recovery，我一直认为应该是经过cache的，但是不好验证，今天无意中发现alert记录了这一信息：Buffer cache too small: 126 buffers remain in apply pass 2[@more@]ALTER DATABASE MOUNTSun Mar 27 11:24:31 2011Setting recovery target incarnation to 1Sun Mar 27 11:24:31 2011Successful mount of redo thread 1, with mount id 2045045995Sun Mar 27 11:24:31 2011Database mounted in Exclusive ModeCompleted: ALTER DATABASE MOUNTSun Mar 27 11:

可以通过2个视图来监控flash_recovery_area空间的使用[@more@]SQL> show parameter db_recoveryNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string g:oracleproduct10.2.0flash _recovery_areadb_recovery_file_dest_size big integer 2GSQL>--=================================SQL> select * from v$flash_recovery_area_

和statspack相比awr收集快照的级别只有2种[@more@]SQL> select distinct snap_level from dba_hist_snapshot;SNAP_LEVEL---------- 1 22 rows selected.SQL> show parameter statistics_levelNAME TYPE VALUE------------------------------------ ----------- ------------------------------statistics_level string ALLSQL>其中dba_hist_snapshot中字段snap_level=1表示该快照要么是在参数statistics_level=typical自动生成的，要么是用下面

select sga_size,100*(1-estd_db_time_factor) from v$sga_target_adviceorder by sga_sizesga_target advisor通过excel画图处理之后由于纵坐标存在负值，而横坐标又是从纵坐标的0值开始的，这样看起来不是很舒服，如何调整呢。在纵坐标上点击右键选折“坐标轴格式”，然后选折“刻度”tab页，之后在“交叉于”标签处输入想要的值就可以了。[@more@]调整前和调整后的效果对比：http://www.itpub.net/viewthread.php?tid=1411679&extra=page%3D1&frombbs=1