文章列表
http://www.techonthenet.com/oracle/functions/index.php
dbms_application_info 包，用于交换环境中执行处理的时间点信息。
让一个长时间运行的PL/SQL程序提供处理信息。以下代码段每隔1000 行记录就更新应用程序的信息，内容主要是处理的记录数和花费的时间。
conn plsql/plsql
SQL> create table s_employee_test as select * from hr.employees;
Table created
SQL> insert into s_employee_test select * from s_employee_test
2 ;
29 ...
SQL> conn hr/***
SQL> select username,sid,serial#,module,action from v$session;
select username,sid,serial#,module,action from v$session
ORA-00942: 表或视图不存在
解决：
sqlplus "sys/*** as sysdba"
SQL> grant select on gv$session to hr;
grant select on gv$session to hr
...
SQL> conn hr/***
SQL> create table s_employee_test as select * from employees;
create table s_employee_test as select * from employees
ORA-01536: 超出表空间 'USERS' 的空间限额
解决：
sqlplus "sys/*** as sysdba"
SQL> alter user hr quota unlimited on users;
用户已更改。
SQL> conn hr/***
SQ ...
在一个客户的数据库中,想删除一个表空间,但是被拒绝
现象如下:
drop tablespace gsdata_mid including contents
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20052: ORA-20052: TableSpace Agent Error!
ORA-06512: at line 5
ORA-06512: at "ASSET.TOPSEXCEPTION", line 30
ORA-06512: at line 1
ORA-06512 ...