ITPub博客

收藏...[@more@]一. 视图说明:1. SYS.AUD$审计功能的底层视图,如果需要对数据进行删除,只需要对aud$视图进行删除既可,其他视图里的数据都是由aud$所得.2. DBA_AUDIT_EXISTS列出audit not exists和audit exists产生的审计跟踪,我们默认的都是audit exists.3. DBA_AUDIT_TRAIL可以在里面查处所有审计所跟踪的信息.4. DBA_AUDIT_OBJECT可以查询所有对象跟踪信息.(例如,对grant,revoke等不记录),他的信息完全包含于dba_audit_trail5. DBA_AUDIT_SESSION所得到的数据都是有关logon或者logoff的信息.6. DBA_AUDIT_STATEMENT列出grant ,revoke ,a

....[@more@]error 信息Errors in file /oracle/app/oracle/admin/prd/bdump/prd_j000_688158.trc:ORA-12012: error on auto execute of job 8897ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalidORA-06512: at "SYS.PRVT_ADVISOR", line 1624ORA-06512: at "SYS.DBMS_ADVISOR", line 186ORA-06512: at "SYS.DBMS_SPACE", line 1344ORA-06512: at "SYS.DBMS_SPACE", line 1560The issue was noticed because of repeated occurence o

...........[@more@]News & NotesOracle终生支持政策还让客户将产品的升级策略控制在自己手中。通过Oracle灵活的支持政策，客户可以针对Oracle产品，从容地制定出自己的升级规划和预算，而不必时刻担心自己运行的版本失去支持。一旦出现升级的需要，客户无需花费任何额外成本，即可获得最新版本的产品，充分享受Oracle领先技术所带来的好处，确保自己的发展与世界的同步。 Oracle终生支持政策：从5年到永远 标准支持服务(Premium Support)：最新业界支持标准 Oracle标准支持服务(Premium Support)是一项获奖的支持服务计划，代表着下一

以前,很少安装这些Sample Sechemas ,也没研究过这些东西是干吗的,[@more@]Sample SchemasMost of the included accounts are administrative accounts, but Sample Schema accounts are also present. The Oracle Database Sample Schemas are a set of interlinked schemas that enable Oracle documentation, and Oracle by Example Series, to illustrate common database tasks:The human resources (hr) schema is useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.The

只是在别人没有恢复成功的基础上,自己随便测试再次恢复,请在生产系统,慎重考虑[@more@][test:oratest] /oratest/home>[test:oratest] /oratest/home> sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 14 13:34:31 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1241513984 bytesFixed Size 2070912 bytesVariable Size 318768768 bytesDatabase Buffers 905969664 bytesRedo B

..........[@more@]ComponentUNIX ToolCPUsar, vmstat, mpstat, iostatMemorysar, vmstatDisksar, iostatNetworknetstatThe awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids.The awrrpti.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot Ids on a specified database and instance.The awrsqrpt.sql SQL script generates an HTML or text report that displays statistics of a particular SQL statement for a rang

To assist in the rollout process, build a list of tasks that—if performed correctly—will increase the chance of optimal performance in production and—if there is a problem—enable rapid debugging of the application:[@more@]1.When you create the control file for the production database, allow for growth by setting MAXINSTANCES, MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, and MAXLOGHISTORY to values higher than what you anticipate for the rollout. This results in more disk space usage and bigger

...[@more@]Table 2-6 Administrative User Accounts Provided by Oracle DatabaseUsernamePasswordDescriptionSee AlsoCTXSYSCTXSYSThe Oracle Text accountOracle Text ReferenceDBSNMPDBSNMPThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the databaseOracle Enterprise Manager Grid Control Installation and Basic ConfigurationLBACSYSLBACSYSThe Oracle Label Security administrator accountOracle Label Security Administrator's GuideMDDATAMDDATAThe schema used

.........[@more@]ViewDescriptionV$SGADisplays summary information about the system global area (SGA).V$SGAINFODisplays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.V$SGASTATDisplays detailed information about the SGA.V$SGA_DYNAMIC_COMPONENTSDisplays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup.V$SGA_DYNAMIC_FREE_MEMORYDisplays

B19306_01[@more@]Step 1: Decide on Your Instance Identifier (SID)Step 2: Establish the Database Administrator Authentication MethodStep 3: Create the Initialization Parameter FileStep 4: Connect to the InstanceStep 5: Create a Server Parameter File (Recommended)Step 6: Start the InstanceStep 7: Issue the CREATE DATABASE StatementStep 8: Create Additional TablespacesStep 9: Run Scripts to Build Data Dictionary ViewsStep 10: Run Scripts to Install Additional Options (Optional)Step 11: Back Up the

B19306_01 阅读笔记(character set)[@more@]Caution: AL32UTF8 is the Oracle Database character set that is appropriate for XMLType data. It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character encoding UTF-8. Database character set UTF8 has been superseded by AL32UTF8. Do not use UTF8 for XML data. UTF8 supports only Unicode v

今天看到一个ORA-00610:Internal error code错误,[@more@]ORA-00610:Internal error codeCause:Oracle process started too lateAction:This error should never be seen by the customer. Contact Oraclce Support

.....[@more@]今天随便打开一个trace file 的时候，发现里面有大量的“AUTO SGA: Not free ”于是，检查SGA/内存使用情况等等，没发现任何异常，最后向METALINK 发TAR ，发现是个BUG ，并不是因为SGA 真的不够了。*** 2007-02-06 21:00:04.582*** SERVICE NAME:(SYS$BACKGROUND) 2007-02-06 21:00:04.577*** SESSION ID:(388.1) 2007-02-06 21:00:04.577AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1AUTO SGA: Not free 0x70000016df8dd18, 1, 1, 1AUTO SGA: Not free 0x70000016df8de18,

记录一下[@more@]今天发现RMAN 中V$ARCHIVED_LOG 中STATUS 为"X" 的文件,想起是因为手动删掉错几个日志造成的,通过如下的方法把RMAN 中的记录也删掉test:oracle] /oracle/home> rman target /Recovery Manager: Release 10.2.0.2.0 - Production on Wed Feb 7 14:31:47 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: PRD (DBID=2733534212)RMAN> crosscheck archivelog all;using target database control file instead of recovery catalogallocated channel: ORA_DISK_1c

............[@more@]''Sbt Error = 7011, Errno = 959'' Error When Backing Up To Tape Doc ID: Note:377512.1 Type: PROBLEM Last Revision Date: 09-JAN-2007 Status: PUBLISHED In this Document Symptoms Cause Solution References -------------------------------------------------------------------------------- Applies to: Oracle Server - Enterprise Edition - Version: 9.2 to 10.2 This problem can occur on any platform. SymptomsAllocate channel using RMAN and Tivoli TDP version 5.2 is getting RMAN-03009 OR

....[@more@]http://orafaq.com/parms/index1020.htm

...................[@more@]Re: Oracle 10.2.0.2 and TOAD brings ORA-600 by Ronald Breuer Mar 17, 2006; 05:13pm :: Rate this Message: (use ratings to moderate[?])Reply | Reply to Author | View this Message in the Context of Discussion Hello John, I guess there are a lot of problems switching the Data Dictionary from RBO to CBO. There are a lot of Hidden Parameters starting with "_optimizer" in 20.2. See: http://www.orafaq.com/parms/index1020.htm If you search in MeataLink you will fi

.............[@more@]Subject: Ora-600 [15160] Joining Dba_objects and Dba_segments Doc ID: Note:351092.1Type: PROBLEM Last Revision Date: 14-AUG-2006Status: PUBLISHEDIn this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1 to 10.2This problem can occur on any platform.SymptomsThe following internal error is reported: ORA-600 [15160] JOINING DBA_OBJECTS AND DBA_SEGMENTSCurrent SQL statement for this session is: SELECT o.owner, o.obje

...[@more@]ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available for this return code. Technote (FAQ) Problem LAN-free backups from Data Protection for Oracle fail. The first one is successful and any subsequent ones fail. Here are the full error messages generated : RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 0

今天在自己的PC 上安装一个ORACLE 10G ,给了最少的内存,结果,在创建库最后了报了如下的错误,后来增加了部分SGA ,再安装就成功了C:Documents and Settingsibm>dbcaERROR :oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-04031: 无法分配 540 字节的共享内存 ("shared pool","declare[@more@]