-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。
阅读(712) | 评论(0) | 转发(0) |
