ITPub博客

SQL> desc DBMS_SHARED_POOL Object DBMS_SHARED_POOL does not exist. 想用一下DBMS_SHARED_POOL.keep，数据库报上面的错误，这个包居然没安装。。。[@more@]SQL> desc DBMS_SHARED_POOLObject DBMS_SHARED_POOL does not exist. SQL> @D:oracleproduct10.2.0db_1RDBMSADMINdbmspool.sql Package created Grant succeeded View created Package body created SQL> @D:oracleproduct10.2.0db_1RDBMSADMINprvtpool.plb View created Package body created SQL> desc DBMS_SHARED_POOL;Element Type

一个测试库好久没用了，今天登上去报ora-09817的错误。查oracle文档是这么说的，ORA-09817: Write to audit file failed.Cause: ORACLE was unable to write an entry to the file used as the audit trail.Action: Check the UNIX error number for a possible operating system error. Ifthere is no error, contact Oracle Support Services.[@more@]SQL> conn / as sysdbaERROR:ORA-09817: Write to audit file failed.HPUX-ia64 Error: 28: No space left on devicORA-01075: you are currently logged on 安装oracle的目录/home

数据库升级到10g后怪事就是多，经常碰到session被killed，第二天早上来看还是没被后台进程清除。这种情况下就不能用v$process和v$session表关联查出spid,接着在os中杀进程啦。可以用下面的方法处理。[@more@]select spid, program, a.* from v$process a where program != 'PSEUDO' and addr not in (select paddr from v$session) and addr not in (select paddr from v$bgprocess) and addr not in (select paddr from v$shared_server);11G中v$session加了CREATOR_ADDR、CREATOR_SERIAL#，找出killed会话的spid更方便啦。CREATO

Purpose:========The purpose of this article is to clarify the RMAN statement: "backup archivelog until time 'XXXX'.[@more@]Scope & Application:====================This note is applicable to all users who use RMAN to perform backups.The Meaning of RMAN "Backup Archivelog Until Time 'XXXX'":==========================================================Setup:------sqlplus > connect / as sysdba> alter system archive log stop;> alter system switch logfile;> select to_char(

RMAN Fast Incremental Backups [ID 262853.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED PURPOSE-------This article discusses the Oracle 10g new feature called 'block change tracking' and how it helps accelerate RMAN incremental backups. [@more@]SCOPE & APPLICATION-------------------This article is intended for DBAs and Support Engineers.Fast Incremental Backups using the Block Change Tracking feature is only avail

。。。[@more@]当我们对索引进行rebuild时,如果不加online选项,oracle则直接读取原索引的数据;当我们添加online选项时,oracle是直接扫描表中的数据。 所以alter index online 耗时更长。

从support中看到的一篇文章，估算备份归档日志所需的空间，顺手贴出来，方便其他人。[@more@] ***Checked for relevance on 29-Jul-2010*** Introduction ------------ If the database runs in archivelog mode, then Oracle will archive the online redo log files whenever a log switch occurs. It is important that there is enough free space on the dedicated disk(s) for the archive files, otherwise the ARCHiver process can not write and a crash is inevitable. This article determines how much free

数据库字符集ZHS16CGB231280 aix操作系统[@more@]Export done in US7ASCII character set and AL16UTF16 NCHAR character setserver uses ZHS16CGB231280 character set (possible charset conversion)备份文件中一直存在上面的提示，但是考虑到aix的nls_lang已经设置为AMERICAN_AMERICA.ZHS16CGB231280，以为不是nls_lang的问题啦，翻来覆去，google到所有的资料都显示nls_lang设置问题，到最后将“export nls_lang=AMERICAN_AMERICA.ZHS16CGB231280”中的nls_lang改为大写就好使了，我倒~~~！~~~

应用升级的时候,用oem控制台看temp表空间已经满了。但是toad图形显示used为0%。 跑完下面的脚本让我更加相信toad啦~[@more@]The following are a few queries that can be used to list more meaningful information about the temporary segment usage:This will give the "high water mark" of that temporary tablespace (= max used at one time): select tablespace_name, sum(bytes_cached)/1024/1024 mbfrom v$temp_extent_poolgroup by tablespace_name;This will give current usage:select ss.tablespace_

给自己提了个问题，顺手验证了一把[@more@]1、以scott账户登录SQL> conn scott/tigerConnected.SQL> SQL> SQL> SQL> show user;USER is "SCOTT"SQL> SQL> select * from dual;D-X2、另起一个sqlplus窗口 SQL> conn / as sysdbaSQL> alter user scott account lock;SQL> alter user scott account lock;User altered.SQL> conn scott/tigerERROR:ORA-28000: the account is lockedWarning: You are no longer connected to ORACLE.3、返回原先的sqlplus窗口SQL> select * from dual;D-X

记录rman学习过程中搜集的资料。。。[@more@] 1024x768 Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4