帮忙啊，oracle817在hp11.0上内存问题

eygle · 发表于 2003-3-7 11:42

肯定要从操作系统找找原因了

statpack对你的问题没有多大帮助。
你应该看看这些内存消耗被哪些进程占用了。

我们有一台同样的机器，400并发用户，运行的很正常。

给我看看你的swlist

seay · 发表于 2003-3-7 11:44

bjyz_001[/]#swlist -l product |grep PHSS
  PHSS_13408          1.0          CDE Localized Help Dec97 Cumulative Patch

  PHSS_13409          1.0          CDE Loc Action/Res Dec97 Cumulative Patch

  PHSS_14578          1.0          HP C++ core library components (A.12.10)
  PHSS_14581          1.0          libm patch
  PHSS_14826          1.0          Update man page for gang scheduling
  PHSS_14982          1.0          PDCINFO patch Version A.02.24
  PHSS_15396          1.0          Asian Printer cumulative patch
  PHSS_16482          1.0          CDE Localization for UTF8 locales
  PHSS_16587          1.0          HP aC++ runtime libraries (aCC A.03.13)
  PHSS_16649          1.0          Receiver Services October 1998 Patch
  PHSS_16839          1.0          Assembler patch.
  PHSS_16849          1.0          LIBCL patch
  PHSS_16931          1.0          milli.a patch
  PHSS_17116          1.0          CPSlib Cumulative Patch
  PHSS_17421          1.0          XClients JAN 99 Cumulative Patch
  PHSS_17535          1.0          Font Server JAN 99 Cumulative Patch
  PHSS_17810          1.0          HP DCE/9000 1.7 Runtime cumulative patch
  PHSS_17980          1.0          ImagingSubsystem April 1999 Periodic Patc
h
  PHSS_18014          1.0          XLocale Database for UTF8
  PHSS_18649          1.0          Assembler patch
  PHSS_18778          1.0          AudioSubsystem June 1999 Periodic Patch
  PHSS_19069          1.0          Asian Printer cumulative patch
  PHSS_19699          1.0          ImagingSubsystem Sept 1999 Periodic Patch

  PHSS_19866          1.0          ld(1) and linker tools cumulative patch
  PHSS_19956          1.0          LIBCL patch
  PHSS_19964          1.0          X/Motif2.1 Runtime OCT99 Periodic Patch
  PHSS_20055          1.0          HP aC++ runtime libraries (aCC A.03.25)
  PHSS_20140          1.0          CDE Runtime OCT99 Cumulative Patch
  PHSS_20141          1.0          Xserver cumulative patch
  PHSS_20142          1.0          X/Motif2.1 Runtime OCT99 Cumulative Patch

  PHSS_20143          1.0          TechPrintServ OCT99 Cumulative Patch
  PHSS_20144          1.0          X11 64bit Runtime OCT99 Cumulative patch
  PHSS_20145          1.0          CDE Msg Cat OCT99 Cumulative Patch
  PHSS_20146          1.0          Firmware update for B1000, C3000 and J500
0
  PHSS_20147          1.0          Asian Input Method cumulative patch
  PHSS_20148          1.0          ASX release notes cumulative patch
  PHSS_20149          1.0          SAM Kernel Tunable Parameter Sets
  PHSS_20189          1.0          ASX release notes NOV 1999 cumulative pat
ch
  PHSS_20190          1.0          Asian Input Method NOV 1999 cumulative pa
tch
  PHSS_20192          1.0          Asian Utility NOV 1999 cumulative patch
  PHSS_20298          1.0          Xserver cumulative patch
  PHSS_20444          1.0          HP DCE/9000 1.7 Runtime cumulative patch
  PHSS_20736          1.0          LIBISAMSTUB patch
  PHSS_20853          1.0          Shared libF90 [11.01.11]
  PHSS_20863          1.0          CDE Msg Cat MAR2000 Periodic Patch
  PHSS_20864          1.0          CDE Runtime MAR2000 Periodic Patch
  PHSS_20866          1.0          XClients MAR2000 Periodic Patch
  PHSS_21075          1.0          varargs.h patch
  PHSS_21283          1.0          X/Motif 64bit Runtime APR2000 Periodic Pa
tch
  PHSS_21663          1.0          AudioSubsystem June 2000 Periodic Patch
  PHSS_21947          1.0          ld(1) and linker tools cumulative patch
  PHSS_21959          1.0          X/Motif 32bit Runtime AUG2000 Periodic Pa
tch
  PHSS_21996          1.0          & 11.11 MC/SG & SG-OPS Edition A.11.09
  PHSS_22475          1.0          B1K/B2K/C3X00/J5X00/J6K/J7K 4.5 FW update

  PHSS_22876          1.0          MC/ServiceGuard and SG-OPS Edition A.11.0
9
  PHSS_23185          1.0          B1000/B2000/C3X00/J5X00/J6000/J7000 4.9 F
W
  PHSS_26138          1.0          OV EMANATE14.2 Agent Consolidated Patch
  PHSS_26750          1.0          MC/ServiceGuard and SG-OPS Edition A.11.0
9

seay · 发表于 2003-3-7 11:46

swlist内容太多了，你想要看什么洋的

biti_rainy · 发表于 2003-3-7 11:52

delete /rollback 内存会急剧使用，我感觉：
SGA 的一部分在最初分配的时候有一部分在 swap 之中而没有完全在内存中

从而这样会导致 free  mem 减少

你持续地做这样的动作，最多可减少到多少？

oracle 使用内存能超过你定义给它的SGA内存+  PGA 么？

假如是多用户
比这个值大的多的话那就应该是bug  么
SGA + (sort_area_size + hash_are_size  + 3M ) * sessions

eygle · 发表于 2003-3-7 11:52

天，狂多，你看看我的机器，比较一下有何不同:
------------------------------------------------------------------------------------------------------------------------------
#
# Bundle(s):
#

  A4926A B.11.00.09    1000BaseSX PCI Gigabit Ethernet LAN Driver
  A5230A B.11.00.04    100BT/9000 PCI
  B2491BA B.11.00       MirrorDisk/UX
  B3919EA_2A5 B.11.00       Special Edition HP-UX Unlimited-User Lic
  B3935BA A.11.09       MC / Service Guard
  B4153A B.03.10       HP UPS Manager II
  B5456CA C.01.18.01    HP-UX Development Kit for Java*
  B5509BA B.11.00.04    100BT/9000 PCI
  B8342AA B.11.00.02    Netscape Communicator 4.7
  B8723AA A.01.01       CIFS/9000 Client Lic. for 9000 Servers
  B8725AA A.01.01       CIFS/9000 Server Lic. for 9000 Servers
  HPUXSCh64RT B.11.00       Simplified Chinese HP-UX 64-bit Runtime Environment
  OnlineDiag B.11.00.16.09  HPUX 11.0 Support Tools Bundle
  RCTool                11.0 RCTools
  UXCoreMedia-S B.11.00       HP-UX Simplified Chinese Media Kit (Reference Only. See Description)
  XSWECO223 A.1.0       Patch Replacement bundle
  XSWGR1100 B.11.00.48    HP-UX General Release Patches, March 2000
  XSWHWCR1100 B.11.00.48    HP-UX Hardware Enablement and Critical Patches, March 2000
#
# Product(s) not contained in a Bundle:
#

  CEToolSet A.1.0       11.00.800 CETools
  Contrib-Tools B.11.00.12.07  Contributed Tools
  PHCO_20882 1.0          fsck_vxfs(1M) cumulative patch
  PHCO_21435 B.11.00.13    HP AutoRAID Manager cumulative patch
  PHCO_22664 1.0          cumulative patch for /sbin/init
  PHCO_23149 B.11.00.14    HP Array Manager/60 cumulative patch
  PHKL_21834 B.11.00.AA    Fibre Channel Mass Storage Driver Patch
  PHNE_20316 1.0          Cumulative STREAMS Patch
  PHNE_20657 1.0          LAN product cumulative patch
  PHNE_20735 1.0          cumulative ARPA Transport patch
  PHSS_21107 1.0          MC/ServiceGuard & SG-OPS Edition A.11.09
  PHSS_22657 1.0          N4000 41.02 firmware patch
----------------------------------------------------------------------------------------------------------------------------------------------------------------------