随笔分类 - Oracle
摘要：Operator "OR" in SQL statement may lead to inefficient "correlated sub-query". Watch out!
阅读全文
摘要：Using UTL_FILE and DBMS_XSLPROCESSOR to write CLOB into files.
阅读全文
摘要：Library Cache Lock could be caused by connecting to database using wrong password.
阅读全文
摘要：Beginning with Oracle Database 11g Release 2 (11.2.0.2), you can create policies on applications that include MERGE INTO operations
阅读全文
摘要：Use DBMS_SQL with caution, it can not only lead to "memory leak" issue, but also cause security issue.
阅读全文
摘要：Oracle Character set – Everything a New oracle DBA needs to know
阅读全文
摘要：TTS is not designed to replace schema level exp/imp
阅读全文
摘要：The differences between the functions that return CLOB and VARCHAR2 used in SQL statement
阅读全文
摘要：Abuse of LOB in SQL is nightmare. This article gives out an example on the efficiency of LOB operation.
阅读全文
摘要：A working example that bad SQL statement causes too much CPU usage.
阅读全文
摘要：Though we can set down some rules for the PL/SQL naming convention, it’s totally depending on developers’ morality to obey or ignore these rules. Fortunately, Oracle 11g introduces a new feature called “PL/SCOPE” which can be used for naming violation examination. By querying the Oracle view “USER_IDENTIFIERS”, you can know which variable in PL/SQL code violates the rules we have made. However, it’s not trivial to do this by simply querying this view, it’s good to have some utility wrapper for
阅读全文
摘要：ORA-01795: maximum number of expressions in a list is 1000
阅读全文
摘要：A simple DBMS_LOB example
阅读全文
摘要：Using BAT for multi-thread/process processing
阅读全文
摘要：The definition, cause, and the solution to the wait event -- buffer busy waits
阅读全文
摘要：The reason causes the error ORA-12519 and the resolution
阅读全文
摘要：All about the sql parse (hard/soft) in PL/SQL cursors (implict cursor, explict cursor, ref cursor)
阅读全文
摘要：Use PLSQL Conditional Compilation in Database Script maintenance
阅读全文
摘要：有时候通过sys_context('userenv', 'host') 来获取当前session的client host的名字，结果却得到一个空值，很是奇怪！每次都是重启下电脑就OK了，我怀疑是windows操作系统的问题，但是又没法得到很有利的证明，因为不知道这个sys_context('usrenv', 'host') 是怎么实现的，内部代码是啥自然不清楚 :(不管怎样，猜测sys_context('userenv', 'host') 应该跟v$session中的MACHINE应该是一样的。那么
阅读全文
摘要：Oracle提供了好些方法来获取连接数据库的客户端机器名和数据库所在的机器名，最常见的是从视图v$instance和v$session中获得，如下....V$INSTANCEv$instance中的host_name显示的是数据库服务器所在的机器名...SQL> select host_name from v$instance;HOST_NAME----------------------------------------------------------------SZV-DEV-LO-D02SQL> V$SESSIONv$session中的MACHINE （TERMINAL
阅读全文
浙公网安备 33010602011771号