- 博客(62)
- 资源 (81)
- 问答 (1)
- 收藏
- 关注
转载 oracle transport tablespace
oracle transport tablespace源win_x64 oracle10.2.0.4平台,目标端linux_X64 11.2.0.4平台需要注意的理,两端的字符集务必一致检查方法:select * from nls_database_parameters;否则会报:IMP-00017: following statement failed with ORAC...
2019-03-29 17:05:44 170
原创 怎么知道有dblink连接到当前数据库
select * from v$session where program like 'ORACLE%' and v$session.SQL_ADDRESS='00'机器名肯定是oracle服务器的名字
2019-03-29 15:19:12 2224
原创 oracle default的约束条件查询sql
select * from USER_TAB_COLUMNS where USER_TAB_COLUMNS.DEFAULT_LENGTH>0
2019-03-29 15:16:37 639
原创 【11g】Managing Automated Database Maintenance Tasks
Managing Automated Database Maintenance TasksOracle数据库自动化了几个常见的维护任务,这些任务通常由数据库管理员执行。这些自动维护任务是在预期系统负载较轻时执行的。您可以启用和禁用各个维护任务,并可以配置这些任务何时运行以及分配了哪些资源分配In this chapter: About Automated Maintenance Ta...
2019-03-29 10:37:37 927
转载 【OCP学习1Z0-053记录15】DBMS_STATS缺省参数
28.Youhavearange-partitionedtableinyourdatabase.Eachpartitioninthetablecontainsthesalesdataforaquarter.Thepartitionrelatedtothecurrentquarterismodifiedfrequentlyandother...
2019-03-29 10:01:23 441
转载 【OCP学习1Z0-053记录14】IMPORT CATALOG
26.YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschema...
2019-03-29 09:30:40 451
转载 【OCP学习1Z0-053记录13】Flashback Data Archive (这个好东西,开发人员实施人员的后悔药,大家用起来)
25.YouenabledFlashbackDataArchiveontheINVENTORYtable.WhichDDLoperationissupportedonthetableafterenablingFlashbackDataArchive?A.Dropthetable.B.PartitionthetableC.Truncate...
2019-03-29 09:00:35 263
转载 【OCP学习1Z0-053记录12】SQL Test Case Builder
24.WhichofthefollowinginformationwillbegatheredbytheSQLTestCaseBuilderfortheproblemspertainingtoSQL-relatedproblems?(Chooseallthatapply.)A.ADRdiagnosticfilesB.alltheopt...
2019-03-29 08:52:41 286
转载 【OCP学习1Z0-053记录11】DBMS_LOB
23.WhichtaskscanbeaccomplishedusingtheDBMS_LOB.SETOPTIONSprocedure?A.onlyencryptionandcompressionsettingsforallSecureFileLOBsB.onlyencryptionanddeduplicationsettingsforonly...
2019-03-29 08:46:01 807
转载 【OCP学习1Z0-053记录10】 INVISIBLE INDEXES
22.AnindexcalledORD_CUSTNAME_IXhasbeencreatedontheCUSTNAMEcolumnintheORDERStableusingthefollowingcommand:SQL>CREATEINDEXord_custname_ixONorders(custname);TheORDERStableis...
2019-03-29 08:37:08 188
转载 【HomeDatabaseOracleOracle DatabaseRelease 12.2】DBMS_ADDM
DBMS_ADDMTheDBMS_ADDMpackage facilitates the use of Advisor functionality regarding the Automatic Database Diagnostic Monitor.This chapter contains the following topics: Security Model S...
2019-03-28 17:11:05 273
转载 【OCP学习1Z0-053记录9】dbms_addm(天啊,怎么这么多的不知道,oracle这是整啥啊)
18.YoucreateanewAutomaticDatabaseDiagnosticMonitor(ADDM)task:instance_analysis_mode_task.ToviewtheADDMreport,youusethefollowingcommand:SQL>SELECTdbms_addm.get_report('my_ins...
2019-03-28 17:10:04 319
转载 【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 269
转载 【OCP学习1Z0-053记录7】11g:TSPITR (又一个没见过的)
16.Becauseofalogicalcorruptioninyourproductiondatabase,youwantedtoperformTablespacePointinTimeRecovery(TSPITR).Butbeforeyoustarttherecovery,youqueriedtheTS_PITR_OBJECTS_TO_...
2019-03-28 15:49:28 235
转载 【OCP学习1Z0-053记录6】11g:VPC (又一个没见过的)
15.YouareintheprocessofcreatingavirtualprivatecataloginyourOracleDatabase11gdatabase.ThePROD1,PROD2,andPROD3OracleDatabase10gdatabasesareregisteredinthebaserecoverycata...
2019-03-28 09:40:18 223
转载 【OCP学习1Z0-053记录5】11g:DBMS_SPACE(又一个没见过的)
9.WhichstatementdescribestheinformationreturnedbytheDBMS_SPACE.SPACE_USAGEprocedureforLOBspaceusage?A.ItreturnsspaceusageofonlyBasicFileLOBchunks.B.Itreturnsspaceusageofo...
2019-03-26 17:32:10 354
转载 【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 157
原创 oracle data_default 存在哪里
ALL_TAB_COLUMNSALL_TAB_COLUMNSdescribes the columns of the tables, views, and clusters accessible to the current user. To gather statistics for this view, use theANALYZESQL statement or theDBMS_...
2019-03-25 17:28:27 855
转载 【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 505
转载 【OCP学习1Z0-053记录2】moving window baseline
2.Youplantohavealargermovingwindowsizeforthedefaultsystem-definedmovingwindowbaselinebecauseyouwanttousetheadaptivethreshold.Whichstatementfactorsinthisconsiderationwhile...
2019-03-25 10:22:24 353
转载 【OCP学习1Z0-053记录1】SQL plan baselines
1.Whiledeployinganewapplicationmodule,thesoftwarevendorshipstheapplicationsoftwarealongwithappropriateSQLplanbaselinesforthenewSQLsbeingintroduced.Whichtwostatementsdescrib...
2019-03-25 10:13:04 263
原创 【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 229
转载 【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 244
原创 【拾漏补遗】【12c Release 1 (12.1.0.2)】Managing Security for Definer's Rights and Invoker's Rights
5Managing Security for Definer's Rights andInvoker's RightsInvoker’s rights and definer’s rights用于控制对特权的访问以运行用户创建的过程时具有几个安全优势Topics: About Definer's Rights and Invoker's Rights How Proce...
2019-03-21 10:09:13 619
转载 【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 112
转载 【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 510
原创 【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 655
原创 【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 332
原创 【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 242
原创 【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 242
原创 【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 153
转载 oracle11g:自动SQL优化
Oracle11g引入了自动SQL优化。这本书的许多章节都详细涵盖了这个主题,因此本节只作概述。Oracle11g根据AWR(Automatic Workload Repository,自动负载信息库)的统计信息针对产生较大性能影响的SQL语句运行SQL 优化顾问(SQL Tuning Advisor)。AWR的统计信息用来生成一个SQL语句列表并根据它们过去一周对系统性能的影响进行排序,这个...
2019-03-15 09:38:17 1567
转载 oracle11g:FBDA闪回数据归档
闪回数据归档是OracleDatabase 11g强大的新特性之一。它可以用安全有效的方式透明地跟踪在数据库中存储的所有数据,并且没有保留期限的限制。这个特性很容易配置,而且拥有高效的存储以及性能。闪回数据归档不依赖于UNDO,通过“AS OF”闪回SQL语句来查看之前在某个时间点的数据,防止意外的数据更新和删除(例如用户的错误操作)或恶意的数据破坏(例如黑客入侵)。闪回数据归档需要闪回数据...
2019-03-15 09:38:08 483
转载 oracle11g:/*+ result_cache */
OracleDatabase 11g提供了一个新的、单独的共享内存池来存储查询结果,这个结果集缓存直接从共享池分配并且单独维护。这是一个重要的改进性能和优化系统的新特性。结果集缓存可以将查询的结果(例如,工资计算后的总和)缓存在内存中,显著改进将来需要多次执行和查询相同结果的查询的性能。结果集缓存最适合的是静态数据表(如果数据发生变化,就必须重新计算一次),即结果集缓存最适合不停返回同样结果的查...
2019-03-15 09:37:56 813
转载 oracle11g:rman:section size
在Oracle Database 11g之前,RMAN通过并行分配多个通道进行并行备份,每个通道成为一个RMAN会话,但是每个通道一次最多只能备份一个数据文件,这意味着即使有多个通道,每个数据文件也只能通过一个通道进行备份。在Oracle Database 11g的RMAN中,分配的通道可以把一个数据文件分成块,也叫做片段(Section)。您可以指定每个段的大小:RMAN> run ...
2019-03-15 09:37:46 1374
转载 oracle11g:add:活动数据库复制(Active Database Duplication)
Oracle Database 11g中增加了一个重要的功能,可以在不使用现有的RMAN备份或手动拷贝文件的情况下复制数据库。如果您之前不使用RMAN备份,那么现在可以利用RMAN复制功能创建备用数据库、测试环境或开发环境,而不必事先创建RMAN备份。此功能利用网络,所以也被称为网络使能的数据库复制(Network-enabled Database Duplication)或活动数据库复制。RM...
2019-03-14 11:38:12 284
转载 oracle11g:rman:CATALOG转移
在OracleDatabase 11g中,RMAN可以更好地管理目录,可以把目录移动到另一个数据库或通过导入目录的功能合并目录。把一个目录移动到另一个目录/数据库:$ sqlplus / as sysdbaSQL> CREATE USER rman2 IDENTIFIED BY rman2 QUOTA UNLIMITED ON rman_ts;SQL> GRANT R...
2019-03-14 11:36:35 440
转载 oracle11g:rman:主动的健康检查
OracleDatabase 11g增强了RMAN并提供主动检查数据库坏块的能力。这个检查可以针对整个数据库、表空间、指定的数据文件或数据文件的指定块。DBA因此有能力通过预定的流程定期检查数据库是否损坏,或者当他/她怀疑可能存在损坏的时候检查数据库中的一部分。健康检查报告检查的每个数据库上块的数量、空块的数量和坏块的数量。RMAN> validate database ;RMAN...
2019-03-14 11:33:38 256
转载 oracle11g:COMPRESS:高级压缩
Oracle 11g中引入了名为“高级压缩”的新特性,向不同的组织机构承诺数据库表将占用更少的空间,相当于数据库变小了。较小的数据库占用较少的磁盘空间,也相当于较低的数据库磁盘存储的成本。随着数据库的规模以惊人的速度持续增长,能增加单位GB的存储容量确实非常令人振奋。除此之外,也有潜在的性能优势来自于大量的读操作,比如全表扫描。Oracle只需要更少的物理块读操作就可以完成全表扫描;利用压缩的数据...
2019-03-14 11:32:12 1584
转载 oracle11g:hm:健康监控器(Health Monitor)
Oracle11g中引入了免费的数据库健康监控器,通过dbms_hm程序包来完成。健康监控器可以手动运行并检查下列项目:DB结构完整性检查数据块完整性检查重做日志完整性检查UNDO段完整性检查事务完整性检查数据字典完整性检查使用dbms_hm程序包执行健康检查:SQL> exec dbms_hm.run_check ('Dictionary Integrity Check'...
2019-03-14 11:31:06 459
win10内置flash修复文件system32下的
2020-09-18
django.rar
2020-09-01
coe_xfr_sql_profile.sql.zip
2020-09-01
Python_game-master.zip
2020-03-15
telnet.rar
2020-02-27
微信历史对话一个个删除.exe
2020-01-13
tuxedo81_win(1).exe
2019-11-28
pip-19.3.1.rar
2019-11-22
HTMLTestRunner.py
2019-11-19
windows下的dd
2019-10-14
diablo2oo2's Universal Patcher(DUP) v2.26.1 汉化版.rar
2019-07-31
py3.7.4通过jaydebeapi访问jdbc链接oceanbase的oracle模式
2024-09-13
Microsoft Visual C++ 14.0 or greater is required
2024-09-13
监控oceanbase的python小工具dooba
2024-04-02
mmap2mm mmap2mm mmap2mm
2023-01-05
echarts.zip修改增加ylabel的rotate属性
2021-12-21
ssq20210618.rar
2021-06-18
oecd_bli_2015 gdp_per_capita
2020-12-09
win10内置flash修复文件SysWOW64下的
2020-09-18
TA创建的收藏夹 TA关注的收藏夹
TA关注的人