ITPub博客

先创建一个物化视图使用最简单的语法来创建create materialized view sales_customers_products asSELECT p.prod_category, c.country_id,sum(s.quantity_sold) AS quantity_sold,sum(s.amount_sold) AS amount_...

SQL> explain plan for  2  2  SELECT *  3  FROM scott.emp  4  WHERE NOT EXISTS (SELECT 0  5  FROM scott.dept  6  WHERE dept.dname = 'SALES' AND de...

dbms_xplan包dbms_xplan包可以用来显示存储在三个不同地方的执行计划:plan_table表,库缓存和awr.下面将会介绍dbms_xplan包中可用的函数.输出这里主要解释通过dbms_xplan包中函数返回的信息.下面是dbms_xplan.dis...

下面来模拟误删除users表空中的数据文件users01.dbf[root@jingyong jingyong]# lscontrol01.ctl example01_bak.dbf jy01.dbf redo02.log sysaux01.dbf system01.dbf undotbs01.dbf users01.dbf.bakcontrol02.ctl exa...

optimizer_index_cost_adj这个初始化参数optimizer_index_cost_adj用于改变通过索引扫描来访问表数据的成本.参数的有效值从1到10000.缺省值是100.如果这个参数的值大于100那么使用索引扫描的成本更昂贵...

数据库服务器让系统管理员修改IP后启动监听报TNS-01189故障[root@171db ~]# su - oracle[oracle@171db ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 31-MAY-2013 10:49:58Copyright (c...

在redhat6.3上安装10g时当安装到83%报如下错 - Linking liborasdk/oracle/u01/oracle/product/10.2.0/db_1/bin/genorasdksh$Id: genorasdksh.sh 02-mar-2005.16:22:46 mchengjr Exp $Generating FULL ORASDK li...

将cursor_sharing从EXACT修改为similar为了降低硬解析但是执行下面的语句时报ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], []select t.*, level as org_level from (select a.aab03...

将cursor_sharing从EXACT修改为similar为了降低硬解析但是执行下面的语句时报ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], []select t.*, level as org_level from (select a.aab034 as center_id, a.aab034 as org_code, b.aaa013 as org_name, to_number(a.aaz198) as org_id, :"SYS_B_0" as org_up_id, :"SYS_B_1" as org_type from af01 a, aa13 b where a.aab034 = b.aaa027 un

由于突然断电,在恢复供电后启动数据库报以下错误信息:ALTER DATABASE OPENFri May 17 14:22:14 CST 2013Beginning crash recovery of 1 threads parallel recovery started with 7 processesFri May 17 14:22:14 CST 2013Started redo scanFri May 17 14:22:14 CST 2013Completed redo scan 57 redo blocks read, 4 data blocks need recoveryFri May 17 14:22:15 CST 2013Errors in file /orac/admin/test/bdump/test_p003_14475.trc:ORA-27090: Unable to reserve kernel resources for asynchronous disk I/OAdditional information: 3

由于突然断电,在恢复供电后启动数据库报以下错误信息:ALTER DATABASE OPENFri May 17 14:22:14 CST 2013Beginning crash recovery of 1 threads parallel recovery started with 7 processesFri May 17 14:22:1...

先要下载ntfs-3g下载地址：http://www.tuxera.com/community/ntfs-3g-download/步骤一：解压安装NTFS-3G。tar -xvzf ntfs-3g_ntfsprogs-2013.1.13.tgzcd ntfs-3g_ntfsprogs-2013.1.13执行安装过程如下所示:　　./con...

重建控制文件时resetlogs与noresetlogs的使用情况控制文件中记录着数据库的数据文件,日志文件,备份数据等信息,更为重要的,控制文件中还记录了数据库的检查点和scn信息,这些信息在数据恢复的过程中将起到关键性作用....

RAC数据库出现ORA-27090错误/u01/app/oracle/admin/yyjm/bdump/yyjm2_p000_6379.trcOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Cluste...

业务人员报告说不能登录系统，业务几乎停顿.听到这个消息首先登录主机执行如下命令[/@zzld03]#sar -u1 10 HP-UX zzld03B.11.23 U ia64    04/16/13 10:32:25 &...

今天开发人员执行以下语句时报ora-01801错误select * from lv_busi_record where TO_CHAR(fact_pay_date,'YYYY')='2013'原因是因类fact_pay_date是日期类型但是在fact_pay_date中存有0000-0-0的值所以在执行转换 TO_...

在oracle 11.2.0.1.0 在sql语句中使用with table as 写法时触发了ora-03113错误select pay_bill_no,       hospital_id,       hospital_name,       ...

在Oracle 11.2.0.3.0中执行awrrpt.sql生成awr报告报ora-06502错误ERROR:ORA-06502:PL/SQL:numeric or value error:character string buffertoo small ORA-06502:at "YSY.DBMS_WORKLOAD_REPOSITORY", line 919ORA-065...

数据库是11.2.0.3.0 的rac在使用impdp导入数据时导入进程终止了.后检查告警日志发现如下信息Time drift detected. Please check VKTM trace file for more details.Thu Mar 28 05:45:49 2013Time drift detected. Pl...

在linux系统下,将另一台aix机器上的存储mount到linux下通过nfs,然后在linux下使用expdp导出数据存储在mount到linux下的磁盘上报错ORA-27054: NFS file system where the file is created or resides is not ...