ITPub博客

http://www.diybl.com/course/7_databases/sql/sqlServer/200798/71002_4.htmlhttp://forums.oracle.com/forums/thread.jspa?threadID=625283[@more@]2009-10-29 08:37开启target/123456 alter system set plsql_warning = ‘eanble:all’功能检查pl/sql代码是否存在性能问题死代码可能出现的不可预料的结果或者错误结果1、检查 pesystem_test/pesystem发现了许多performance : oracle隐含地转换数据类型 --当出现例外的情况下需要返回值，如果只是null会触发plw-05005:函数。。。返回的行158不具有值[雨林木风1] re

http://blog.csdn.net/firefoxboy/archive/2008/10/03/3013254.aspx[@more@]导读： 先看一下FGAC:Oracle's Fine Grained Access Control (FGAC) provides a row-level security mechanism that's built-in to the Oracle database engine. FGAC allows you to granularly specify the exact information elements that each user may access. It works by automatically appending a WHERE predicate to the SQL statements executed by the user. For example, if you had an Employees table and wanted to grant each user access to h

http://203.208.39.132/search?q=cache:-y2crSc0FQwJ:www.zxbc.cn/html/20071129/29857.html+oracle+STATISTICS_LEVEL&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy28i7g2w69yXc4P9EBWmA_TlSiDUBA[@more@]今天有朋友数据库启动报错，向我求助。其中报错信息如下： SQL> startup ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information 最后发现问题出在参数设置冲突上，下面模拟这个过程。 --设置参数并重启 SQL> alter system se

from my location [@more@]PropertyDescriptionParameter typeIntegerDefault value900ModifiableALTER SYSTEMRange of values0 to 232 - 1 (max value represented by 32 bits)Real Application ClustersMultiple instances must have the same value.UNDO_RETENTION specifies (in seconds) the low threshold value of undo retention. The system retains undo for at least the time specified in this parameter and automatically tunes the undo retention period to satisfy the undo requirements of the queries.The setting o

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10755/initparams158.htm[@more@]PLSQL_CODE_TYPEPropertyDescriptionParameter typeStringSyntaxPLSQL_CODE_TYPE = { INTERPRETED | NATIVE }Default valueINTERPRETEDModifiableALTER SESSION, ALTER SYSTEMPLSQL_CODE_TYPE specifies the compilation mode for PL/SQL library units.Values:INTERPRETEDPL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine.NATIVEPL/SQL library units (wi

http://203.208.39.132/search?q=cache:FvgqtrKf-IMJ:topic.csdn.net/u/20090103/11/df7a734f-f584-48b3-9971-c825888523ca.html+UTL_FILE_DIR&cd=3&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy28qYonyp2zuxX85bPb7xQIdT-OF8g[@more@]UTL_FILE_DIR lets you specify one or more directories that Oracle should use for PL/SQL file I/O. If you are specifying multiple directories, you must repeat the UTL_FILE_DIR parameter for each directory on separate lines of the initializatio

http://203.208.39.132/search?q=cache:1TaGSJaTpS4J:www.wangchao.net.cn/bbsdetail_571613.html+SESSION_MAX_OPEN_FILES&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2-ioBLmnGPVbaTOMy5JnJvAfsZVbg[@more@]说明: 指定可在任一给定会话中打开的 BFILE 的最大数量。一旦达到这个数量, 此后将无法在该会话中打开更多文件。该参数还取决于操作系统参数 MAX_OPEN_FILES。 　　值范围: 1 - 至少为 (50, OS 级上的 MAX_OPEN_FILES)。 　　默认值: 10 　　parallel_execution_message_size: 　　

Oracle Resumable Space AllocationOracle Tips by Burleson Consulting[@more@]Resumable space allocation, introduced in Oracle 9i, is for all tablespaces at the session level. Database operations are suspended when an out-of-space condition is encountered. These suspended operations automatically resume when the error condition disappears. In Oracle Database 10g, this can be enabled at the instance level. Besides this improvement, automatic alert notification is sent when an operation is suspended

http://203.208.39.132/search?q=cache:442TAM_ydcAJ:blog.oracle.com.cn/index.php/12012/viewspace-6280.html+RESUMABLE_TIMEOUT&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-os-360se&st_usg=ALhdy290zy_Ck3SMisXCD3DcyvYx92J_WA128. In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role.Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of anykind of space-related problems while performing transactions. Inste