Oracle dbcore
dbcore · 共 20 篇文章
Built-In Functions (By Category)
http://www.techonthenet.com/oracle/functions/index.php
2011-10-30 14:57 · SQL · 评论(0)
使用 DBMS_APPLICATION_INFO 进行实时监控
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 rows inserted ... ...…
2011-10-26 10:55 · 性能 · 评论(0)
ORA-00942: 表或视图不存在
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 * 第 1 行出现错误: ORA-02030: 只能从固定的表/视图查询 SQ…
2011-10-26 09:49 · ORA- · 评论(0)
ORA-01536: 超出表空间 'USERS' 的空间限额
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/*** SQL> create table s_employee_tes…
2011-10-26 09:41 · ORA- · 评论(0)
system用户无法删除表空间解决
在一个客户的数据库中,想删除一个表空间,但是被拒绝 现象如下: 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: at line…
2011-09-23 12:53 · 数据恢复 · 评论(0)