-
编辑 删除
[from metalink]PROGRAMS TIME OUT WAITING FOR LIBRARY CACHE PIN
os:window 2003 serveroracle:9204when I recompile the procedure,it takes a long time and makes an "ORA-4021" error at the end.After I restart the os,it does well.maybe,it's a bug.PROGRAMS TIME OUT...
-
编辑 删除
the supplement records of ocp
You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME = PR...
-
编辑 删除
[转]an example of recreating controlfile with offline and read only datafile
假如数据库中存在offline 的datafile，read only 的Tablespace，这时重建控制文件，控制文件中是否会有关于offline datafile, read only tablespace的信息呢？要如何恢复呢？ SQL> alter database datafile...
-
编辑 删除
An experiment of recovering read-only tablespace using backup controlfile
An experiment of recovering read-only tablespace using backup controlfileWhen the tablespace users was read write ,I backup the database with autobackup on.Rman> backup database plus archivelog delete...
-
编辑 删除
1Z0-007
24: In which three cases would you use the USING clause? (Choose three.)A.You want to create a nonequijoin.B.The tables to be joined have multiple NULLcolumns.C.The tables to be joined have columns o...
-
编辑 删除
[from metalink]OCR、Vote disk Maintenance Operations
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devices. [ID 428681.1] Modified 16-NOV-2009 ...
-
编辑 删除
the record of learning asm
1、 create a diskgroup for asm(no failure groups)when you create a external diskgroup,the initial state of the diskgroup is dismount,you can query the view v$asm_diskgroup to see it.Sql>CREATE DISKG...
-
编辑 删除
1Z0-043记录(四)
43、You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME ...
-
编辑 删除
1Z0-043记录(三)
29、You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group:ALTER DISKGROUP dgroup1ADD TEMPLATE my_tempATTRI...
-
编辑 删除
1Z0-043记录(二)
18、You are working on an Oracle Database 10g database. Because of data loss, you decided to perform. a Flashback Database operation using the following command:SQL> FLASHBACK DATABASE TO TIMESTAMP(S...
-
编辑 删除
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...
