ITPub博客

2008 Beijing Summer Games Just One Year Away.I'm looking forwards to this day be coming!next year my child has half a year old!happy this day of next year to everybody![@more@]

A temporary tablespace group can be thought of as a shortcut for a list of temporary tablespaces.A temporary tablespace group consists of only temporary tablespaces.A temporary tablespace group has the following properties:[@more@]?It contains at least one temporary tablespace. There is no explicit limit on how many tablespaces are contained in a group.?It has the same namespace as tablespaces. It is not possible for a tablespace and a temporary tablespace group to have the same name.?A temporar

When the Oracle database stores data in a heap-organized table, the rows are not stored in a usercontrolled order. Rather, the decision about where to place a row is dependent on storage heuristics. The Oracle database does not guarantee the return order of the rows unless the queryincludes an ORDER BY clause.[@more@]Inside a sorted hash cluster, the rows are organized in lists of sorted rows. Each list corresponds to a particular value of the hash key columns defined by the corresponding sorted

1.建表,列servkeys将用到全文检索.create table SERVICEKEY(SERVCODE VARCHAR2(12) not null,,SERVKEYS VARCHAR2(2048) not null);2. 创建中文语义的定义beginctx_ddl.create_preference('chinese_lexer','CHINESE_VGRAM_LEXER');end;/ [@more@]3. 创建中文语义的索引create index idx_ctx_servkey on servicekey(servkeys) indextype is ctxsys.contextparameters('lexer chinese_lexer');4.全文检索中用于定时更新DR$idx_ctx_servkey$I、DR$idx_ctx_servkey$K、DR$idx_ctx_servkey$R和DR$idx_ctx_servkey$N表中的记录，重建索引create o

This note assumes the Oracle software is installed into the $ORACLE_HOME.On Unix, the environment variable LD_LIBRARY_PATH must be set to$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib[@more@]Installation script should look as follows :============================================Note: In SQL*Plus we use '?' instead of $ORACLE_HOME ------------------- cut here ------------------------------connect SYS/password as SYSDBAset echo oncol comp_name for a30spool textinstall.logRem ===============================

The concept of a service was first introduced in Oracle8i as a means for the listener to perform connection load balancing between nodes and instances of a cluster. However, the concept,definition, and mplementation of services have been dramatically expanded. Services are a feature for workload management that organize the universe of work execution within the database to make that work more manageable, measurable, tunable, and recoverable. A service is a grouping of related tasks within the da

所谓401K养老计划，是指根据1978年美国国内税法401K条款的规定所确立的一种雇主发起养老计划，该条款为雇主和雇员的养老金存款提供了税收方面的优惠，按该计划，企业为员工设立专门的401K账户，员工每月从其工资中拿出一定比例的资金存入养老金账户，而企业一般也为员工缴纳一定比例的费用。员工自主选择证券组合进行投资，收益计入个人账户。[@more@]

Recently,a 10g database occured lots of alerts about ORA-03135 & ORA-3136,as follows:Tue Jul 31 10:30:29 2007WARNING: inbound connection timed out (ORA-3136)Tue Jul 31 10:30:29 2007WARNING: inbound connection timed out (ORA-3136)Tue Jul 31 10:30:54 2007WARNING: inbound connection timed out (ORA-3136)Tue Jul 31 10:30:54 2007WARNING: inbound connection timed out (ORA-3136)Tue Jul 31 10:30:55 2007WARNING: inbound connection timed out (ORA-3136)Tue Jul 31 10:30:55 2007WARNING: inbound connection

一现网数据库cpu经常告警，从statspack报告中可以看到如下的语句消耗了大量的IO和CPU资源：SELECT NVL(MAX(MENUSEQ),0) FROM MENU WHERE PORTALTYPEID = 4 AND PARENTMENUID = :B1;初一看，这个查询语句明显应该是应用所发出的，不应该是后台程序，因为后台程序的话需有into variable才行。[@more@]查询后台程序的脚本，发现语句“select nvl(max(menuseq),0) into v_maxmenuseq from menu where portaltypeid = 4 and parentmenuid = v_parentmenuid;”确实存在，莫非statspack中的语句就是这个语句？难道PL/SQL中的into variable不会体现

一同事在公司的bbs技术栏里发布一帖子，请教如下的问题：在Pro*C中使用Merge语句，来代替原来的Update or Insert语句，在预编译时，总是报错。代码如下：EXEC SQL MERGE INTO tab1 a USING (select * from tab2 where tab2.col1=:parameter1 and tab2.col2=:parameter2) bON (a.col1 = b.col1 AND a.col2 = b.col2)WHEN MATCHED THEN UPDATE SET a.col3 = :parameter3WHEN NOT MATCHED THEN INSERT VALUES (b.col1, b.col2, b.col3);所使用的预编译器是:Pro*C/C++: Release 9.2.0.4.0[@more@]异常信息如下：PCC-S-02201, Encountered the

最近在查看一数据库主机的性能时意外发现一个进程占用的系统资源特别高，并且持续占用着。Load averages: 2.02, 1.87, 2.09 538 processes: 530 sleeping, 8 running Cpu states:CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS 0 1.83 54.0% 0.0% 7.1% 38.9% 0.0% 0.0% 0.0% 0.0% 1 2.21 35.4% 0.0% 7.5% 57.1% 0.0% 0.0% 0.0% 0.0%--- ---- ----- ----- ----- ----- ----- ----- ----- -----avg 2.02 44.7% 0.0% 7.3% 48

The ASH contains recent information on active sessions sampled every second. The AWR takes snapshots of the database every hour, so the information in the AWR could be almost an hour old and will not help in diagnosing issues that are current on the database. [@more@]Typically, to resolve issues currently on the database, detailed information pertaining to the last 5 or 10 minutes is critical. Because recording session activity is expensive, ASH samples V$SESSION every second and records the eve

上周对first_rows和rownum<2做了测试，见如下的结果。从结果可以看出相应的差距。分有索引和无索引两种情况，每种情况下有7种写法。 [@more@]SQL> desc tempName Type Nullable Default Comments -------------- ------------- -------- ------- -------- ID NUMBER(15) REQUESTID VARCHAR2(20) Y MESSAGETYPE VARCHAR2(1) REQUESTTIME DATE Y HREF VARCHAR2(250) Y SENDER VARCHAR2(20) Y RECEIVER VARCHAR2(15) MESSAGECONTENT VARCHAR2(500) Y MESSAGESUBJECT VARCHAR2(200) Y SENDHOSTIP VARCHAR2(20) REQUESTIP VARCHAR2(15) Y

there are 2,000 words which are often used,as follows:[@more@]1 the2 be3 of4 and5 a6 to7 in8 he9 have10 it11 that12 for13 they14 I15 with16 as17 not18 on19 she20 at21 by22 this23 we24 you25 do26 but27 from28 or29 which30 one31 would32 all33 will34 there35 say36 who37 make38 when39 can40 more41 if42 no43 man44 out45 other46 so47 what48 time49 up50 go51 about52 than53 into54 could55 state56 only57 new58 year59 some60 take61 come62 these63 know64 see65 use66 get67 like68 then69 first70 any71 work72

1、科学地洗脸 洗脸的目的在于保持皮肤清洁。皮肤上的许多组织如皮脂腺、汗腺、角质等都会因新陈代谢而容易产生污垢，如果放任不管，则会引起皮脂酸化及毛细孔堵塞，导致接触性皮肤炎，甚至是敏感性皮肤病。所以，正确的洗脸方法是尤为重要的。[@more@] 每天清晨起床后和下班回家后，是两个洁面的最佳时间。特别是对于经常化妆的OL们，更需要将带妆时间降至最低，因此最好一进家门就洗掉脸上的污垢与彩妆。 洁面的水温以30℃左右为宜。不可用太热的水，因为热气吸收了肌肤内过多的油脂，更容易令肌肤干燥，破坏了原有的弹

　　辛辛苦苦挣来的工资躺在活期存款这张温床上睡大觉，不妨盘活手中的工资卡，用活转定来为自己敛财聚富，填补一下活期利率损失。 [@more@]　　目前很多银行都推出活转定功能，对于月收入稳定但又没时间打理工资卡内资产的工薪层来说，能有两种选择，一种是工资卡里的活期存款转定期存款，一种是转定投基金。每个月不取钱的人通过这些方法都可以让“钱生钱”。 　　活期存款转定期存款，就是当银行内活期存款超过一定金额以后，卡内活期存款会在每月固定时间或达到约定金额后转为卡内定期存款（卡内划转），以实现存款收益最大化。这样一

Three index types are supported in the two groups mentioned above:- Local prefixed.- Local non prefixed.- Global prefixed.Prefixed vs. Non prefixed; what is the difference?[@more@]An index is considered prefixed if its partitioning key/keys constitute the left part of the index key, columns being kept in the same order.Non prefixed global indexes are not supported.Non-partitioned indexes are considered to be global prefixed indexes.We will use the following base table for the examples of each ty

?/rdbms/admin/sprepsql.sql An SQL report can be executed on one SQL statement, searching for a bottleneck, where the hash value for the SQL code statement is found in the STATSPACK instance report.[@more@]From Oracle9i onwards, oracle stores the execution plan of each of the child cursor loaded in the library cache. The view v$sql_plan can be queried to retrieve this information. In addition an enhancement was made to the Oracle9istatspack report to capture the sql plans. Capturing a snapshot at

表结构如下：SQL> desc msg_request_historyName Type Nullable Default Comments ---------- ------------ -------- ------- -------- MSGTYPE NUMBER(8) 0 MSGKEY VARCHAR2(50) MSGDATE DATE Y SYSDATE STATUS NUMBER(2) Y 0 按msgdate按天来分区。SQL> set autotrace traceonly;SQL>SQL> select count(*) from msg_request_history2 where trunc(MSGDATE)= trunc(to_date('20070719','yyyy-mm-dd'))3 and MSGKEY='11175998';[@more@]执行计划----------------------------------------------------------0 SELECT STATEMEN

You can partition a non-partitioned table three different ways:A) export/import methodB) Insert with a subquery method C) Partition exchange methodEither of these 3 methods will create a partitioned table from an existing non-partitioned table.[@more@]You can partition a non-partitioned table three different ways:A) export/import methodB) Insert with a subquery method C) Partition exchange methodEither of these 3 methods will create a partitioned table from an existing non-partitioned tabl