![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ocp
文章平均质量分 80
回到未来望过去
oracle性能20年研究(saa批量自动优化分析,job、expdp的undo、temp内部运行机制等)
自行开发设计ssi平台(支持vpd)
自行开发设计pythonQT管理平台(系统监控、导出xls、常用字典、常用sql,日常运维sql(支持参数化))应用formysql,fororacle,fordm
python工具应用:工作量化监控mail日报,ogg监控日报(让领导发现问题),pyforweblogic监控自动重启
pyformysql数据外挂(降低mysql华为云性能峰值),py推荐算法落地社保
E-mail:li_tao@neusoft.com
展开
-
oracle索引的碎片化整理
Unformatted Blocks ..................... 7,400FS1 Blocks (0-25) ...................... 0FS2 Blocks (25-50) ..................... 577FS3 Blocks (50-75) ..................... 0FS4 Blocks (75-100)............原创 2021-08-31 15:43:09 · 221 阅读 · 0 评论 -
【OCP学习1z0-052记录13】【ORACLE 11G】 ADR之problems和incidents (问题和事件)
9: Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support? (Choose all that apply.)选项A.You can add SQL test cases to the incident package.B.Y...原创 2019-03-14 11:18:33 · 613 阅读 · 0 评论 -
【OCP学习1z0-052记录14】external table
22:Which two operations can be performed on an external table? (Choose two.)选项A.Create a view on the table.B.Create an index on the table.C.Create a synonym on the table.D.Add a virtual column to t...原创 2019-03-15 09:47:33 · 149 阅读 · 0 评论 -
【OCP学习1z0-052记录4】【oracle11G】 constraint to deferred
4: You have two tables with referential integrity enforced between them. You need to insert data tothe child table first because it is going to be a long transaction and data for the parent table wil...原创 2019-03-11 12:00:46 · 218 阅读 · 0 评论 -
【OCP学习1z0-052记录15】Shared SQLArea and Private SQLArea之OPEN_CURSORS隐含关系如何理解
27:Which two statements are true about Shared SQLArea and Private SQLArea? (Choose two.)选项A.Shared SQLArea will be allocated in the shared pool.B.Shared SQLArea will be allocated when a session star...原创 2019-03-15 17:02:28 · 230 阅读 · 0 评论 -
【OCP学习1z0-052记录19】Conventional Path Load与Direct Path Load
49: You are using flat files as the data source for one of your data warehousing applications. Tooptimize the application performance, you plan to move the data from the flat files to clusteredtable...转载 2019-03-20 10:07:00 · 501 阅读 · 0 评论 -
【OCP学习1z0-052记录20】B-tree index
51:Which two statements are true regarding B-tree index? (Choose two.)选项A.The leaf blocks in the index are doubly linked.B.The leaf node stores a bitmap for each key value.C.The rows with NULL val...转载 2019-03-20 15:01:21 · 108 阅读 · 0 评论 -
【OCP学习1z0-052记录5】MERGE
44: The TRANS_SUMMARY table contains product-wise transaction details that get updatedwith every transaction in the system. Each row has cumulative transaction details of a singleproduct and every p...原创 2019-03-12 08:52:13 · 137 阅读 · 0 评论 -
【OCP学习1z0-052记录一】【Oracle10g参考】 DBMS_SCHEDULER
【题目】23. While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?A. Oracle Scheduler would write detailed in...转载 2019-03-06 11:03:26 · 215 阅读 · 0 评论 -
【OCP学习1z0-052记录2】AUDIT_TRAIL
42: To make audit information more productive, the DBA executes the following command beforestarting an audit operation:SQL> ALTER SYSTEM SETAUDIT_TRAIL=DB,EXTENDEDSCOPE=SPFILE;Which statement...原创 2019-03-11 11:50:19 · 288 阅读 · 0 评论 -
【OCP学习1z0-052记录3】【oracle11G】Data Recovery Advisor
3: Identify two situations in which youcan useData Recovery Advisorfor recovery. (Choosetwo.)选项A.The database filesare corrupted when the database is open.B.The user has dropped an important t...原创 2019-03-11 11:58:09 · 146 阅读 · 0 评论 -
【OCP学习1z0-052记录6】STATISTICS_LEVEL
55: In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.What is the impact of this setting?A.Optimizer statistics are collected automatically.B.Only timed opera...原创 2019-03-12 09:53:37 · 211 阅读 · 0 评论 -
【OCP学习1z0-052记录7】(PMON, SMON,CKPT,DBWn,LGWR,ARCn)
57: Note the following functionalities of various background processes:1. Record the checkpoint information in data file headers.----ckpt2. Perform recovery at instance startup.-----smon3. Cleanup ...原创 2019-03-12 15:38:38 · 258 阅读 · 0 评论 -
【OCP学习1z0-052记录8】动态监听和静态监听
58: In which situation would you use static database registration for a listener?A.when multiple databases are to be registered with the listenerB.whenDBAs need to connect remotely to start up the d...原创 2019-03-12 15:49:24 · 158 阅读 · 0 评论 -
【OCP学习1z0-052记录9】Bfile和clob,nclob,blob
59: You want to access employee details contained in flat files as part of the EMPLOYEE table.You plan to add a new column to the EMPLOYEE table to achieve this. Which data type wouldyou use for the...原创 2019-03-12 15:54:26 · 196 阅读 · 0 评论 -
【OCP学习1z0-052记录10】【Oracle 10g】undo segment设置RETENTION GUARANTEE
60: View the Exhibit and examine the undo tablespace attributes.Your database instance is experiencing a large volume of transactions from non-DBA users in thelast one hour. The undo tablespace UNDO...原创 2019-03-13 09:38:54 · 566 阅读 · 0 评论 -
【OCP学习1z0-052记录16】【10g】MMON
35:Which statement is true about the ManageabilityMonitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B.It coordinates the rebalance activity for dis...原创 2019-03-18 09:40:58 · 193 阅读 · 0 评论 -
【OCP学习1Z0-053记录1】SQL plan baselines
1.Whiledeployinganewapplicationmodule,thesoftwarevendorshipstheapplicationsoftwarealongwithappropriateSQLplanbaselinesforthenewSQLsbeingintroduced.Whichtwostatementsdescrib...转载 2019-03-25 10:13:04 · 250 阅读 · 0 评论 -
【OCP学习1Z0-053记录2】moving window baseline
2.Youplantohavealargermovingwindowsizeforthedefaultsystem-definedmovingwindowbaselinebecauseyouwanttousetheadaptivethreshold.Whichstatementfactorsinthisconsiderationwhile...转载 2019-03-25 10:22:24 · 342 阅读 · 0 评论 -
【OCP学习1Z0-053记录3】DBMS_HM
5.ExaminethesectionoftheHealthCheckreportgivenbelow:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')RunName:HM_RUN_1061RunId:1061CheckName:DataBlockIntegrityCheckMode:REACTIVEStat...转载 2019-03-25 10:40:04 · 491 阅读 · 0 评论 -
【OCP学习1z0-052记录11】 SELECT_CATALOG_ROLE
68: View the Exhibit to observe the roles assigned to the SL_REP user.Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to theSL_REP user?A.The user must enable the role e...原创 2019-03-13 15:11:52 · 1113 阅读 · 0 评论 -
【OCP学习1z0-052记录12】LOG_CHECKPOINT_INTERVAL
69: Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications of these values in your database? (Choose ...原创 2019-03-13 16:08:12 · 664 阅读 · 0 评论 -
【OCP学习1z0-052记录21】invoker's right.
62: The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege onthe procedure to many database users:CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname...转载 2019-03-22 08:56:46 · 240 阅读 · 0 评论 -
【OCP学习1z0-052记录22】【10G】使用restore_table_stats还原统计信息
65: You have recently collected statistics on certain objects of a schema in your database. But youobserve suboptimal execution plans for the queries on these objects after two days of statisticscol...原创 2019-03-22 09:02:59 · 217 阅读 · 0 评论 -
【OCP学习1z0-052记录17】【Oracle 10g】Oracle Bigfile Tablespace(注意创建后不能增加datafile)
43: Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING3 EXTENTMANAGEMENT LOCAL SEGMENT SPACE MA...原创 2019-03-19 10:29:31 · 324 阅读 · 0 评论 -
【OCP学习1z0-052记录18】Oracle Secure Backup
44: Note the following points describing various utilities in Oracle Database 11g:1.It enables the transfer of data from one database to another.2. It provides a complete solution for the backup, r...原创 2019-03-19 10:53:09 · 651 阅读 · 0 评论 -
【OCP学习1Z0-053记录4】DBMS_NETWORK_ACL_ADMIN
7.You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which sta...转载 2019-03-26 10:11:22 · 150 阅读 · 0 评论 -
【OCP学习1z0-053记录23】恶意的客户机接收到坏包参数SEC_PROTOCOL_ERROR_FURTHER_ACTION
51.Tocontroltheexecutionofaserverprocesswhenitisreceivingbadpacketsfromapotentiallymaliciousclient,yousettheSEC_PROTOCOL_ERROR_FURTHER_ACTIONinitializationparameterasfollows:...转载 2019-04-04 10:15:39 · 428 阅读 · 0 评论 -
【OCP学习1z0-053记录24】DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, 和 DB_LOST_WRITE_PROTECT DB_ULTRA_SAFE
52.Youhavethefollowingrequirementsinrelationtothedetectionofblockcorruptionforyourdatabaseinstance:Checkforlogicalself-consistencyofdatablockswhenmodifiedinmemory.Checksum...转载 2019-04-04 10:47:58 · 278 阅读 · 0 评论 -
【OCP学习1Z0-053记录5】11g:DBMS_SPACE(又一个没见过的)
9.WhichstatementdescribestheinformationreturnedbytheDBMS_SPACE.SPACE_USAGEprocedureforLOBspaceusage?A.ItreturnsspaceusageofonlyBasicFileLOBchunks.B.Itreturnsspaceusageofo...转载 2019-03-26 17:32:10 · 340 阅读 · 0 评论 -
【OCP学习1z0-053记录25】RMAN 压缩cpu消耗 BZIP2》GZIP 》ZLIB》LZO
53.YouwanttouseRMANtocreatecompressedbackups.WhichstatementistrueaboutthecompressionalgorithmsthatRMANcanuse?A.TheBZIP2compressionalgorithmconsumesmoreCPUresourcesthanth...转载 2019-04-04 14:44:34 · 300 阅读 · 0 评论 -
【OCP学习1Z0-053记录6】11g:VPC (又一个没见过的)
15.YouareintheprocessofcreatingavirtualprivatecataloginyourOracleDatabase11gdatabase.ThePROD1,PROD2,andPROD3OracleDatabase10gdatabasesareregisteredinthebaserecoverycata...转载 2019-03-28 09:40:18 · 218 阅读 · 0 评论 -
【OCP学习1z0-053记录30】RMAN 恢复映像副本RECOVER COPY OF DATAFILE的
79.Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE'/u01/app/oracle/oradata/orcl/users01.dbf';Whichstatementregardingtheabovecommandiscorrect?A.The'/u01/app/oracle/ora...转载 2019-04-11 08:43:23 · 332 阅读 · 0 评论 -
【OCP学习1z0-053记录31】 有关SQL profile 的一道描述(细节)
80.WhichtwostatementsregardingaSQLprofilearetrue?(Choosetwo.)A.ItisbuiltbyAutomaticTuningOptimizer.B.Itcannotbestoredpersistentlyinthedatadictionary.C.Itcanbeusedbyt...转载 2019-04-11 08:45:50 · 172 阅读 · 0 评论 -
【OCP学习1z0-053记录32】ALLOCATED_SPACE与FREE_SPACE居然有交集空间(红色标注部分)(细节)
81.Evaluatethefollowingcommandanditsoutput:SQL>SELECT*FROMdba_temp_free_space;TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwost...转载 2019-04-11 09:04:48 · 345 阅读 · 0 评论 -
【OCP学习1Z0-053记录7】11g:TSPITR (又一个没见过的)
16.Becauseofalogicalcorruptioninyourproductiondatabase,youwantedtoperformTablespacePointinTimeRecovery(TSPITR).Butbeforeyoustarttherecovery,youqueriedtheTS_PITR_OBJECTS_TO_...转载 2019-03-28 15:49:28 · 226 阅读 · 0 评论 -
【OCP学习1Z0-053记录16】【11g新功能】ALTER DISKGROUP data CHECK
33.YouwanttoperformthefollowingoperationsfortheDATAASMdiskgroup:-Verifytheconsistencyofthedisk.-Cross-checkallthefileextentmapsandallocationtablesforconsistency.heckwhet...转载 2019-04-02 08:08:48 · 472 阅读 · 0 评论 -
【OCP学习1Z0-053记录17】【11g新知识】BACKUP DATABASE 。。。KEEP
34.ExaminethefollowingRMANcommand:BACKUPDATABASETAGTESTDBKEEPUNTIL'SYSDATE+1'RESTOREPOINTTESTDB06;WhichtwostatementsaretrueregardingthebackuptakenbyusingtheaboveRMANcomman...转载 2019-04-02 08:15:20 · 481 阅读 · 0 评论 -
【OCP学习1Z0-053记录18】【11g数据块remap】ASMCMD指令 remap(直接不知所云,如果没有实践经验的话)
36.WhichtwostatementsaretrueregardingthefunctionalityoftheremapcommandinASMCMD?(Choosetwo.)A.ItrepairsblocksthathavereaddiskI/Oerrors.B.Itcheckswhetherthealiasmetadatad...转载 2019-04-02 08:28:24 · 260 阅读 · 0 评论 -
【OCP学习1Z0-053记录8】MERGE PARTITIONS
17.TheINV_HISTORYtableiscreatedusingthecommand:SQL>CREATETABLEINV_HISTORY(inv_noNUMBER(3),inv_dateDATE,inv_amtNUMBER(10,2))partitionbyrange(inv_date)interval(numtoyminterval(...转载 2019-03-28 16:58:44 · 259 阅读 · 0 评论