01月 « 2009 « huojia

昨晚去看了2009年第一部上映的“大片” 《赤壁下》。一个字评价，2；两个字评价，可笑；三个字评价，没文化。看《赤壁上》，我经常被里面的对话搞的哈哈大笑。从来没看过三国，本想借着看电影这样一种简单，方便的方式补充一下历史文化常识，有可能也提高一下自己的欣赏水平。无奈，吴宇森同学就是不想让俺梦想成真。看赤壁的前三个半小时，是我出现在地球上28年来在电影院里度过的最黑暗的时间，片儿烂，烂到了无极限，难道这就是传说中的用无声的暴力无情的摧残？到还有一个半小时的时候，我突然明白了。是我没文化，是我可笑，是我2，吴导拍的是喜剧片+动画片。听着赵薇和佟大为的对话，想不乐，行么？再看火烧赤壁那段，要说还得感谢计算机技术，这么大个场面，喀嚓几下就在电脑上给做好了。科学技术是第一生产力啊，我刚明白，吴导在教书育人呐。不过能把历史给艺术展现成这样，是不是太对不起老祖宗了？这算不算拿无知当个性？扭曲历史也就算了，为了给每个大腕分戏份，拼命的改戏，死活没看出来林志玲在这片儿里面干啥了，原来如果是个花瓶，现在就算是个花瓶底儿了。本山大叔说了，悲哀，真的是悲哀！

Posted in 闲言碎语 | No Comments »

程砚秋论读书

星期三, 01月 7th, 2009

在郭宁（新东方教师，IBM CDL ECM 2007年兼职英文口语老师，一个风趣幽默，发音很棒的小老弟）博客看到。

读书能知天地之大，能晓人生之难，也能让人有自知之明，有预料之先，不为苦而悲，不受宠而欢，弃浮华，潇洒达观，于嚣烦尘世而自尊自重，自强自立，不卑不俗……

Posted in 心灵鸡骨 | No Comments »

使用 Statspack 实践

星期三, 01月 7th, 2009

今天分析一个text search问题时候，使用了Statspack工具，做一个记录。实践中，参考了 Eygle 网站上的Statspack专题和 Oracle9i Database Performance Tuning Guide and Reference 的 C21-Using Statspack

安装Statspack
创建Statspack使用的表空间

C:\oracle\ora10g\RDBMS\ADMIN>sqlplus sys/fvt6eip as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jan 8 01:36:24 2009
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create tablespace perfstat datafile 'c:\oracle\oradata\perfstat.dbf'
size 500M extent management local;
Tablespace created.

安装Statspack:执行前，确认Temp Database的名字，本例使用temp.

SQL> @spcreate.sql
Choose the PERFSTAT user's password
-----------------------------------
Not specifying a password will result in the installation FAILING
Enter value for perfstat_password: fvt6eip
fvt6eip
Choose the Default tablespace for the PERFSTAT user
---------------------------------------------------
Below is the list of online tablespaces in this database which can
store user data.  Specifying the SYSTEM tablespace for the user's
default tablespace will result in the installation FAILING, as
using SYSTEM for performance data is not supported.
Choose the PERFSTAT users's default tablespace.  This is the tablespace
in which the STATSPACK tables and indexes will be created.
TABLESPACE_NAME                CONTENTS  STATSPACK DEFAULT TABLESPACE
------------------------------ --------- ----------------------------
ICMLFQ32                       PERMANENT
ICMLNF32                       PERMANENT
ICMLSNDX                       PERMANENT
ICMLSTXT                       PERMANENT
ICMSFQ04                       PERMANENT
ICMVFQ04                       PERMANENT
PERFSTAT                       PERMANENT
SYSAUX                         PERMANENT *
Pressing  will result in STATSPACK's recommended default
tablespace (identified by *) being used.
Enter value for default_tablespace: perfstat
Using tablespace PERFSTAT as PERFSTAT default tablespace.
Choose the Temporary tablespace for the PERFSTAT user
-----------------------------------------------------
Below is the list of online tablespaces in this database which can
store temporary data (e.g. for sort workareas).  Specifying the SYSTEM
tablespace for the user's temporary tablespace will result in the
installation FAILING, as using SYSTEM for workareas is not supported.
Choose the PERFSTAT user's Temporary tablespace.
TABLESPACE_NAME                CONTENTS  DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP                           TEMPORARY *
Pressing  will result in the database's default Temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace: temp
Using tablespace temp as PERFSTAT temporary tablespace.
...........
...........
Creating Package STATSPACK...
Package created.
No errors.
Creating Package Body STATSPACK...
Package body created.
No errors.
NOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.

抓取Statspack Snapshot

SQL> execute statspack.snap
PL/SQL procedure successfully completed.

确认抓取Snapshot步骤成功

SQL> select snap_id from stats$snapshot;
SNAP_ID
----------
1
1 row selected.

生成Statsnap 报告:至少有两次的Snapshot 才能生成报告, 输入相同的snapshotid 会导致ORA-20200: End Snapshot Id 1 must be greater than Begin Snapshot Id 1。
生成第二个snapshot

SQL> execute statspack.snap
PL/SQL procedure successfully completed.

产生报告@spreport.sql ,出入开始的snapsshot和结束的snapshot，以及report名称即可

通过@spauto.sql 可以配置Oracle Job来周期性收集snapshot 供分析所有。使用exp/imp工具可以导入和导出 statspack的数据。这些可以在以上的参考文档中找到详细步骤，不赘述。

Posted in oracle | No Comments »

2008 年看过的书

星期二, 01月 6th, 2009

用刀马的程序，自动统计2008年读过的书。
08年读书除《沉思录》看不懂外，其他的都挺好看。Keep Reading Gives Power!

# 野蛮生长(一部民营企业和创业人生的心灵史，一位商界哲人的人生感悟！)
# 沉思录（总理天天在读的书）半本
# 激荡三十年–中国企业(下)
# 人性的弱点全集(套装共两册)
# 杜拉拉升职记
# 货币战争
# 大败局II

#深入浅出Oracle
#循序渐进Oracle-数据库管理、优化与备份恢复
#Oracle Database 10g OCP Certification All-In-One Exam Guide
#DB2 SQL PL, Second Edition: Deployment and Advanced Configuration Essential Guide for DB2 UDB [Chapter 1-8]
#Head First 设计模式前5章

# 病者生存
# 病由心生–７６％的疾病都是情绪性疾病（美国畅销６０多年，再版３０多次）
# 藏地密码
# 明朝那些事儿 08年
# 荣宝斋
# 国画
# 北京诱惑
# 未央歌
# 福尔摩斯全集
# 奋斗

Posted in 心灵鸡骨 | No Comments »

Initialization Parameters Deprecated&Obsolete in Oracle Database 11g Release 1 (11.1)

星期二, 01月 6th, 2009

Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1)

The following initialization parameters were deprecated in Oracle Database 11g Release 1 (11.1). To get a list of all deprecated initialization parameters, issue the following SQL statement:

SQL> SELECT name FROM v$parameter
         WHERE isdeprecated = 'TRUE';

A deprecated parameter behaves the same way as a regular parameter, except that a warning message is displayed at instance startup if a deprecated parameter is specified in the parameter file. In addition, all deprecated parameters are logged to the alert log at instance startup.
BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
COMMIT_WRITE
CURSOR_SPACE_FOR_TIME
INSTANCE_GROUPS
LOG_ARCHIVE_LOCAL_FIRST
PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
PLSQL_V2_COMPATIBILITY
REMOTE_OS_AUTHENT
RESOURCE_MANAGER_CPU_ALLOCATION
STANDBY_ARCHIVE_DEST
TRANSACTION_LAG attribute (of the CQ_NOTIFICATION$_REG_INFO object)
USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)

Initialization Parameters Obsolete in Oracle Database 11g Release 1 (11.1)

The following initialization parameters were made obsolete in Oracle Database 11g Release 1 (11.1).

Note:

An attempt to start a database using one or more obsolete initialization parameters will succeed, but a warning is returned and recorded in the alert log.

DDL_WAIT_FOR_LOCKS
LOGMNR_MAX_PERSISTENT_SESSIONS
PLSQL_COMPILER_FLAGS

Posted in 闲言碎语 | No Comments »

Oracle 11g-ORA-32004:obsolete and/or deprecated parameter(s) specified

星期二, 01月 6th, 2009

SQL> alter system set remote_os_authent = true scope=spfile;


System altered.

SQL> startup force ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.

Solution

To remove the deprecated parameter from the spfile issue:

alter system reset remote_os_authent scope=spfile;

Posted in oracle | No Comments »

Oracle 11g 新特性学习 – Oracel Trace File Location – Automatic Diagnostic Repository

星期二, 01月 6th, 2009

Oracle 11g 使用了Automatic Diagnostic Repository (ADR)来存储所有的诊断日志信息(trace, alert logs). ADR Base(adr_base)的位置通过参数 “diagnostic_dest” 控制. 参数 background_dump_dest, core_dump_dest, user_dump_dest (in previous releases) 被 deprecate 并被一个单独的参数 “diagnostic_dest” 所取代.

如果强制使用user_dump_dest , backgroud_dump_dest,coreate_dump_dest，在 C:\app\Administrator\admin\icmnlsdb\bdump\alter.log 会看到如下警告信息

Dump file c:\app\administrator\admin\icmnlsdb\bdump\alert_icmnlsdb.log

Tue Jan 06 10:58:52 2009

ORACLE V11.1.0.6.0 – Production vsnsta=0

vsnsql=15 vsnxtr=3

Windows NT Version V5.2 Service Pack 2

CPU : 1 – type 586, 1 Physical Cores

Process Affinity : 0×00000000

Memory (Avail/Total): Ph:898M/2047M, Ph+PgF:2100M/3943M, VA:1230M/2047M

Tue Jan 06 10:58:52 2009

WARNING: The background_dump_dest init.ora parameter has been deprecated.

WARNING: Please remove the background_dump_dest parameter from the init.ora file.

WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data

WARNING: The new location for the background logs and traces is c:\app\administrator\diag\rdbms\icmnlsdb\icmnlsdb\trace

Tue Jan 06 10:58:52 2009

WARNING: The user_dump_dest init.ora parameter has been deprecated.

WARNING: Please remove the user_dump_dest parameter from the init.ora file.

WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data

WARNING: The new location for the user logs and traces is c:\app\administrator\diag\rdbms\icmnlsdb\icmnlsdb\trace

ADR Base的默认位置与系统环境变量$ORACLE_BASE 一致。如果 “diagnostic_dest”在spfile中被设置，那么这个值成为ADR的位置。否则，Oracle默认使用$ORACLE_BASE值作为ADR Base的位置。

ADR home (adr_home)是一个通用的目录结果，用以存储 trace files，alter logs，core files 和incident information (instance specific)。 <adr_home> 总是位于 <adr_base>下. <adr_home>的地址是: <ADR_BASE>/diag/rdbms/<DB_name>/<instance_id>.

例如：

SQL> show parameter diag

NAME TYPE VALUE

———————————— ———– ——————————

diagnostic_dest string C:\APP\ADMINISTRATOR

The trace file location of icmnlsdb is C:\app\Administrator\diag\rdbms\icmnlsdb\icmnlsdb

Posted in oracle | No Comments »

huojia

Archive for 01月, 2009

Test from Windows Live Writer

摄影-从单反开始-推荐《简单亦精彩，便宜也好货》

全民娱乐的赤壁之战

程砚秋论读书

使用 Statspack 实践

2008 年看过的书

Initialization Parameters Deprecated&Obsolete in Oracle Database 11g Release 1 (11.1)

Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1)

Initialization Parameters Obsolete in Oracle Database 11g Release 1 (11.1)

Oracle 11g-ORA-32004:obsolete and/or deprecated parameter(s) specified

Solution

Oracle 11g 新特性学习 – Oracel Trace File Location – Automatic Diagnostic Repository

Pages

Archives

Categories