...................._椒江育英中学吧_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：1,378贴子：
....................收藏
对不起，您申请 椒江育英中学 吧的吧主未能通过。亲爱的申请者：衷心感谢您申请吧主。我们一直认为，贴吧的建设需要吧主来引领，贴吧的人气需要吧主来聚拢，吧主是贴吧不可或缺的宝贵财富。我们相信，您对于如何组织大家建设贴吧已经有了一些想法。但由于对您的能力和潜力缺乏足够的了解，所以暂时没有批准您担任吧主。您的发贴情况和您的贴吧经历是我们了解您的重要依据。所以我们建议：申请吧主时，您在所申请贴吧已有一定的发贴记录，如果能提供您曾担任过的吧主/小吧主/小编职位，发起组织过的贴吧活动，或论坛BBS的经历，将有助于提高您的申请质量。以下情况可能影响您的申请，请您谅解1，申请未能得到现任全部吧主的同意；2，您使用多个ID担任同一个贴吧吧主；3，近期内在所申请贴吧有过撤职或辞职的记录；4，您所申请的贴吧主题涉及商业性质或可能用于商业用途；5，您申请吧主时所填写的个人信息不完善或不准确；6，其他百度公司认为不恰当的情况 如果有疑问，请到贴吧帮助吧发贴咨询，我们将详细解答，希望您顺利成为吧主！百度贴吧管理组上
1楼 10:44&|
。。。。。雕堡了
2楼 10:48&|来自
登录百度帐号我的游戏推荐游戏
后查看最近玩过的游戏
内&&容:使用签名档&&
想了解更多关于 ”椒江育英中学“的信息,请&或...................._百度知道
....................
我有更好的答案
怀化市区（鹤城区）位于湖南省西南部，雪峰山脉和武陵山脉之间。面积773平方公里，人口30.69万。人口密度为每平方公里397人。鹤城区地貌类型多样，以山地为主。地势由东南、西北向中部倾斜。东西部多山，中部为丘陵和溪谷平原。东南边界处的凉山海拔1174米，是市区最高点。主要河流有？水。属中亚热带季风湿润气候，年均气温16.55℃，降水量1563毫米，无霜期272天。主要农作物有水稻、玉米、小麦、豆类、油菜、花生等。林产品有杜仲、银杏、五倍子。矿产资源有煤、铁、铀、金、石灰石、硫、硅石20余种。主要工业产品有针织品、原煤、水泥、铝锭等。全区商贸发达，是湖南西部最大的物资集散中心。交通便利，湘黔铁路、焦柳铁路、320国道、209国道交会于此。
哥仨第三个归属地归属地
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁1737人阅读
转载请注明出处:
正确答案:D
Oracle 11g新特性之统计信息收集
&& 在以前的数据库版本中，当收集到新的优化器统计信息时会自动发布。在11g中，这仍然是默认的动作，但你多了一个选择，
你可以将最新的统计信息挂起，直到人为地发布它们。DBMS_STATS.GET_PREFS函数运行你检查“PUBLISH”属性，查看统计信息
是否已经自动发布。默认返回的值为TRUE，意味着已经自动发布了，而FALSE表示它还处于挂起状态，等待发布。
& 检查当前数据库的PUBLISH”属性:
gyj@OCM& col get_prefs for a50
gyj@OCM& SELECT DBMS_STATS.get_prefs('PUBLISH','SH','CUSTOMERS') get_prefs FROM
--------------------------------------------------
使用存储过程DBMS_STATS.SET_TABLE_PREFS可以重新设置“PUBLISH”属性,设为FALSE表示它还处于挂起状态，等待发布:
gyj@OCM& BEGIN
DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
PL/SQL procedure successfully completed.
gyj@OCM& SELECT DBMS_STATS.get_prefs('PUBLISH','SH','CUSTOMERS') get_prefs FROM
--------------------------------------------------
参考官方文档:
SET_TABLE_PREFS Procedure
This procedure isused to set the statistics preferences of the specified table in the specifiedschema.
DBMS_STATS.SET_TABLE_PREFS (
&&& ownname&&& IN& VARCHAR2,
&&& tabname&&& IN& VARCHAR2,
&&& pname&&&&& IN& VARCHAR2,
& &&pvalue&&&& IN& VARCHAR2);
Parameters
Table 141-93SET_TABLE_PREFS Procedure Parameters
Description
Owner name
Table name
Preference name. The default value for following preferences can be set:
·&&&&&&&& CASCADE
·&&&&&&&& DEGREE
·&&&&&&&& ESTIMATE_PERCENT
·&&&&&&&& METHOD_OPT
·&&&&&&&& NO_INVALIDATE
·&&&&&&&& GRANULARITY
·&&&&&&&& PUBLISH
·&&&&&&&& INCREMENTAL
·&&&&&&&& STALE_PERCENT
CASCADE&- Determines whether or not index statistics are collected as part of gathering table statistics.
DEGREE&- Determines degree of parallelism used for gathering statistics.
ESTIMATE_PERCENT&- Determines the percentage of rows to estimate. The valid range is [0.]. Use the constantDBMS_STATS.AUTO_SAMPLE_SIZE&to have Oracle determine the appropriate sample size for good statistics.
This is the default.
METHOD_OPT&- Controls column statistics collection and histogram creation. It accepts either of the following options, or both in combination:
·&&&&&&&& FOR ALL [INDEXED | HIDDEN] COLUMNS&[size_clause]
·&&&&&&&& FOR COLUMNS [size clause] column [size_clause] [,column [size_clause]...]
size_clause&is defined as&size_clause := SIZE {integer | REPEAT | AUTO | SKEWONLY}
column&is defined as&column := column_name | extension name | extension
- integer&: Number of histogram buckets. Must be in the range [1,254].
- REPEAT&: Collects histograms only on the columns that already have histograms
- AUTO&: Oracle determines the columns to collect histograms based on data distribution and the workload of the columns.
- SKEWONLY&: Oracle determines the columns to collect histograms based on the data distribution of the columns.
-&column_name&: Name of a column
-&extension :&Can be either a column group in the format of&(column_name, colume_name [, ...])&or an expression
The default is&FOR ALL COLUMNS SIZE AUTO.
NO_INVALIDATE&- The value controls the invalidation of dependent cursors of the tables for which statistics are being gathered. Does not invalidate the dependent cursors if set to&TRUE. The procedure invalidates the dependent cursors
immediately if set to&FALSE. Use&DBMS_STATS.AUTO_INVALIDATE&to have Oracle decide when to invalidate dependent cursors. This is the default.
GRANULARITY&- Determines granularity of statistics to collect (only pertinent if the table is partitioned).
'ALL'&- Gathers all (subpartition, partition, and global) statistics
'AUTO'- Determines the granularity based on the partitioning type. This is the default value.
'DEFAULT'&- Gathers global and partition-level statistics. This option is obsolete, and while currently supported, it is included in the documentation for legacy reasons only. You should use the 'GLOBAL AND PARTITION' for this functionality.
Note that the default value is now 'AUTO'.
'GLOBAL'&- Gathers global statistics
'GLOBAL AND PARTITION' - Gathers the global and partition level statistics. No subpartition level statistics are gathered even if it is a composite partitioned object.
'PARTITION&'- Gathers partition-level statistics
'SUBPARTITION'&- Gathers subpartition-level statistics.
PUBLISH&- Determines whether or not newly gathered statistics will be published once the gather job has completed. Prior to Oracle Database 11g, Release 1 (11.1), once a statistic gathering job completed the new statistics were automatically
published into the dictionary tables. The user now has the ability to gather statistics but not publish them immediately. This allows the DBA to test the new statistics before publishing them.
INCREMENTAL&- Determines whether or not the global statistics of a partitioned table will be maintained without doing a full table scan. With partitioned tables it is very common to load new data into a new partition. As new partitions are added
and data loaded, the global table statistics need to be kept up to date. Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:
·&&&&&&&& INCREMENTAL&value for the partitioned table is set to&TRUE;
·&&&&&&&& PUBLISH&value for the partitioned table is set to&TRUE;
·&&&&&&&& User specifies&AUTO_SAMPLE_SIZE&for&ESTIMATE_PERCENT&and&AUTO&for&GRANULARITY&when gathering statistics on the table.
If the&INCREMENTAL&value for the partitioned table was set to&FALSE&(default value), a full table scan is used to maintain the global statistics which is a much more resource intensive and time-consuming operation for large tables.
STALE_PERCENT&- Determines the percentage of rows in a table that have to change before the statistics on that table are deemed stale and should be regathered. The default value is 10%.
Preference value. If&NULL&is specified, it will set the Oracle default value.
Exceptions
: Object doesnot exist or insufficient privileges
: Invalid orillegal input values
Usage Notes
·&&&&&&&&To run this procedure, you need to connect as owner of the tableor should have the&ANALYZE&ANY&systemprivilege.
·&&&&&&&&All arguments are of type&VARCHAR2&and values are enclosed in quotes, even when they representnumbers.
DBMS_STATS.SET_TABLE_PREFS('SH', 'SALES', 'CASCADE', 'DBMS_STATS.AUTO_CASCADE');
DBMS_STATS.SET_TABLE_PREFS('SH', 'SALES','ESTIMATE_PERCENT','9');
DBMS_STATS.SET_TABLE_PREFS('SH', 'SALES', 'DEGREE','99');
&QQ：技术交流QQ群：
DSI&Core Search &Ⅰ 群：（2000人技术群:未满）
DSI&Core Search &Ⅱ 群：（1000人技术群:未满）
DSI&Core Search &Ⅲ 群：（500人技术群:未满）
DSI&Core Search &Ⅳ 群：（500人技术群:未满）
DSI&Core Search &Ⅴ 群：（500人闲聊群:未满）
MAIL：dbathink@BLOG：&WEIBO：ITPUB：&OCM： &&
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：286093次
积分：5869
积分：5869
排名：第1358名
原创：241篇
转载：15篇
译文：10篇
评论：91条
OCP认证群：
OCM认证群：
SQL优化群：
JAVA实战群：
Hadoop群：
技术分享群：
文章：97篇
阅读：107427
(2)(1)(1)(2)(2)(10)(6)(1)(1)(5)(5)(1)(3)(24)(30)(31)(23)(5)(5)(10)(20)(78)