view oracle alert logs in oracle databse

PLAIN TEXT
SQL:

  1. www.ads1st.com SHOW parameter background_d
  2.  
  3. NAME  &nb[......]

继续阅读

kill oracle thread on windows

PLAIN TEXT
SQL:

  1. SQL> SELECT b.STATUS, object_id, session_id
  2.   2  &nbs[......]

继续阅读

11.2 Dictionary

ALL_ALL_TABLES Description of all object and relational tables accessi[......]

继续阅读

How to disable or enable flush of ASH data to AWR

MMON process will periodically flush ASH data into AWR tables.
Oracle introduced WF enqu[......]

继续阅读

Using 32 byte PL/SQL Devoloper on 64 byte platforms

  1. 安装32位的Oracle客户端,如11g;
  2. 新建一个批处理文件plsqldev_64.bat,内容如下
  3. @echo off
    set path=d:\oracle\11g\bi[......]

继续阅读