Oracle内置包的使用方法资源-CSDN文库

共250个文件

htm：220个

jpg：22个

gif：8个

oracle

package

需积分: 43 64 浏览量 2008-06-27 12:31:57 上传评论收藏 1.72MB RAR 举报

资源详情

资源评论

资源推荐

收起资源包目录

Oracle内置包的使用方法（250个子文件）

disc.gif 2KB

new.gif 250B

bar32.gif 63B

bar16.gif 53B

bar8.gif 47B

bar4.gif 43B

bar2.gif 40B

bar1.gif 38B

dbms_stats.htm 94KB

index.htm 81KB

builtin_packages.htm 75KB

tables.htm 64KB

dbms_serv_alert.htm 60KB

exception_handling.htm 58KB

dbms_sql.htm 57KB

dbms_wm.htm 54KB

dbms_advisor.htm 54KB

constraints.htm 52KB

database.htm 52KB

indexes.htm 48KB

dbms_utility.htm 48KB

utl_file.htm 44KB

startup_parms.htm 44KB

datatypes.htm 43KB

number_func.htm 43KB

hints.htm 43KB

presentations.htm 42KB

dbms_metadata.htm 42KB

type.htm 41KB

jul03.htm 39KB

sqlplus.htm 37KB

bulk_collect.htm 37KB

tablespaces.htm 35KB

dbms_sqltune.htm 35KB

dbms_lob.htm 34KB

dbms_profiler.htm 34KB

conditions.htm 34KB

dbms_rls.htm 33KB

procedures.htm 31KB

dbms_aqadm.htm 31KB

dbms_space.htm 30KB

dbms_expfil.htm 30KB

model_clause.htm 29KB

date_func.htm 29KB

oradebug.htm 28KB

sqlloader.htm 28KB

partitions.htm 27KB

regexp.htm 26KB

user.htm 26KB

intermedia_a.htm 26KB

dbms_session.htm 26KB

forms.htm 26KB

functions.htm 25KB

utl_raw.htm 25KB

dbms_crypto.htm 25KB

packages.htm 25KB

dbms_ext_tts_chks.htm 24KB

aq_demo2.htm 24KB

string_func.htm 23KB

init_dot_ora.htm 23KB

unix_vi.htm 23KB

dbms_repair.htm 23KB

clusters.htm 23KB

utl_smtp.htm 23KB

intermedia_v.htm 23KB

aq_demo1.htm 22KB

dbms_job.htm 22KB

dbms_res_mgr.htm 22KB

rman.htm 22KB

trace_tkprof.htm 22KB

listener.htm 21KB

dbms_mview.htm 21KB

system_privs.htm 21KB

loops.htm 21KB

materialized_views.htm 20KB

dbms_resumable.htm 20KB

utl_compress.htm 19KB

sequences.htm 19KB

timestamp.htm 19KB

joins.htm 19KB

table_trigger.htm 19KB

instead_of_trigger.htm 19KB

dbms_warning.htm 19KB

decode_case.htm 19KB

dbms_monitor.htm 19KB

pseudocols.htm 19KB

ddl_trigger.htm 18KB

utl_i18n.htm 18KB

dbms_rowid.htm 18KB

views.htm 18KB

dbms_xmlgen.htm 18KB

dbms_redefinition.htm 17KB

dbms_wrkld_repos.htm 17KB

system_events.htm 17KB

insert.htm 17KB

net_services.htm 16KB

dbms_describe.htm 16KB

sys_context.htm 16KB

operator.htm 16KB

profiles.htm 15KB

共 250 条

<html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <title>Oracle DBMS_STATS Optimizer Statistics Analyze</title> </head> <body background="../source/binary.gif" text="#000000" vlink="#800080" alink="#00FFFF" bgcolor="#FFFFFF"> <div align="center"> <script language="JavaScript"> { graphic1= new Image(); graphic1.src = "../source/home1.jpg"; graphic1on = new Image(); graphic1on.src = "../source/home2.jpg"; graphic2= new Image(); graphic2.src = "../source/education1.jpg"; graphic2on = new Image(); graphic2on.src = "../source/education2.jpg"; } function imageChg(imageID2,imageName2) { { document.images[imageID2].src = eval(imageName2 + ".src"); } } </script> <div align="center"> <table border="0" cellpadding="0" cellspacing="0" width="90%"> <tr> <td width="20%"></td> <td> <h3 align="center">Oracle DBMS_STATS</h3> </td> <td align="right" rowspan="2" width="20%"> <div align="right"> <table border="1" cellpadding="0" cellspacing="0"> <tr> <td> <a href="../home.htm" target="topic" onmouseover="imageChg('a','graphic1on')" onmouseout="imageChg('a','graphic1')"> <img src="../source/home1.jpg" border="0" name="a" width="120" height="20"></a> </td> </tr> <tr> <td> <a href="../education.htm" target="topic" onmouseover="imageChg('b','graphic2on')" onmouseout="imageChg('b','graphic2')"> <img src="../source/education1.jpg" border="0" name="b" width="120" height="20"></a> </td> </tr> </table> </div> </td> </tr> <tr> <td width="20%"></td> <td ALIGN="center"> Version 10.1 </td> </tr> </table> <table border="1" width="90%" bgcolor="#D8D8C4"> <tr> <td colspan="2">General</td> </tr> <tr> <td colspan="2">Note: The drawback to collecting REDUNDANT column stats is that they have to be loaded into the dictionary cache, and they have to be considered when the query is optimised. This waste shared pool space and CPU. On the other hand, if the statistics add value about the data - which does mean EVEN on unindexed columns - queries can run faster. Most systems should have only a few column histograms in place, but there is no obvious requirement that they should only be on indexed columns.</td> </tr> <tr> <td width="25%">Source</td> <td width="75%">{ORACLE_HOME}/rdbms/admin/prvtstas.pbl</td> </tr> <tr> <td width="25%">Constants</td> <td width="75%"> <DIV ALIGN="left"> <TABLE BORDER="1" CELLSPACING="0" WIDTH="100%"> <TR> <TD> Constant</TD> <TD align="center"> Data Type</TD> <TD> Usage</TD> </TR> <TR> <TD>AUTO_CASCADE </TD> <TD align="center"> BOOLEAN</TD> <TD>Whether to collect statistics for indexes or not</TD> </TR> <TR> <TD>AUTO_DEGREE</TD> <TD align="center"> NUMBER</TD> <TD>Select the degree of parallelism</TD> </TR> <TR> <TD>AUTO_INVALIDATE</TD> <TD align="center"> BOOLEAN</TD> <TD>Decide when to invalidate dependent cursors</TD> </TR> <TR> <TD>AUTO_SAMPLE_SIZE</TD> <TD align="center"> NUMBER</TD> <TD>Indicate that auto-sample size algorithms  should be used</TD> </TR> <TR> <TD>DEFAULT_DEGREE</TD> <TD align="center"> NUMBER</TD> <TD>Used to determine the system default degree  of parallelism</TD> </TR> </TABLE> </DIV> </td> </TR> <TR> <td width="25%">Data Types</td> <td width="75%">TYPE numarray IS VARRAY(256) OF NUMBER; TYPE datearray IS VARRAY(256) OF DATE; TYPE chararray IS VARRAY(256) OF VARCHAR2(4000); TYPE rawarray IS VARRAY(256) OF RAW(2000); TYPE fltarray IS VARRAY(256) OF BINARY_FLOAT; TYPE dblarray IS VARRAY(256) OF BINARY_DOUBLE; TYPE StatRec IS RECORD ( epc    NUMBER, minval RAW(2000), maxval RAW(2000), bkvals NUMARRAY, novals NUMARRAY); Types for listing stale tables include: TYPE ObjectElem IS RECORD ( ownname     VARCHAR2(30),  -- owner objtype     VARCHAR2(6),   -- 'TABLE' or 'INDEX' objname     VARCHAR2(30),  -- table/index partname    VARCHAR2(30),  -- partition subpartname VARCHAR2(30),  -- subpartition confidence  NUMBER);       -- not used TYPE ObjectTab IS TABLE OF ObjectElem; /</td> </TR> <TR> <td width="25%">Dependencies</td> <td width="75%">SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_STATS' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_STATS';</td> </TR> <TR> <td width="25%">Exceptions</td> <td width="75%"> <DIV ALIGN="left"> <TABLE BORDER="1" CELLSPACING="0" CELLPADDING="0" WIDTH="100%"> <TR> <TD ALIGN="center">Exception Name</TD> <TD ALIGN="center">Error Code</TD> <TD ALIGN="center">Reason</TD> </TR> <TR> <TD> </TD> <TD ALIGN="center">20000</TD> <TD> Table already exists or insufficient privileges</TD> </TR> <TR> <TD> </TD> <TD ALIGN="center">20001</TD> <TD> Tablespace does not exist</TD> </TR> <TR> <TD> </TD> <TD ALIGN="center">20002</TD> <TD>Bad user statistics table; may need to be upgraded</TD> </TR> <TR> <TD> </TD> <TD ALIGN="center">20003</TD> <TD>Unable to set system statistics</TD> </TR> <TR> <TD> </TD> <TD ALIGN="center"><font face="Cou