Chinaunix首页 | 论坛 | 博客
  • 博客访问: 254202
  • 博文数量: 59
  • 博客积分: 1400
  • 博客等级: 上尉
  • 技术积分: 698
  • 用 户 组: 普通用户
  • 注册时间: 2008-10-19 21:17
文章分类

全部博文(59)

文章存档

2009年(14)

2008年(45)

我的朋友

分类: 数据库开发技术

2009-08-31 23:49:12

-rw-------   1 orasvcn3   orasvcn3   66806464 Aug 27 18:51 core
[PROD:LGDDMEN3:orasvcn3:/engn7n1/orasvcn3/product/10.2.0/dbs] # more initN3MESP1.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
 
###########################################
# Archive
###########################################
log_archive_dest_1='LOCATION=/logs7n2/orasvcn3/N3MESP1/archive/'
log_archive_format=arch_N3MESP1_%t_%s_%r.arc
 
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=5033164800
db_file_multiblock_read_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=1000
 
###########################################
# Database Identification
###########################################
db_domain=""
db_name=N3MESP1
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/logs7n1/orasvcn3/N3MESP1/bdump
core_dump_dest=/logs7n1/orasvcn3/N3MESP1/cdump
user_dump_dest=/logs7n1/orasvcn3/N3MESP1/udump
 
###########################################
# File Configuration
###########################################
control_files=("/data7n1/orasvcn3/N3MESP1/system/ctl_N3MESP1_01.ctl", "/data7n2/orasvcn3/N3MESP1/system/ctl_N3MESP1_02.ctl", "/data7
n3/orasvcn3/N3MESP1/system/ctl_N3MESP1_03.ctl")
 
###########################################
# Job Queues
###########################################
job_queue_processes=10
 
###########################################
# Miscellaneous
###########################################
compatible=10.2.0.3.0
 
###########################################
# Network Registration
###########################################
#local_listener=LISTENER_N3MESP1
 
###########################################
# Pools
###########################################
java_pool_size=0
large_pool_size=104857600
shared_pool_size=3355443200
 
###########################################
# Processes and Sessions
###########################################
processes=1500
sessions=1655
 
###########################################
# Security and Auditing
###########################################
audit_file_dest=/logs7n1/orasvcn3/N3MESP1/adump
remote_login_passwordfile=EXCLUSIVE
 
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=5033164800
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
undo_retention=3600
###########################################
# 2009.03.12 Park Jung Woo
# (Oracle Recommendation)
###########################################
db_files=1000
optimizer_mode=CHOOSE
#session_cached_cursors=300
session_cached_cursors=0        #2009.08.20 ORA-00600 [17059] / SR.7604549.993 / Bug 5177766
fast_start_mttr_target=300
sga_max_size=9600M
_undo_autotune=false    #2009.03.12 Oracle Recommendation, Park Jung Woo
db_cache_advice=OFF     #2009.03.12 Park Jung Woo (Oracle Bug 5918642 exist/It has a chance of lower performance)
###########################################
# 2009.03.12 Park Jung Woo
# (Oracle Recommendation)
###########################################
_in_memory_undo=FALSE
_db_mttr_advice=OFF
_library_cache_advice=FALSE
_smm_advice_enabled=FALSE
optimizer_dynamic_sampling=0
_gby_hash_aggregation_enabled=FALSE
_optimizer_order_by_elimination_enabled=false
_enable_NUMA_optimization=FALSE
_db_block_numa=1
###########################################
# 2009.03.12 Park Jung Woo
# (Optimizer Team Recommendation)
###########################################
_TABLE_LOOKUP_PREFETCH_SIZE=0
_B_TREE_BITMAP_PLANS=FALSE
###########################################
# 2009.03.12 Park Jung Woo
# (Optimizer Team Recommendation)
###########################################
_bloom_filter_enabled = FALSE
_optimizer_push_pred_cost_based=FALSE
_optim_peek_user_binds=FALSE
###########################################
# 2009.03.12 Park Jung Woo
# ORACLE Recommendation
###########################################
_addm_auto_enable=FALSE
parallel_execution_message_size=16384
hpux_sched_noage=180
_os_sched_high_priority=178
-------------------------------------------------------------------
#!/usr/bin/ksh
# ********************************************************************
# *  Script Name : orasvcn3_profile                                  *
# *  Description : Default user .profile file.                       *
# ********************************************************************
# *  2009/08/07  NJ MES Roll-in Project                              *
# ********************************************************************
export ORACLE_BASE=/engn7n1/orasvcn3
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
export ORACLE_SID=N3MESP1
export NLS_LANG=American_America.UTF8
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export PATH=$PATH:/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
export SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export ORACLE_LIB=$ORACLE_HOME/lib32
export RDBMS_LIB=$ORACLE_HOME/rdbms/lib
export ORACLE_INC=$ORACLE_HOME/rdbms/demo
export ORACLE_BIN=$ORACLE_HOME/bin
export ORAlib=$ORACLE_HOME/lib32
export ORAplsql=$ORACLE_HOME/plsql/public
export ORArdbms=$ORACLE_HOME/rdbms/public
export ORAdemo=$ORACLE_HOME/rdbms/demo
export ORAinc=$ORACLE_HOME/rdbms/public
alias bdump='cd /logs7n1/orasvcn3/N3MESP1/bdump/'
alias udump='cd /logs7n1/orasvcn3/N3MESP1/udump/'
alias cdump='cd /logs7n1/orasvcn3/N3MESP1/cdump/'
----------------
[PROD:LGDDMEN3:orasvcn3:/engn7n1/orasvcn3/product/10.2.0/network/admin] # more listener.ora
LI_N3MESP1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.29.214.63)(PORT = 2523))
    )
  )
SID_LIST_LI_N3MESP1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME =N3MESP1)
      (ORACLE_HOME = /engn7n1/orasvcn3/product/10.2.0)
    )
  )
LOG_DIRECTORY_LI_N3MESP1 = /logs7n1/orasvcn3/N3MESP1/listenerlog
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LI_N3MESP1=OFF
*****************************************************************
在oracle10g中该参数的默认值变为hpux_sched_noage                     integer     180???
----------------------
CPU info:
   Number of CPUs = 8
   Clock speed = 1598 MHz
   Bus speed   = 533 MT/s
   CPUID registers
      vendor information =       "GenuineIntel"
      processor serial number =  0x0000000000000000
      processor version info =   0x0000000020010104
         architecture revision:       0
         processor family:           32   Intel(R) Itanium 2 9100 series
         processor model:             1   Intel(R) Itanium 2 9100 series
         processor revision:          1   Stepping A1
         largest CPUID reg:           4
      processor capabilities =   0x0000000000000005
                      implements long branch:  1
        implements 16-byte atomic operations:  1
   Bus features
      implemented =  0xbdf0000020000000
      selected    =  0x0020000000000000
         Exclusive Bus Cache Line Replacement Enabled
Cache info (per core):
   L1 Instruction: size =   16 KB, associativity = 4
   L1 Data:        size =   16 KB, associativity = 4
   L2 Instruction: size = 1024 KB, associativity = 8
   L2 Data:        size =  256 KB, associativity = 8
   L3 Unified:     size = 9216 KB, associativity = 9
Memory = 32699 MB (31.932617 GB)
Firmware info:
   Firmware revision = 9.048
   FP SWA driver revision: 1.18
   IPMI is supported on this system.
   BMC version: 4.01
Platform info:
   model string =          "ia64 hp server rx7640"
   machine id number =     64b70b94-8e47-11de-81a2-e99868288dfb
   machine serial number = SGH49281C4
OS info:
   sysname  = HP-UX
   nodename = LGDDMEN3
   release  = B.11.23
   version  = U (unlimited-user license)
   machine  = ia64
   idnumber = 1689717652
   vmunix _release_version:              
@(#) $Revision: vmunix:    B11.23_LR FLAVOR=perf Fri Aug 29 22:35:38 PDT 2003 $
------------------root----------------
[PROD:LGDDMEN3:root:/] # ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         1048576
stack(kbytes)        131072
memory(kbytes)       unlimited
coredump(blocks)     4194303
nofiles(descriptors) 10000
--------------Oracle------------
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         1048576
stack(kbytes)        131072
memory(kbytes)       unlimited
coredump(blocks)     4194303
-----
orasvcn3 26196     1  0  Aug 26  ?         5:10 ora_mmnl_N3MESP1
orasvcn3 26194     1  0  Aug 26  ?         0:14 ora_mmon_N3MESP1
orasvcn3 26191     1  0  Aug 26  ?         5:50 ora_cjq0_N3MESP1
orasvcn3 26189     1  0  Aug 26  ?         0:02 ora_reco_N3MESP1
orasvcn3 26173     1  0  Aug 26  ?         1:56 ora_pmon_N3MESP1
orasvcn3 26181     1  0  Aug 26  ?        59:39 ora_lgwr_N3MESP1
orasvcn3 26224     1  0  Aug 26  ?         0:13 ora_qmnc_N3MESP1
orasvcn3 26185     1  0  Aug 26  ?         3:24 ora_ckpt_N3MESP1
orasvcn3 26581     1  0  Aug 26  ?         0:12 ora_q001_N3MESP1
orasvcn3 26562     1  0  Aug 26  ?         0:01 ora_q000_N3MESP1
orasvcn3 26218     1  0  Aug 26  ?         5:19 ora_arc0_N3MESP1
orasvcn3 26220     1  0  Aug 26  ?         5:25 ora_arc1_N3MESP1
orasvcn3 26177     1  0  Aug 26  ?         0:11 ora_mman_N3MESP1
orasvcn3 26187     1  0  Aug 26  ?         0:24 ora_smon_N3MESP1
orasvcn3 26179     1  0  Aug 26  ?        79:40 ora_dbw0_N3MESP1
orasvcn3 26175     1  0  Aug 26  ?         0:07 ora_psp0_N3MESP1
---
日志文件5组,每组2个日志,每个文件大小为1G。
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
阅读(743) | 评论(0) | 转发(0) |
0

上一篇:误删dual表,启动数据库失败

下一篇:没有了

给主人留下些什么吧!~~