-
编辑 删除
配置RMAN恢复目录
1、创建rman用户及相应的tablespaceSQL> conn sys/admin@redhat_db as sysdba已连接。SQL> set wrap offSQL> set linesize 1000SQL> set timing onSQL> select * from v$version;BANNER-------------------------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionPL/SQL Release 9.2.0.4.0 - ProductionCORE 9.2.0.3.0 ProductionTNS for Linux: Version 9.2.0.4.0 - ProductionNLSRTL Version 9.2.0.4.0 - Production1、创建rman用户及相应的
-
编辑 删除
国外公司的Oracle DBA试题
Oracle DBA Interview Questions By B G1. How many memory layers are in the shared pool? 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? 3. How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?4. Define the SGA and:? How you would configure SGA for a mid-sized OLTP environment?? What is involved in tuning the SGA?5. What is the cache hit ratio, what impact does it have on perf
-
编辑 删除
Oracle9i初始化参数中文说明
Oracle9i初始化参数中文说明http://www.cnblogs.com/zhangyong/archive/2004/11/30/71005.aspx[@more@]
