043中有一道题:You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy ofthe control tile available. You want to restore the control tile from an autobackup. To retrieve theautobackup, you need the database ID (DBID). In which two sources would you find the DBID?(Choose two.)A - the trace fileB - the alert log fileC - an RMAN session log fileD - the server parameter fileE - the formatted name of a control file autobackup答案为

Question: 43The database is currently running in the NOARCHIVELOG mode.What would be the first step to configure Flashback Database?A. Enable flashback logging.B. Start the database in the ARCHIVELOG mode.C. Issue the ALTER DATABASE FLASHBACK ON; command.D. Set the FAST_START_MTTR_TARGET initialization parameter.

哪位能解释一下 coalesce 一个索引和coalesce 一个索引表空间的做法.并说哪个会影响相应的查询?

各位大师帮我分析是哪方面出了问题1.alert_log没什么异常.2.sqlplus 连接不上$ sqlplus /nologSQL*Plus: Release 9.2.0.8.0 - Production on Tue Jul 29 12:22:38 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.SQL> conn /as sysdbaConnected to an idle instance.3. $ ps -ef |grep CTMESP1|grep -v ora_|wc -l3884.topas 显示cpu 98.7% 了,但每个进程点cpu都是0.4左右,Topas Monitor for host:CTMESP1EVENTS/QUEUESFILE/TTYTue Jul

SQL> /(SELECT B.MTRL_TYPE_CODE*ERROR at line 15:ORA-02070: databasedoes not support correlation in this context下面这个SQL词,平时一直是很正常的,不知现在出了个ora-02070, 查了error messageORA-02070 database stringstring does not support string in this contextCause: The remote database does not support the named capability in the context in which it is used.Action: Simplify the SQL statement我从未用过dblink ,所以

今天接到通知说要修改DB sys的密码,说是修改sys密码之后需要重启DB,我找了好多资料都没看到修改sys密码要重启DB的说法,心想是不是通知的多此一举了!

各位!有谁能帮位整理出 oracle 各个版本对Asynchoronous I/O 在各OS上的支持情况！和具体的操作步骤.我想一定很有用!

今天发现oemapp console 登陆oem主机时一直等待,而且在listener的 log中发现许多service_died的信息:01-APR-2008 09:33:48 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OEMSH.WALSIN.COM)(CID=(PROGRAM=jre)(HOST=oemoracle.walsin.com)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.39)(PORT=51351)) * establish * OEMSH.WALSIN.COM * 001-APR-2008 09:33:48 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OEMSH.WALSIN.COM)(CID=(PROGRAM=jre)(HOST=oemoracle.walsin.com)(USER=oracle))) * (ADDR

最近老板问关于在两地(很远哦)能否做两台oracle DB　1.这两台能同步数据，2.而且每台都支持客户应用程式（sap的）,3.还有要是一台down掉，另外一台能够临时接所有的sap应用程式，我想了想，data guard 能满足 1 , 3 不能满足 2　　所以不可以．分布式数据库　能满足 2是否能满足 1 , 3还是个未知数？请教各位是否有什么更好的方案！

Sat Dec 29 02:17:19 2007ORA-04031: unable to allocate 1056856 bytes of shared memory ("large pool","unknown object","large pool","KSFQ Buffers")ksfqxcre: failure to allocate shared memory means sync I/O will be usedwhenever async I/O to file not supported natively这几天DB老是有这样的ERROR.错误发生的时间是凌晨2点,也是我的设定备份的时间.我初步检查如何POOLNAMEBYTES----------- -------------------------- ----------large poolfree

SQL> select 1+null aa from dual;AA----------SQL> create table test (id int, value int);Table created.SQL> insert into test values(1,1);1 row created.SQL> insert into test values(2,null);1 row created.SQL> select * from test;IDVALUE---------- ----------112SQL> select sum(ID),sum(value) from test;SUM(ID) SUM(VALUE)---------- ----------31SQL> select * from test wh

每到月底,机器的负荷都比较大,现在又产生这个 ora-600error ,操作都很慢请各位老大帮忙看看,这个错误怎么解决!SQL> conn /as sysdbaConnected.SQL> select * from dba_ddl_locks;select * from dba_ddl_locks*ERROR at line 1:ORA-00600: internal error code, arguments: [17059], [0x70000008732E238], [],[], [], [], [], []alert:Wed Nov 28 20:11:28 2007Errors in file /oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_811092.trc:ORA-00600: internal error code, arguments