全部博文(136)
分类: Oracle
2008-05-08 22:10:51
…… IMP-00003: ORACLE error 911 encountered ORA-00911: invalid character IMP-00017: following statement failed with ORACLE error 4043: "ALTER PROCEDURE "PRC_T_PERSON_ID_????" COMPILE REUSE SETTINGS TIMESTAMP '20" " IMP-00003: ORACLE error 4043 encountered ORA-04043: object PRC_T_PERSON_ID_???? does not exist About to enable constraints... Import terminated successfully with warnings. …… |
SQL> select userenv('language') from dual; USERENV('LANGUAGE') ------------------------------------------- SIMPLIFIED CHINESE_CHINA.ZHS16GBK |
update ac01 set akc023 = n_akc023 where aac001 = v_aac001; |
SQL> SELECT MAX(DISK_READS) DISK_READS, 2 MAX(BUFFER_GETS) BUFFER_GETS, 3 MAX(ROWS_PROCESSED) ROWS_PROCESSED, 4 MAX(EXECUTIONS) EXECUTIONS 5 FROM V$SQLAREA; DISK_READS BUFFER_GETS ROWS_PROCESSED EXECUTIONS ---------- ----------- -------------- ---------- 109547 36286762 9020860 9020860
SQL> select sql_text from v$sqlarea where EXECUTIONS >= 9020860;
|