dbtan 谈DB

How To Automate Cleanup Of Dead Connections And INACTIVE Sessions [ID 206007.1]

---

Modified 25-JUN-2009     Type HOWTO     Status PUBLISHED

PURPOSE
-------This note explains the difference between a dead connection and an
INACTIVE session in v$session.  It also discusses the mechanisms
provided to automate the cleanup of each.SCOPE & APPLICATION
-------------------This note is intended for any DBA who wants to automate the cleanup of
dead connections and/or INACTI
... ...
<阅读全文>

今天打算启用一下Oracle Database 11g的Database Control，但提示如下：

[oracle@test7: ~]$emctl status dbconsole
OC4J Configuration issue. /oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_test7_ccdb not found.

马上来看一下相应目录下，是否有OC4J_DBConsole_test7_ccdb呢？

[oracle@test7: ~/product/11.1.0/db_1/oc4j/j2ee]$ll -thd OC4J_DBConsole*
drwxr-x--- 10 oracle oinstall 4.0K Jun 30 11:41 OC4J_DBConsole_localhost.localdomain_ccdb
drwxr-xr-x  6 oracle oinstall 4.0K Jun 30 11:18 OC4J_DBConsole

没
... ...
<阅读全文>

在EXP导出时，出现EXP-00091报错：

. . exporting table                         FRIEND
..............
                                                       142480 rows exported
... ...
<阅读全文>