ITPub博客

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

This article is intended to introduce the enhancements to thenew partitioning method introduced in 9i, LIST Partitioning. [@more@]SCOPE & APPLICATION-------------------This article assumes the reader has an understanding of partitioning that was introduced in Oracle8 and Oracle8i.ORACLE9i LIST PARTITIONING--------------------------Oracle9i adds a new partitioning model called LIST partitioning to the set of partition methods already being supported in the Oracle RDBMS. List partitioning enab

有同事问我”BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0“这些是什么来的。我一查询如下：SQL> select owner,object_name,object_type from dba_objects where object_name like '%$Mp6ghZLX+d/gQAEKcwNPQA==$0%';OWNER------------------------------OBJECT_NAME--------------------------------------------------------------------------------OBJECT_TYPE-------------------BLACK_BERRY2BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0TABLE是表，属于BLACK_BERRY2这个用户，但执行查询抛异常：SQL> select * from BIN$Mp6ghZLX+d/gQAEKcwNPQA==$0;sel

Coming July 11, 2007 - Watch the Launch of Oracle Database 11g Live at 10 a.m. ETJoin us for a live Webcast of the launch of Oracle Database 11g. You'll learn how Oracle Database 11g will help you innovate faster through better business insight and improved information management. This is your opportunity to join leading industry experts from some of the most innovative companies and organizations of our time, including: James Burke, science historian, author, producer, and host of the BBC's acc

今天在data guard（standby）的物理主库上做switchover后想切回来，结果费了半天。认识到到几个盲点：1、log_archive_dest_n(n>1)中的service指的是备用库的网络服务器名称；2、db_name指的是唯一的数据库名称；db_unique_name、service_names和instance_name均指的是某个节点的数据库名称；3、oradim的时候加上-intpwd不然会抛“ora-01031: insufficient privileges "的异常；4、监听文件listener.ora中listener跟sid_list_listener是配对出现的，可配多个监听。[@more@]

怪现象之一：“天天涨停” 　6月，深圳楼价像深圳的天气一样火热。来自深圳有关部门的数据显示，深圳全市商品房成交均价为每平方米14223元，关内均价已过两万。深圳已经成为中国内地房价最高的城市。 怪现象之二：10人抢1套房很平常 　截止6月,深圳房价5个月内暴涨50%,问及深圳目前最低价的楼盘在哪里？深圳人几乎都能回答：“关外”。即使最低价之地，“最便宜”的房屋，也并不是有钱就能买得到的，10个购房者争抢同一套房屋很平常。 怪现象之三：“满城尽带楼市VIP” 　正因为10个购房者争抢同一套房屋已成为平常之事，开发商“创新性”

SwitchoverAllows the primary database to switch roles with one of its standby databases.There is no data loss during a switchover. After a switchover, each database continues to participate in the Data Guard configuration with its new role.[@more@]FailoverTransitions a standby database to the primary role in response to a primary database failure. If the primary database was not operating in either maximum protection mode or maximum availability mode before the failure, some data loss may occur.

在数据库的容灾方案中通常考虑data guard这一技术来实现应用系统的flexibility和usability。下面是我利用平时空闲时间在pc单机上配置oracle 10g的data guard物理备用数据库整个过程，供大家学习，也希望大家提出宝贵的建议给我。 [@more@]一、原理应该说物理备用数据库是主数据库的镜像，事务一致性副本。物理备用数据库通过应用主数据库的重做日志数据来跟主数据库保持同步。当主数据库发生事务变化时，oracle会将重做数据写入重做日志和归档日志中。后台进程MRP0定期将归档日志传送到物理备用数据库后物理备用数据库应用这些事务变化，从

告警日志中抛如下的异常：Mon Jun 25 13:36:06 2007ORA-1654: unable to extend index IMALLCSS.IDX_T_ACTIONLOG_USERID by 2048 in tablespace TS_IMALL Mon Jun 25 13:36:29 2007原因有二：[@more@]1、表空间TS_IMALL已满；2、用户IMALLCSS在表空间TS_IMALL上的quota不够。查询user_ts_quotas数据字典发现quota是unlimited的，如下：SQL> select * from user_ts_quotas;TABLESPACE_NAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS------------------------------ ---------- ---------- ---------- ----------TS_IMALL 1507328 -1 368 -1说明

现网一后台报表程序如今运行越来越慢，目前竟然需22个小时才能搞定！程序是外包的兄弟开发的，涉及到的性能问题最终找到了我！ [@more@]原来这个程序的运行机制其实很简单，从数据库中找到数据转换成.txt格式的文件输出，对应的数据库操作语句如下：SQL> select AcctId,2 SubsId,3 Acctstatus,4 to_char(OpenTime, 'YYYYMMDDHH24MISS'),5 1,6 QuotaOrder,7 to_char(ModifyTime, 'YYYYMMDDHH24MISS'),8 to_char(EXPIRTIME, 'YYYYMMDD'),9 nb,10 fb11 from (select a.AcctId,12 b.SubsId,13 a.Acctstatus,14 a.OpenTime,15 1,16 a.QuotaO

礼拜一参与了一项目的系统融合，迁移报表数据库成功。如下总结一下这一次的迁移过程。[@more@]两主机具有相同的平台，OS版本和patch。在目标主机上安装好oracle软件，这一步需保证具有相同的路径和文件目录名。将源主机上的oracle数据库shutdown后ftp所有的datafile,redo logfile,control file到目标主机上对应的目录下，然后将.bash_profile和.bashrc等环境变量文件也copy到目标主机上oracle用户的home目录下。紧接着就是重建密码文件；参照源主机oracle数据库上%ORACLE_HOME/network/admin下的transnames.ora，sql_net.ora和listener.or

自从沃尔玛和美国国防部要求供应商逐步采用RFID技术后，RFID技术骤然升温。Oracle，IBM，Royal Philips Electronics，SAP，Intel，Sun，Microsoft等众多软件开发商纷纷投巨资在这个领域，希望取得技术领先优势。事实上，IDC预测在这项技术上的支出将从现在的US$91.5 million到2008年的US$1.3 billion。看看该领域小公司的股票表现就知道这项技术的火热啦。那么什么是RFID技术呢？[@more@]Oracle为数据仓库管理软件增加射频识别功能(zt)　　近日，企业软件供应商甲骨文公司在美国总部宣布其最新版本的Oracle数据仓库管理软件(Oracle Wareho

by Daniel T. LiuIntroduction One of the biggest responsibilities for a database administrator is provide high availability and reduce unplanned downtime for a database. However, this has become a major challenge as our database size increased so dramatically over the years and our critical business information system requires 24x7 uptime. In an unplanned downtime when a terabyte database was corrupted, it may take hours, even days to restore such a database. To minimize downtime and avoid data l

一开发人员想实现利用表trigger往该表有条件地插入记录，即不满足条件的记录插入时通过trigger来拦截掉。找到了我帮忙是否可以实现，经深入分析后发觉根本无法实现这个功能。如下的试验可证明一切：[@more@]SQL> create table test_trigger 2 ( 3 name number(8) 4 );Table createdSQL> set serveroutput onSQL> CREATE OR REPLACE PROCEDURE proc_delete_test_trigger (p_name in varchar2) 2 IS 3 v_number number; 4 pragma autonomous_transaction; 5 BEGIN 6 7 begin 8 select count(*) into v_