ITPub博客

Export: Release 9.2.0.1.0 - Production on 星期四 10月 11 11:01:11 2007Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.连接到: Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - Production已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集[@more@]. 正在导出 pre-schema 过程对象和操作EXP-00008: 遇到 ORACLE 错误 4068ORA-04068: existing state of packages has been discardedORA-04063: package bod

1. There are some good reasons for... There are two reasons for the improvement in people's living conditions. In the first place, we have been carrying out the reform and opening-up policy. Secondly, there has been a rapid expansion of our national economy. Furthermore, the birth rate has been put under control. [@more@]2. My suggestions to deal with the problem are as follows. In the first place, ... Secondly, ... Finally, ... My suggestions to deal with the problem are as follows. In the firs

OTC是英文Over The Counter的缩写，在医药行业术语中特指非处方药。我国卫生部医政局对非处方药是这样定义的：OTC是消费者可不经过医生处方，直接从药房或药店购买的药品，而且是不在医疗专业人员的指导下就能安全使用的药品。非处方药的主要类别：饮食补充剂（包括维生素、矿物质）、皮肤用药（包括皮肤保健品）、感冒咳嗽药、止痛药、胃肠病药。[@more@]

　　从前，有位乡下青年，读了点书，嫌乡村的生活单调，决定要去城里闯世界。临走时，他向村中的村长请教，村长给了他三个字的忠告：“不要怕”。并讲好等他回来时还有另三个字相赠。三十年后，饱经风霜的青年带着满头白发决定还是回乡村生活。回来时，得知当年的村长已死，心中怅然若失，不知村长另外要赠的三字是什么？村长的儿子转交给他一个信封，说是长者临死前嘱咐交给他的。信只有三个字：“不要悔”。[@more@]　　赌博的故事　　这是则老故事。中国以前流行赌骨牌。骨牌共有 36 个数字，从 1 到 36。赌客任押其中一个数字，庄家开

公司测试部一数据库无法正常启动，找到了我帮忙解决！具体故障现象如下：SQL> startupORACLE instance started.Total System Global Area 353857616 bytesFixed Size 737360 bytesVariable Size 318767104 bytesDatabase Buffers 33554432 bytesRedo Buffers 798720 bytesDatabase mounted.ORA-00368: checksum error in redo log blockORA-00353: log corruption near block 74032 change 1121332681927 time 09/25/200710:47:51ORA-00312: online log 3 thread 1: '/oracle/oradata/ora9i/redo03.log'[@more@]提示在线日志文件遭到了

昨天在建一分区表时抛了异常“ORA-14039: 分区列必须构成 UNIQUE 索引的关键字列子集”，具体过程如下：[@more@]SQL> begin2 execute immediate3 'create table MSG_STORAGE_CACHE4 (5 NAME VARCHAR2(64) not null,6 HASHKEY VARCHAR2(100) not null,7 PACKAGE VARCHAR2(3000) not null,8 CREATEDATE DATE default SYSDATE9 )10 partition by range(CREATEDATE)11 (12 partition p_'||to_char(sysdate-6,'yyyymmdd')||' values less than(to_date('''||to_char(sysdate-5,'yyyymmdd')||''',''yyyymmdd'')),13 partition p_'||to_char(s

同事反映应用中获取到的sequence的nextval值存在问题，从获取时间上来看不是递增的。一表中列SN的取值来源于序列TB_C_DATA_ALTER_LOG_SEQ，14：50插数据时SN为4081，而15：11插数据时SN反而变小了，为4062。经分析得知该序列采用了cache 20的默认选项。[@more@] 单实例的数据库倒不存在这个问题，RAC中就会出现先取的值不一定是小的，后取的值不一定会大的问题。具体原因是由于rac两节点中若序列的cache为20的话，在节点一上cache了1－20个，然后节点二上cache了20－40。当从不同的节点来进行对sequence取值的时候，会

[root@PORTAL3115 root]# export DISPLAY=10.1.19.134:0[root@PORTAL3115 root]# xterm[root@PORTAL3115 root]# gnome-session&[@more@]_

expense.current expenses、selling expenses、travelling expensesadmission.admission by ticket onlycharge.what are the charges in the hotel?cost.The cost of seeing a movie is seven dollars.fare.All fares,please.[@more@]

性能测试时发现阻塞在数据库端，测试人员找到了我。通过查询v$session_wait后发现基本上是datafile和redo文件的读写等待事件。监控时发现主机的cpu和内存还正常，loadrunner压力时发现入库操作（往表插数据阻塞）一直影响其他进程，对数据库作了statspack后发现往一张表中插入数据消耗了大量的buffer get。查看该表的存储参数后发现INITIAL_EXTENT为64K，NEXT_EXTENT为空，该表对应的表空间的ALLOCATION_TYPE为UNIFORM。在这种情况下表数据扩张时每次申请新的extent的大小为64k。由于是非常频繁插入数据，显然每次扩张64K的大小太小了，导

最近在浏览一项目的第三方软硬件汇总表时，看到了oracle数据库的报价如下：产品名称版本使用权类型用户数发货数量使用权单价使用权费用Oracle 9i enterprise edition9iFU4001￥9,932.00￥3,972,800.00Partitioning9iFU4001￥2,483.00￥993,200.00Performance Tuning Pack9iFU4001￥745.00￥298,000.00Diagnostic Pack9iFU4001￥745.00￥298,000.00Change Management Pack9iFU4001￥745.00￥298,000.001.4 数据库的售后服务　　　　　　数量产品说明单价小计1Oracle基本技术支持服务/年(系统列表价22%):￥1,289,200.00￥1,289,200.00　　　

Oracle Management Service (OMS)Oracle HTTP Server (OHS)Oracle Application Server Containers for J2EE (OC4J)Enterprise Manager (EM)Distributed Configuration Management Control (dcmctl)Oracle Process Management Notification Control (opmnctl).Oracle Management Repository (OMR)Database Configuration Assistant (DBCA)[@more@]Automatic Storage Management (ASM)Oracle HTTP Server (OHS)Distributed Configuration Management Control (dcmctl)Oracle Process Management Notification Control (opmnctl)High-water m

Base statistics represent the raw data collected. For example, counting the number of physical reads in the system since startup is a base statistic.Metrics are secondary statistics derived from base statistics. Most metrics track the rates of change of activities in the Oracle database. For example, the average physical reads in the system in the last 60 minutes is a metric. Metrics are used by internal client components forsystem health monitoring, problem detection, and self-tuning.[@more@]Fo

This component is the central element of the new manageability infrastructure. It provides services to internal Oracle server components to collect, process, maintain, and access performance statistics for problem detection and self-tuning purposes.[@more@]AWR is the infrastructure that provides services to Oracle Database 10g components to collect,maintain, and utilize statistics for problem detection and self-tuning purposes.The AWR infrastructure consists of two major parts:An in-memory stati

今日，参加了一心理测试（MBTI职业性格测试），如下是我的测试结果。[@more@]Psytopic分析：您的性格类型是“ISTJ”(内向+实感+思维+判断) 沉静，认真；贯彻始终、得人信赖而取得成功。讲求实际，注重事实和有责任感。能够合情合理地去决定应做的事情，而且坚定不移地把它完成，不会因外界事物而分散精神。以做事有次序、有条理为乐---不论在工作上， 家庭上或者生活上。重视传统和忠诚。 ISTJ型的人是严肃的、有责任心的和通情达理的社会坚定分子。他们值得信赖，他们重视承诺，对他们来说，言语就是庄严的宣誓。 ISTJ型的人工作缜密，讲

第一步、创建directory，给用户授权，并创建sqlldr导入的目标表结构$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.6.0 - Production on Fri Aug 17 15:17:58 2007Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - Production[@more@]SQL> create directory external_table_dir as '/oracle/sqlldr/';Directory created.SQL&gt

The Grid Control framework includes the underlying component pieces that provide the ability to centrally manage your computing environment. These component pieces include: Oracle Management Repository (OMR) One or more Oracle Management Services (OMSs) One or more Oracle Management Agents (OMAs) This framework can be on a single server or distributed across multiple servers depending on the needs of the business and the size of the enterprise being managed. [@more@]Grid Control manages all curr

Recently,I saw one of my colleagues operating data in the product database.when he query data he used the statement of "select **** from A for update" in the SQL window of the PL/SQL developer tool.we knowed that the FOR UPDATE would make the table A be locked,therefore this will result in other operations crash for waiting all the time!As we know,the clause of For UPDATE would bring a row lock for the table,so just cautiously used "FOR UPDATE" especially in the product d

Have you ever seen a lone writer typing his novel on his laptop in Starbucks to avoid his nagging wife? Have you seen a young woman indulging herself in karaoke at holidays, just to release her pent-up feelings after breaking up with her boyfriend? [@more@]To the writer and the young woman, Starbucks and karaoke are their dream places.For me, it is the church that is my dream place. But don't just assume I'm Catholic.I still remember the first time I discovered a cathedral on Sheshan Mountain on

It is often useful to dump the internal contents of Oracle internal structures such as the control files, library cache, and redo log headers. The following undocumented Oracle commands can be used for this purpose.For each of these commands, a trace file will be generated in your UDUMP directory. After issuing the command, you can go to your UDUMP directory to view the contents of the dump.[@more@]1 – SCN Dump - This command dumps the control file contents to see SCN information. The SCN inf