-
编辑 删除
1Z0-043记录(一)
1、You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 11...
-
编辑 删除
ora-600 4147 occurs when you query flashback_transaction_query
in oracle 10204,I query the view like that: SELECT /*+ ordered*/* FROM flashback_transaction_query t WHERE t.table_name='TEST_A' AND t.logon_user='FZTXT'; &nb...
-
编辑 删除
1Z0-042 记录(四)
242. Consider the following scenario: You have a directory, data, under the disk group tdgroup A. You want to create an alias for one of the data files and you execute the following command:ALTER DIS...
-
编辑 删除
1Z0-042记录(三)
201. You work as a database administrator for Supportcenter.cn. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this? (Select two)...
-
编辑 删除
"or" and "( )" make execution plan difference
test_c as 1160 rows.It has a columan called "STRDHHM".a function index is created in the column "STRDHHM".The statment is like that: create index IND_AUTO_CUSTOMER...
-
编辑 删除
ORA-07445： exception encountered： core dump [evaopn2()+2628]
os version: linuxoracle version: oracle 9204-----------------------------------------------------------------------------------------When I execute a sql in procedure ,It disconnect. It’s amazing.se...
-
编辑 删除
1Z0-042记录(二)
81. You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEEtable. You plan to add a new column to EMPLOYEE table to achieve this.Which data type would yo...
-
编辑 删除
1Z0-042 记录(一)
3. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take ca...
-
编辑 删除
linstener hang
oracle environment: Oracle Net Services - Version: 10.1.0.3.0 to 10.2.0.2.0 - Release: 10.1 to 10.2 when use this version,listener may be hang.The situation is that...
-
编辑 删除
sysaux tablespace managment-->about awr/advisor/optstat
Sysaux talbespace contain awr、advisor and optstat. Default, the content of awr will retain 7 days,and optstat will retain 31 days. You can change the default valu...
-
编辑 删除
SMON: Parallel transaction recovery tried 引发的问题
SMON: Parallel transaction recovery tried 这个一般是在 具有在跑大数据量的 transaction的时候 kill 掉了进程而导致 smon 去清理 回滚段时导致的。 这个在 业务高峰期的时...
-
编辑 删除
ora-00600 [17182], [0x60000000005A49C8], [], [], [], [], [], []
environment: hp unix Release: B.11.23Version: UMachine: ia64oracle 9.2.0.6...
-
编辑 删除
what does unknown mean in v$rollstat.status
Often, v$rollstat.status has 4 values whitch are ONLINE,PENDING OFFLINE,OFFLINE,FULL.I have seen unknown in v$rollstat.status.what does It meaning?through metalink(id:736905.1):The following query wi...
-
编辑 删除
ORA-00600 [keltnfy-ldmInit], [46] when startup nomount
I changed the hostname of linux os a short time begore. And then,I also changed the "host=dataguard1" to "host=dg2" in listener.ora.I thought it's enough. then ,I did followed:sql...
-
编辑 删除
Cannot determine all dependent dynamic libraries for /proc/self/exe
when I startup the db ,alert.log shows these messages:Starting ORACLE instance (normal)Cannot determine all dependent dynamic libraries for /proc/self/exe Unable to find dynamic library libocr10.so i...
-
编辑 删除
vmware 里的 rac install 的记录
最近想学 rac，所以在虚拟机上装了下，前前后后总共花了 一星期的时间，由于对 rac 很不熟悉，所以很多内容也无从考证，但是总得记录的： 安装过程，都是参考 三思的文档和...
-
编辑 删除
rman 恢复一例 restore controlfile
>rman target /恢复管理器: Release 10.2.0.1.0 - Production on 星期三 5月 12 09:43:02 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.已连接到目标数据库 (未启动)RMAN> Oracle 实例已启...
-
编辑 删除
rman 的一点点
BACKUP DATABASE PLUS ARCHIVELOG; 做了什么You can add archived redo logs to a backup of other files by using the BACKUP ... PLUS ARCHIVELOG clause. Adding BACKUP ... PLUS ARCHIVELOG causes RMAN to do ...
-
编辑 删除
视图 order by 导致执行计划改变
CREATE TABLE test_aaa AS SELECT * FROM Dba_Objects;CREATE TABLE test_bbbb AS SELECT * FROM Dba_Objects WHERE ROWNUM<=10000;INSERT INTO test_bbbb SELECT * FROM test_bbbb; --执行 2 次CREATE INDE...
-
编辑 删除
绑定变量的使用
绑定变量的变迁和使用像 select * from test where ch1=1; ----1 是常量无论是 存储过程（PL/SQL）还是 一般的 语句在 9i 中，都会变成 select * from test where ch1='SYS_...' --系统自动生...
