oracle dba certification path

each group cannot be deleted */alter Databse drop logfile member '$ ORACLE_HOME/Oracle/ora_log_file6.rdo '; /* clear online logs */alter database clear logfile '$ ORACLE_HOME/Oracle/ora_log_file6.rdo'; Alter database clear logfile group 3; /* clear non-archive logs */alter database clear Unarchived logfile group 3; /* rename the log file */alter database rename File '$ ORACLE_HOME/

Oracle DBA Database Senior Engineer Training Upper (project implementation + Backup Recovery + foundation depth)Purchase Address:Http://edu.51cto.com/pack/view/id-739.html DescribeOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employ

Tags: Oracle DBA stress testThis article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/42376661Before a business system stress test, an Oracle DBA is required to do the work ahead of time:1. If the Oracle database softwar

This is a sophomore writing in the QQ space in an article, I remember that the problem took me the whole day to fix it, so experienced quite deep, so at that time deliberately recorded the process of the settlement, and today suddenly have the interest to find out a few college writing in the spaces in the article and share with you, In case something like that happened to me, it would take a lot of time, and the following is the full contents of the record:Today login with the user Scott landed

of Oracle ASM host mirror.For the comparison of these two scenarios:VPLEXAsmThe two program authors participate in the most EMC scenarios, typically from program audits, installation,testing,go-live support, operations, optimization, and participation, while the ASM program is more involved in the overall crosscheck,trouble Shooting, optimize the adjustment and so on. In the following, we discuss the individual sentiment of these two kinds of program

, tables with size> 10% of cache size, were being treated as 'largetables 'for their reads and this resulted in execution of a newserial_direct_read path in 11g. 4.3 Solution Download and apply patch 8897574 for 11.1.0.7 or 11.2.0.1 for your actualpsu level. Or Upgrade to 11.2.0.2 or higher With the bug fix applied, any object in thekeep buffer pool, whose size is less than db_keep_cache_size, is considered ASA small or medium sized object. this will

Label:Performance tuning is a task that every DBA can encounter in his careerBig to the World 500 strong core system, small to the township enterprises of the invoicing, almost will have to tune the timeFaced with a variety of systems, a wide range of needs, the means of tuning is also colorfulLocating the problem, analyzing the problem, solving the problem, is indispensable, and the method is diverse, and the effect is different.determining baselines