﻿<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title>string's blog 我的浮躁生活</title>
		<link>http://blog.astring.net//</link>
		<description>他不是演员</description>
		<copyright>Copyright (C) 2004 Security Angel Team [S4T] All Rights Reserved.</copyright>
		<generator>SaBlog-X Version 1.6 Build 20071004</generator>
		<lastBuildDate>Tue, 07 Sep 2010 22:29:07 +0000</lastBuildDate>
		<ttl></ttl>
		<item>
			<guid>http://blog.astring.net//show-660-1.html</guid>
			<title>杭州历险记</title>
			<author>string</author>
			<description><![CDATA[<p>上午10点接到电话，回家收拾了2件衣服地铁去火车站。火车晚上6点才发车，无奈汽车过往。出租车不认路，东北小伙很能想办法，在每个红绿灯都摇下车窗问路，感觉很不错。为解决问题使用上所能想到的每一个办法才是王道。</p>
<p>下午4点10分到达工厂门口，然后开始拨电话，无人接听。很纳闷。然后打电话给D，问同行工程师电话，D不知，电话助理，助理不知，电话原来呆过的ps，总算接通，才算是正式入场。</p>
<p>入场歇了会，然后组织人员开会，了解最原始的需求，硬件环境，软件环境，目前性能情况，项目架构。</p>
<p>会后开始干活。</p>
<p>第一天，把周边的邮件系统搞死了。</p>
<p>和在场工程师加床拼个房间。</p>
<p>小插曲：P同学订房没订上，前台大发脾气。我在想，要是能讹几份免费早餐会更好。</p>
<p>第二天，firewall +dns 死了。</p>
<p>小插曲：和客户人员聚餐，技术化的人沟通比较有意思。：）</p>
<p>第三天，数据量不大的情况下数据库deadlock。</p>
<p>小插曲，客户IT部头请吃饭，白话了技术的，管理的，经文很多玩意，不管是不是酒话，算是对客户的帮助吧。</p>
<p>第四天，定位死锁问题，</p>
<p>小插曲，IT部的头早上开车来接，晚上P同学请吃饭。发现最近自己的话忒多了点。</p>
<p>第五天，搞定死锁问题，召集性能结束会议。</p>
<p>eos+bps的性能还是不错的，如果有大的性能问题，一定是使用和架构的问题。：），说这句话，我很有底气。</p>
<p>下午，拎着客户送的礼品踏上回家的路。</p>
<p>---------------------------------------------------------------------------</p>
<p>1）就算是业务，客户不一定比自己更精通。</p>
<p>2）搞定问题的方式有很多，要学着全面看问题。</p>
<p>3）不迷信任何牛人，所谓愚者千虑亦有一得，多想想，那一得才是必须的。</p>]]></description>
			<link>http://blog.astring.net//show-660-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2010-06-01 11:53</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-659-1.html</guid>
			<title>如何导出windows性能数据到excel文件</title>
			<author>string</author>
			<description><![CDATA[<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">如何把perfmon的性能数据导出到excel中？</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">在性能测试的过程中，由于客户的要求不能开放对应的服务。Remote Procedure Call(RPC)和Remote Registry Service。loadrunner连接不上windows资源进行监控。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">那我们只能将性能数据导出到excel中，用excel强大的图表进行分析。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">废话不多说，开始吧。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">开始，运行，perfmon，打开性能监控工具。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">点击计数器日志，右边一般会出现一个文件 system overview 的日志文件。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">在右边空白处，点击右键，新建日志设置。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">输入该设置名称。然后添加计数器。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">主要监控processor，disk和memorry的状况，那就添加对应的计数器即可。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">调整数据采样间隔，和loadrunner的数据采样间隔保持一致。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">窗口头上，tab切换到日志文件。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">选择文件类型，选择文本文件。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">例如中就会出现C:\PerfLogs\PTest_000002.csv 类似这种值。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">然后启动该日志配置。在工具栏中。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">压力测试之后，用excel打开对应的csv文件。</font></span></span></p>
<p><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang="EN-US"><font size="2" face="Courier New">查看对应的列，使用excel图标对应该列生成折线图即可。</font></span></span></p>]]></description>
			<link>http://blog.astring.net//show-659-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2010-05-21 17:23</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-656-1.html</guid>
			<title>bes+eos测试点滴</title>
			<author>string</author>
			<description><![CDATA[<p>bes是borland公司的应用服务器，此次测试基于aix 5.3 + bes6.7 + eos6.0测试。</p>
<p>本文档记录在测试中发现的问题和结果的过程。积累思路。</p>
<p>--------------------bes 安装------------------</p>
<p>borland的哥们给的安装包很智能，一个sh文件即可。通过host模块方式部署文档，war包无法加载。</p>
<p>打印出classloader，war包中的lib无法加载，</p>
<p>$jar -xvf&nbsp; ***.jar&nbsp; 解开报错。</p>
<p>问题所在，ftp 上传，没有设置bin模式。</p>
<p>ftp&gt;bin</p>
<p>设置bin模式，再次上传，用jar能解开，即可不是war包。</p>
<p>---------------------数据库----------------------</p>
<p>1）快照描述，大量性能损耗在日志轮换。</p>
<p>oracle的日志，redo.log，需要放在IO最好的磁盘中。</p>
<p>通过em或者命令行，添加redo.log文件，切换，删掉原有redo.log即可。</p>
<p>2）命令行模式安装快照。</p>
<p>sql&gt;@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\spcreate.sql</p>
<p>安装如出现not connecting</p>
<p>需在spcreate.sql 中加入连接字符串。</p>
<p>connect <a href="mailto:perfstat/&amp;&amp;perfstat_password@eos">perfstat/&amp;&amp;perfstat_password@eos</a>&nbsp; 即可。</p>
<p>-------------------服务器调优----------------</p>
<p>bes的服务器，接入端包装的为tomcat。</p>
<p>可以通过修改 /bes/BES6.7/var/domains/base/configurations/BPS6.0/mos/standard/adm/tomcat/conf</p>
<p>目录下的server.xml来做调整。</p>
<p>比如连接池，超时时间，更改此文件，可以参考tomcat的更改方式。</p>
<p><font size="2">压力测试需要调整log的级别。</font></p>
<p style="text-align: left; margin: 0cm 0cm 0pt" class="MsoNormal" align="left"><font size="2"><span style="font-family: 宋体; color: black; font-size: 11pt" lang="EN-US">/home/bes/BES6.7/var/domains/base/configurations/EOS6.1/mos/standard/adm/logs</span><span style="font-family: 宋体; color: black; font-size: 11pt">，日志相关配置可以通过修改<span lang="EN-US">/home/bes/BES6.6/var/domains/base/configurations/EOS6.1/mos/standard/adm/properties/</span></span></font></p>
<p style="text-align: left; margin: 0cm 0cm 0pt" class="MsoNormal" align="left"><span style="font-family: 宋体; color: black; font-size: 11pt"><font size="2"><span lang="EN-US">logConfiguration.xml</span>来完成。<span lang="EN-US"><o:p></o:p></span></font></span></p>
<p style="text-align: left; margin: 0cm 0cm 0pt" class="MsoNormal" align="left"><span style="font-family: 宋体; color: black; font-size: 11pt"><font size="2">如果日志量很大，可以考虑调低日志级别</font></span></p>
<p style="text-align: left; margin: 0cm 0cm 0pt" class="MsoNormal" align="left">&nbsp;</p>
<p>--------------------应用调优------------------</p>
<p>&nbsp;</p>
<p>通过调整应用中的业务逻辑，省掉数据库操作，来调整。</p>
<p>-------------------loadrunner脚本验证-------------</p>
<p>在压力测试中，loadrunner脚本变量设置，可能会出现变量越界的情况。</p>
<p>和数据库配合统计，来保证测试结果的正确。</p>
<p>------------------------------------------------------------------------</p>
<p>一次性能测试，涉及的因素可能有以下几个方面：</p>
<p>1）硬件，包括app服务器，database 服务器，loadrunner client，网络等。</p>
<p>2）软件，包括app 应用服务器，database应用服务器，loadrunner 设置等。</p>
<p>3）测试案例。</p>
<p>4）测试脚本。</p>
<p>隔离问题，才能解决问题。</p>]]></description>
			<link>http://blog.astring.net//show-656-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2010-05-11 16:56</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-653-1.html</guid>
			<title>再访郑州</title>
			<author>string</author>
			<description><![CDATA[<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><font face="Comic Sans MS"><span lang="EN-US">3</span><span style="font-family: 宋体">月</span><span lang="EN-US">3</span><span style="font-family: 宋体">号下午</span><span lang="EN-US">3</span><span style="font-family: 宋体">点到。在那里工作了</span><span lang="EN-US">20</span><span style="font-family: 宋体">个小时，具体工作如下：</span></font></p>
<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><font face="Comic Sans MS"><span lang="EN-US">&nbsp;&nbsp; 3</span><span style="font-family: 宋体">月</span><span lang="EN-US">3</span><span style="font-family: 宋体">号，工作时间，</span><span lang="EN-US">3</span><span style="font-family: 宋体">小时。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">1.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">了解需求，客户提出按照他们的开发场景，按照通用测试方式测试，根据</span><span lang="EN-US">word</span><span style="font-family: 宋体">版本的要求，开发测试用例。</span></font></p>
<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><font face="Comic Sans MS"><span lang="EN-US">&nbsp;&nbsp; 3</span><span style="font-family: 宋体">月</span><span lang="EN-US">4</span><span style="font-family: 宋体">号，工作时间，</span><span lang="EN-US">9</span><span style="font-family: 宋体">小时。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">1.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">更改用例，录制脚本；</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">2.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span lang="EN-US">windows2003 </span><span style="font-family: 宋体">应用服务器宕机，查明原因是因为没有补丁，打补丁。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">3.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">本地压力试跑，压力</span><span lang="EN-US">100</span><span style="font-family: 宋体">，本地网络使用</span><span lang="EN-US">99%</span><span style="font-family: 宋体">，重新创建</span><span lang="EN-US">windows2003 </span><span style="font-family: 宋体">虚拟机，在千兆网段。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">4.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">表空间不够，新建</span><span lang="EN-US">100G</span><span style="font-family: 宋体">的表空间。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">5.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">容量测试完成，并发压力测试，</span><span lang="EN-US">windows2003</span><span style="font-family: 宋体">的操作系统内核参数调整失败，无法接受到大于</span><span lang="EN-US">1600</span><span style="font-family: 宋体">的集合点并发请求。</span></font></p>
<p style="margin: 0cm 0cm 0pt 15.75pt" class="MsoNormal"><font face="Comic Sans MS"><span lang="EN-US">3</span><span style="font-family: 宋体">月</span><span lang="EN-US">5</span><span style="font-family: 宋体">号，工作时间，</span><span lang="EN-US">8</span><span style="font-family: 宋体">小时。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">1.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">由于</span><span lang="EN-US">app server</span><span style="font-family: 宋体">操作系统的问题，在</span><span lang="EN-US">aix</span><span style="font-family: 宋体">上重新安装</span><span lang="EN-US">weblogic10.3</span><span style="font-family: 宋体">，</span><span lang="EN-US">eos 6.1</span><span style="font-family: 宋体">。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">2.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">并发压力测试压力机不够，联系系统部门安装分配新的虚拟机</span><span lang="EN-US">3</span><span style="font-family: 宋体">台。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">3.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">完成最大并发测试。由于网络流量和</span><span lang="EN-US">loadrunner </span><span style="font-family: 宋体">虚拟机数量的限制，并发用户到了</span><span lang="EN-US">5000</span><span style="font-family: 宋体">，没有错误。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">4.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">基于</span><span lang="EN-US">windows2003</span><span style="font-family: 宋体">的应用服务器完成容量测试。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">5.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">和多方沟通关于版本测试的问题。下载不到</span><span lang="EN-US">weblogic923for aix</span><span style="font-family: 宋体">的版本，没有做关于</span><span lang="EN-US">1.5JDK</span><span style="font-family: 宋体">的测试。</span></font></p>
<p style="text-indent: -18pt; margin: 0cm 0cm 0pt 33.75pt" class="MsoListParagraph"><font face="Comic Sans MS"><span lang="EN-US">6.</span><span style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; font-size: 7pt" lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="font-family: 宋体">和对方沟通关于</span><span lang="EN-US">EJB</span><span style="font-family: 宋体">远程部署，交接测试的环境。</span></font></p>
<p><font face="Comic Sans MS"><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">定的</span><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体" lang="EN-US">3</span><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">月</span><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体" lang="EN-US">5</span><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">号晚上</span><span style="font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体" lang="EN-US">11</span><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">点半回到上海。</span></font></p>
<p><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><font face="Comic Sans MS">这次住的地方貌似还不错，是原来的驻马店酒店。</font></span></p>
<p><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><font face="Comic Sans MS">一起工作的小伙是85年的，年轻有为，也挺好。</font></span></p>
<p><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><font face="Comic Sans MS">虽然是私企，但给人感觉国企的氛围十分重。一些领导三句落不到关键点上，拿客户忽悠。不太靠谱。</font></span></p>
<p><span style="font-family: 宋体; font-size: 10.5pt; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><font face="Comic Sans MS">当然，这些都不关我的事情。</font></span></p>]]></description>
			<link>http://blog.astring.net//show-653-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2010-03-08 13:40</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-648-1.html</guid>
			<title>TPCC学习笔记</title>
			<author>string</author>
			<description><![CDATA[<p>-----------------TPC---------------</p>
<p>TPC为非赢利性国际组织，事物处理性能委员会（TPC，Transaction Processing Corp）。</p>
<p>-----------------TPC-C--------------</p>
<p>TPC-C是一种旨在衡量联机事务处理（OLTP）系统性能与可伸缩性的行业标准基准测试项目。这种基准测试项目将对包括查询、更新及队列式小批量事务在内的广泛数据库功能进行测试。许多IT专业人员将TPC-C视为衡量&ldquo;真实&rdquo;OLTP系统性能的有效指示器。</p>
<p>TPC-C基准测试针对一种模拟订单录入与销售环境测量每分钟商业事务（tpmC）吞吐量。特别值得一提的是，它将专门测量系统在同时执行其它四种事务类型（如支付、订单状态更新、交付及证券级变更）时每分钟所生成的新增订单事务数量。</p>
<p>-----------------TPM-C--------------</p>
<p>TPC-C的吞吐量，按有效TPC-C配置期间每分钟处理的平均交易次数测量，至少要运行12分钟。</p>
<p>-----------------TPC-C规范概要----------------</p>
<p>TPC-C测试规范中模拟了一个比较复杂并具有代表意义的OLTP应用环境:假设有一个大型商品批发商，它拥有若干个分布在不同区域的商品库；每个仓库负责为10个销售点供货；每个销售点为3000个客户提供服务；每个客户平均一个订单有10项产品;所有订单中约1%的产品在其直接所属的仓库中没有存货，需要由其他区域的仓库来供货。 <br />
该系统需要处理的交易为以下几种： <br />
&nbsp; New-Order：客户输入一笔新的订货交易； <br />
&nbsp; Payment:更新客户账户余额以反映其支付状况; <br />
&nbsp; Delivery:发货(模拟批处理交易); <br />
&nbsp; Order-Status:查询客户最近交易的状态； <br />
&nbsp; Stock-Level:查询仓库库存状况，以便能够及时补货。 <br />
对于前四种类型的交易，要求响应时间在5秒以内；对于库存状况查询交易，要求响应时间在20秒以内。</p>
<p>-----------------之间的关系------------------</p>
<p>TPC-C使用三种性能 和价格度量，其中性能由TPC-C吞吐率衡量，单位是tpmC。tpm是transactions per minute的简称；C指TPC中的C基准程序。它的定义是每分钟内系统处理的新订单个数。要注意的是，在处理新订单的同时，系统还要按表1的要求处理其它4类事务 请求。从表1可以看出，新订单请求不可能超出全部事务请求的45％，因此，当一个 系统的性能为1000tpmC时，它每分钟实际处理的请求数是2000多个。价格是指系 统的总价格，单位是美元，而价格性能比则定义为总价格&divide;性能，单位是＄/tpmC。</p>]]></description>
			<link>http://blog.astring.net//show-648-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 18:03</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-647-1.html</guid>
			<title>基于HP-UX的一次测试调整（五）</title>
			<author>string</author>
			<description><![CDATA[<p><font size="2">第五章 trouble shooting</font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290948"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">数据库维护</font></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">dbca </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数据库界面维护</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">netca </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">网络监听界面维护</span><font face="Calibri"> </font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">emctl</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">控制台维护</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">常用命令如下：</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">emctl start dbconsole </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">启动</span><span lang="EN-US"><font face="Calibri">em</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">emctl stop dbconsole </font></span></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290949"><span lang="EN-US"><font face="Calibri" size="2">rmi</font></span></a><font size="2"><span style="mso-bookmark: _Toc248290949"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">远程访问</span><span lang="EN-US"><font face="Calibri"> hp -ux</font></span></span><span style="mso-bookmark: _Toc248290949"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的应用，会转到到另外一个</span><span lang="EN-US"><font face="Calibri">IP.</font></span></span><span lang="EN-US"><font face="Calibri"> </font></span></font></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看</span><span lang="EN-US"><font face="Calibri">/etc/hosts</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">文件，去掉无关的</span><span lang="EN-US"><font face="Calibri">ip</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">和描述。</span><font face="Calibri"> </font></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290950"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">操作数据库，大量事务，</span><span lang="EN-US"><font face="Calibri">shutdown immediate</font></span></font></a><span style="mso-bookmark: _Toc248290950"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">，数据库挂起</font></span></span></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; alter system checkpoint; </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">　　</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; shutdown abort </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">　　</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; startup restrict </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">　　</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt; shutdown immediate</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt; startup</font></span></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290951"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数据库</span><span lang="EN-US"><font face="Calibri">cpu</font></span></font></a><span style="mso-bookmark: _Toc248290951"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">过高的跟踪过程</font></span></span></h3>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l1 level1 lfo2"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">1.</font><span style="font: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">确保</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">关闭。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l1 level1 lfo2"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">2.</font><span style="font: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">确认对应的用户在对应的表空间。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt; select username,default_tablespace from user_users;</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">1．</font><span style="font: 7pt 'Times New Roman'">&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看</span><span lang="EN-US"><font face="Calibri">sql</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">参数是否生效</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">show parameter processes</span><span style="font-size: 10pt; color: navy; line-height: 150%; font-family: 宋体; mso-ascii-font-family: 'Courier New'; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; mso-font-kerning: 0pt">；</span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt"><o:p></o:p></span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">show parameter </span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt">sessions</span><span style="font-size: 10pt; color: navy; line-height: 150%; font-family: 宋体; mso-ascii-font-family: 'Courier New'; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; mso-font-kerning: 0pt">；</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">show parameter </span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt">sga</span><span style="font-size: 10pt; color: navy; line-height: 150%; font-family: 宋体; mso-ascii-font-family: 'Courier New'; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; mso-font-kerning: 0pt">；</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">show parameter </span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt">pga</span><span style="font-size: 10pt; color: navy; line-height: 150%; font-family: 宋体; mso-ascii-font-family: 'Courier New'; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 'Courier New'; mso-bidi-font-family: 'Courier New'; mso-font-kerning: 0pt">；</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">2．</font><span style="font: 7pt 'Times New Roman'">&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看操作系统的参数是否生效。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><font face="Calibri" size="2">#sam</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在出来的字符集界面，查看</span><span lang="EN-US"><font face="Calibri">Kernel Configuration</font></span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看</span><span lang="EN-US"><font face="Calibri">Tunables</font></span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">查看设置的系统参数是否生效。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">5.<span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看</span><span lang="EN-US"><font face="Calibri">IO.</font></span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290952"><span lang="EN-US"><font face="Calibri" size="2">Loadrunner</font></span></a><font size="2"><span style="mso-bookmark: _Toc248290952"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">无法监控</span><span lang="EN-US"><font face="Calibri">hp-ux</font></span></span><span style="mso-bookmark: _Toc248290952"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的系统资源</span></span></font></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">打开</span><span lang="EN-US"><font face="Calibri">/etc/inetd.conf</font></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">找到</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#rpc<span style="mso-spacerun: yes">&nbsp; </span>dgram<span style="mso-spacerun: yes">&nbsp; </span>udp<span style="mso-spacerun: yes">&nbsp; </span>wait<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>root<span style="mso-spacerun: yes">&nbsp; </span>/usr/lib/netsvc/rstat/rpc.rstatd</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">去掉注释，下次系统重新启动，即可监控。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">或者在</span><span lang="EN-US"><font face="Calibri">/usr/lib/netsvc/rstat/</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">目录中</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#./rpc.rstatd</font></span></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290953"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">数据库初始化</font></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">当库表的字段够多，而脚本初始化很快的时候，直接删除行会是一个比较漫长的过程。而且删除后需要分析该表格。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">建议用</span><span lang="EN-US"><font face="Calibri"> truncate table TRANJOURNAL </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">来清空表，重新初始化数据即可。</span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290954"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">应用服务器连接数不够，</span><span lang="EN-US"><font face="Calibri">sessions</font></span></font></a><span style="mso-bookmark: _Toc248290954"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">不够</font></span></span></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">请查看数据库对外的</span><span lang="EN-US"><font face="Calibri">processes</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数量。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt;show parameter processes;</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt;show parameter sessions;</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">如果低于连接数，参考</span><span lang="EN-US"><a href="http://blog.astring.net/admin/editor/editor/fckeditor.html?InstanceName=content&amp;Toolbar=Default#_修改processes和sessions的大小。"><span lang="EN-US" style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><span lang="EN-US">修改</span></span><font face="Calibri">processes,sessions</font></a></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">修改。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">查看</span><span lang="EN-US"><font face="Calibri">sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">对应的</span><span lang="EN-US"><font face="Calibri">sql</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">为：</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt;</font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">select</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white"> * </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">from</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white"> v$resource_limit </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">where</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white"> resource_name = </span><span lang="EN-US" style="font-size: 10pt; background: white; color: blue; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">'sessions'</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt; mso-highlight: white">;</span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: 'Courier New'; mso-font-kerning: 0pt"><o:p></o:p></span></font></p>]]></description>
			<link>http://blog.astring.net//show-647-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 11:36</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-646-1.html</guid>
			<title>基于HP-UX的一次测试调整（四）</title>
			<author>string</author>
			<description><![CDATA[<p><font size="2">第四章 loadrunner 压力端调整</font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290944"></a><a name="_Toc248224966"><span style="mso-bookmark: _Toc248290944"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">指定</span><span lang="EN-US"><font face="Calibri">MDRV.EXE</font></span></font></span></a><span style="mso-bookmark: _Toc248224966"><span style="mso-bookmark: _Toc248290944"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">使用进程数</font></span></span></span></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在本次测试中，</span><span lang="EN-US"><font face="Calibri">loadruner</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">客户端，发起的</span><span lang="EN-US"><font face="Calibri">JAVA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">协议连接，由于并发的数量比较大，我们只能采用线程的模式。在</span><span lang="EN-US"><font face="Calibri">loadrunner</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中，默认的是每</span><span lang="EN-US"><font face="Calibri">50</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个</span><span lang="EN-US"><font face="Calibri">vuser</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">会使用一个</span><span lang="EN-US"><font face="Calibri">mdrv.exe</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">进程，但是有些时候</span><span lang="EN-US"><font face="Calibri">vuser</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中的使用的线程太多就会使测试程序的效率特别低，这时候就希望能够可以多起几个</span><span lang="EN-US"><font face="Calibri">mdrv.exe</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的进程，每个进程中的</span><span lang="EN-US"><font face="Calibri">vuser</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数量少一点，通过更改</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">HP\LoadRunner\dat\protocols\ Java_protocols.lrp</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">文件。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在</span><span lang="EN-US"><font face="Calibri">[Vugen]</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">下面新加一条</span><span lang="EN-US"><font face="Calibri">MaxThreadPerProcess=</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">要设置的</span><span lang="EN-US"><font face="Calibri">vuser</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数量</span><font face="Calibri"> </font><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">这样每个</span><span lang="EN-US"><font face="Calibri">mdrv.exe</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">进程中的</span><span lang="EN-US"><font face="Calibri">vuser</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">数量就是你上面设置的数量了。</span><font face="Calibri"> </font></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290945"></a><a name="_Toc248224967"><span style="mso-bookmark: _Toc248290945"><span lang="EN-US"><font face="Calibri" size="2">JAVA</font></span></span></a><font size="2"><span style="mso-bookmark: _Toc248224967"><span style="mso-bookmark: _Toc248290945"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">协议测试，</span><span lang="EN-US"><font face="Calibri">JVM</font></span></span></span><span style="mso-bookmark: _Toc248224967"><span style="mso-bookmark: _Toc248290945"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">参数配置</span></span></span></font></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">需要配置环境路径</font></span><span lang="EN-US"><o:p><font face="Calibri" size="2">&nbsp;</font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">需要配置JVM参数</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt">&nbsp;</p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">不能添加</span><span lang="EN-US"><font face="Calibri">-server</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">参数。</span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290946"></a><a name="_Toc248224968"><span style="mso-bookmark: _Toc248290946"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">更改（</span><span lang="EN-US"><font face="Calibri">windows 2003</font></span></font></span></a><font size="2"><span style="mso-bookmark: _Toc248224968"><span style="mso-bookmark: _Toc248290946"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">）操作系统的对外最大</span><span lang="EN-US"><font face="Calibri">tcp</font></span></span></span><span style="mso-bookmark: _Toc248224968"><span style="mso-bookmark: _Toc248290946"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">连接数。</span></span></span></font></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">应用程序从系统请求可用用户端口时，</span><span lang="EN-US"><font face="Calibri">TCP/IP </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">可指定的最高端口号。</span><font face="Calibri"> </font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">使用</span><span lang="EN-US"><font face="Calibri"> regedit </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">命令访问</span><font face="Calibri"> </font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Services\TCPIP\Parameters </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">注册表子键并创建名为</span><span lang="EN-US"><font face="Calibri"> MaxUserPort </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的新</span><span lang="EN-US"><font face="Calibri"> REG_DWORD </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">值。缺省值：无建议值：至少十进制</span><span lang="EN-US"><font face="Calibri"> 32768</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，最大值十进制</span><span lang="EN-US"><font face="Calibri"> 65535</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。重新启动系统后生效。</span><font face="Calibri"> </font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">Windows Registry Editor Version 5.00 </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters] &ldquo;MaxUserPort&rdquo;=dword:000415630</font></span></p>
<p>&nbsp;</p>
<p><font size="2">PS：此次测试用的可是正版的loadrunner。</font></p>]]></description>
			<link>http://blog.astring.net//show-646-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 11:27</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-645-1.html</guid>
			<title>基于HP-UX的一次测试调整（三）</title>
			<author>string</author>
			<description><![CDATA[<p><font size="2">第三章 应用服务器的安装调整</font></p>
<p><font size="2">比较奇怪的是weblogic11g，小版本号是weblogic10.3.2.</font></p>
<p><font size="2"><strong>weblogic10.3安装</strong></font></p>
<p><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">可选图形化界面安装或者字符集安装。</span></font></p>
<p><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">#./opt/java6/bin/java -jar server103_generic.jar</span></font></p>
<p><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装过程略，下一步下一步即可。</span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290941"></a><a name="_Toc248224963"><span style="mso-bookmark: _Toc248290941"><span lang="EN-US"><font face="Calibri" size="2">SEE 6.1GA </font></span></span></a><span style="mso-bookmark: _Toc248224963"><span style="mso-bookmark: _Toc248290941"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">安装</font></span></span></span></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装</span><span lang="EN-US"><font face="Calibri">EOS6.1GA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，需安装</span><span lang="EN-US"><font face="Calibri">xmanger</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，通过图形化界面安装。注意安装文件对应目录的剩余空间。因启动一般使用</span><span lang="EN-US"><font face="Calibri">nohup</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的方式启动，防止由于控制台输出过大导致应用错误。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#dbf</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">该命令可以查询对应的文件夹下剩余的空间</font></span></p>
<h3 style="margin: 13pt 0cm; line-height: 150%"><a name="_Toc248290942"></a><a name="_Toc248224964"><span style="mso-bookmark: _Toc248290942"><span lang="EN-US"><font face="Calibri" size="2">SEE 6.1GA JVM</font></span></span></a><span style="mso-bookmark: _Toc248224964"><span style="mso-bookmark: _Toc248290942"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">参数调整</font></span></span></span></h3>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">1．</font><span style="font: 7pt &quot;Times New Roman&quot;">&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">最好是使用对应的应用服务器对应的</span><span lang="EN-US"><font face="Calibri">JVM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。该配置在</span><span lang="EN-US"><font face="Calibri">startServer.sh</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中更改。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: -18pt; line-height: 150%; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><font size="2"><span lang="EN-US" style="mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"><span style="mso-list: Ignore"><font face="Calibri">2．</font><span style="font: 7pt &quot;Times New Roman&quot;">&nbsp; </span></span></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">根据应用的类型，需调整</span><span lang="EN-US"><font face="Calibri">JVM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的垃圾回收机制。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">本次应用配置如下：</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">MEM_ARGS=&quot;-Xms2560m&nbsp;-Xmx2560m&nbsp;-Xoptgc&nbsp;-XX:+AggressiveOpts&nbsp;-XX:+DisableExplicitGC&nbsp;-XX:MaxPermSize=256m&nbsp;-Xloggc:gclog.log&nbsp;-XX:+PrintGC<o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">Details&nbsp;-XX:+PrintGCTimeStamps&quot;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">MEM_ARGS=&quot;$MEM_ARGS&nbsp;-Dsun.rmi.dgc.client.gcInterval=3600000&nbsp;-Dsun.rmi.dgc.server.gcInterval=360000&quot;</span></p>
<p>&nbsp;</p>]]></description>
			<link>http://blog.astring.net//show-645-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 11:22</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-644-1.html</guid>
			<title>基于HP-UX的一次测试调整（二）</title>
			<author>string</author>
			<description><![CDATA[<p><font size="2">第二章 数据库安装调整</font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290937"></a><a name="_Toc248224959"><span style="mso-bookmark: _Toc248290937"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">数据库安装</font></span></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span><span style="mso-spacerun: yes">&nbsp;</span></font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">建立</span><span lang="EN-US"><font face="Calibri">oracle</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">用户属于</span><span lang="EN-US"><font face="Calibri">dba group</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span># groupadd dba </font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># useradd -g dba oracle </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># passwd oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># mkdir &ndash;p /oracle/product/10.2/db_1 </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># chown -R oracle:dba /opt/oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">此命令和</span><span lang="EN-US"><font face="Calibri">linux</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">有所不同，请注意。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">由于我们需要图形化安装，此处还需要设置环境变量。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#vi /home/oracle/.dtprofile </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export ORACLE_BASE=/opt/oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export ORACLE_HOME=/oracle/product/10.2/db_1 </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export ORACLE_SID=new </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export ORACLE_TERM=xterm </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export NLS_LANG=AMERICAN </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#<font style="background-color: #ffcc00">LD_LIBRARY_PATH=$ORACLE_HOME/jdk/fre/lib/i386:</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font style="background-color: #ffcc00" face="Calibri" size="2">$ORACLE_HOME/jdk/jre/lib/i386/server:$ORACLE_HOME/rdbms/lib:</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"><font style="background-color: #ffcc00">$ORACLE_HOME/lib:$LD_LIBRARY_PATH</font> </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export LD_LIBRARY_PATH </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2">#export PATH=$ORACLE_HOME/bin:$PATH </font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装</span><span lang="EN-US"><font face="Calibri">Xmanager </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在本机。启动</span><span lang="EN-US"><font face="Calibri">Xmanager &ndash; Passive</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><font face="Calibri" size="2">#export DISPLAY=10.10.3.151:0</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><font face="Calibri"><font size="2"># runinstaller -ignoresysprereqs <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span></font></font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span lang="EN-US"><font face="Calibri">Oracle </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装文件会验证</span><span lang="EN-US"><font face="Calibri">HP-UX</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的版本号，所以需要加上</span><span lang="EN-US"><font face="Calibri">ignoresysprereqs</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">参数</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">图形化安装，安装时可以同时创建数据库。</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">选择通用安装即可。</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装到一定的程度的时候，会要求以</span><span lang="EN-US"><font face="Calibri">root</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的身份执行</span><span lang="EN-US"><font face="Calibri">2</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个脚本：</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 15.75pt; line-height: 150%; mso-char-indent-count: 1.5"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;</span>$ su root </font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># /oracle/oraInventory/orainstRoot.sh </font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><span lang="EN-US"><font face="Calibri" size="2"># /oracle/product/10.2/db_1/root.sh</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 21pt; line-height: 150%; mso-char-indent-count: 2.0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">安装过程不出现错误，默认情况下，</span><span lang="EN-US"><font face="Calibri">em </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">会启动起来。</span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290938"></a><a name="_Toc248224960"><span style="mso-bookmark: _Toc248290938"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">数据库参数调整</font></span></span></a></h3>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">如果命令行不熟悉，可以使用</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在默认安装下会直接启动起来。访问方式</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><a href="http://10.10.3.151:1158/em"><font face="Calibri" color="#800080" size="2">http://10.10.3.151:1158/em</font></a></span><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">或者</span><span lang="EN-US"><font face="Calibri">https//10.10.3.151:1158/em</font></span></font></p>
<h4 style="margin: 14pt 0cm 14.5pt"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">修改</span><span lang="EN-US"><font face="Cambria">sga</font></span><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">，</span><span lang="EN-US"><font face="Cambria">pga</font></span><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">的参数。</span></font></h4>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">查看机器信息</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><font face="Calibri" size="2">#machinfo</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">&hellip;&hellip;</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US"><font face="Calibri" size="2">Memory: 12219 MB (11.93 GB)</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">&hellip;&hellip;</font></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">得出数据库应用服务器的内存为</span><span lang="EN-US"><font face="Calibri">12</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个</span><span lang="EN-US"><font face="Calibri">G</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">独立应用服务器一般建议</span><span lang="EN-US"><font face="Calibri">SGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小为应用服务器内存总量的</span><span lang="EN-US"><font face="Calibri">40%</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。由于本次的应用测试的数据库操作相对简单，而且本次的数据库服务器上需要运行我们的</span><span lang="EN-US"><font face="Calibri">BTF</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的模拟主机，不属于独立应用服务器，该模拟主机需占用</span><span lang="EN-US"><font face="Calibri">1024M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">内存，所以在这里，我们给出了</span><span lang="EN-US"><font face="Calibri">SGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小为</span><span lang="EN-US"><font face="Calibri">3648M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，</span><span lang="EN-US"><font face="Calibri">PGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小与并发的数据库连接有关，数据操作频繁但数据量不大的情况下，每个用户占用内存</span><span lang="EN-US"><font face="Calibri">3-5M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">左右，基于此点，我们给定的</span><span lang="EN-US"><font face="Calibri">PGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小为</span><span lang="EN-US"><font face="Calibri">1211M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">此参数在</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中可以很方便的调整。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><span lang="EN-US" style="mso-no-proof: yes"><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"><font size="2"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></v:path><o:lock v:ext="edit" aspectratio="t"></o:lock></font></v:shapetype></span></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">内存参数，既可以调整</span><span lang="EN-US"><font face="Calibri">SGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">和</span><span lang="EN-US"><font face="Calibri">PGA</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">如果</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">没有启动，只能用命令行修改。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#su &ndash; oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">$SQLplus /nolog</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt;conn /as sysdba</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">system</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">set</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span></font><a name="UIDataSource:0:3"><span lang="EN-US" style="font-size: 10pt; color: black; line-height: 150%"><font face="Calibri">sga_target</font></span></a><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = &rsquo;3648M&rsquo;<span style="mso-spacerun: yes">&nbsp; </span></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">scope</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">spfile</span><span lang="EN-US" style="font-size: 10pt; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">system</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">set</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span></font><a name="UIDataSource:0:0"><span lang="EN-US" style="font-size: 10pt; color: black; line-height: 150%"><font face="Calibri">pga_aggregate_target</font></span></a><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = &rsquo;3648M&rsquo;<span style="mso-spacerun: yes">&nbsp; </span></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">scope</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">spfile</span></p>
<h4 style="margin: 14pt 0cm 14.5pt"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">修改</span><span lang="EN-US"><font face="Cambria">processes</font></span><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">和</span><span lang="EN-US"><font face="Cambria">sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">的大小。</span></font></h4>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">Processes </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">对应的是</span><span lang="EN-US"><font face="Calibri">oracle</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">对外的进程数量，比如应用服务器的连接池需要发起</span><span lang="EN-US"><font face="Calibri">350</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个连接，对应的</span><span lang="EN-US"><font face="Calibri">processes</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">即为</span><span lang="EN-US"><font face="Calibri">350.</font></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">Sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">对应的</span><span lang="EN-US"><font face="Calibri">oracle</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">对外的回话数，没有全部启用事务的应用，一次数据库操作即会占用一个</span><span lang="EN-US"><font face="Calibri">sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。所以</span><span lang="EN-US"><font face="Calibri">sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">需要做适量的调整。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在</span><span lang="EN-US"><font face="Calibri">em</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中调整如下：</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2">&nbsp;</font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">所有初始化参数，即可看到</span><span lang="EN-US"><font face="Calibri">processes</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">和</span><span lang="EN-US"><font face="Calibri">sessions</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">如果</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">没有启动，只能用命令行修改。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#su &ndash; oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">$SQLplus /nolog</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt;conn /as sysdba</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">system</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">set</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; color: black; line-height: 150%"><font face="Calibri">processes</font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = 800<span style="mso-spacerun: yes">&nbsp; </span></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">scope</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">spfile</span><span lang="EN-US" style="font-size: 10pt; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 17.95pt; text-indent: 5.25pt; line-height: 150%; mso-char-indent-count: .5; mso-para-margin-left: 1.71gd"><font size="2"><span lang="EN-US"><font face="Calibri">SQL&gt; </font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">system</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">set</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; color: black; line-height: 150%"><font face="Calibri">sessions</font></span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = 880<span style="mso-spacerun: yes">&nbsp; </span></span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">scope</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> = </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">spfile</span></font></p>
<h4 style="margin: 14pt 0cm 14.5pt"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Cambria; mso-ascii-theme-font: major-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: major-fareast; mso-hansi-font-family: Cambria; mso-hansi-theme-font: major-latin">修改</span><span lang="EN-US"><font face="Cambria">redo.log</font></span></font></h4>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">Oracle</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的数据库日志称为</span><span lang="EN-US"><font face="Calibri">redo log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，所有数据改变都记录</span><span lang="EN-US"><font face="Calibri">redo log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，可以用于修复受损的数据库。所有的数据改变均需要记录</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，所以</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的大小，磁盘</span><span lang="EN-US"><font face="Calibri">IO</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">均有一定的讲究。强烈建议把</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">放置在</span><span lang="EN-US"><font face="Calibri">IO</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">最好的存储中。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在</span><span lang="EN-US"><font face="Calibri">em</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中，修改如下</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2">&nbsp;</font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">重做日志组。即可看到目前的所有</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">可以直接添加。一般情况需要</span><span lang="EN-US"><font face="Calibri">3</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个</span><span lang="EN-US"><font face="Calibri">512M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。如果大小不对，可以添加</span><span lang="EN-US"><font face="Calibri">3</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">个</span><span lang="EN-US"><font face="Calibri">512M</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，删除大小不符合要求的</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">即可。删除之前需让要删除的</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">处于</span><span lang="EN-US"><font face="Calibri">inactive</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的状态。</span></font></p>
<p class="MsoListParagraph" style="margin: 0cm 0cm 0pt 18pt; text-indent: 0cm; line-height: 150%; mso-char-indent-count: 0"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">如果</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">没有启动，只能用命令行修改。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">#su &ndash; oracle</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent: 20.25pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">$SQLplus /nolog</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">SQL&gt;conn /as sysdba</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">SQL</font></span><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">&gt; select member from v$logfile;<o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-size: 9pt; color: #333333; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Tahoma; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">查看所有的</span><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">redo.log file</span><span style="font-size: 9pt; color: #333333; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Tahoma; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。</span><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">SQL&gt; alter database add logfile group 4 (' /oracle/oradata/new/redo04.log') size 512m;<br />
</span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">添加一个</span><span lang="EN-US"><font face="Calibri">redo.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">SQL&gt; </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">system</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">switch</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">logfile</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">;</span><span lang="EN-US" style="font-size: 10pt; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-size: 9pt; color: #333333; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Tahoma; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">切换到下一个</span><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">redo</span><span lang="EN-US"><font face="Calibri">.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">SQL&gt;</span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">alter</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">database</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">drop</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">logfile</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: teal; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">group</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white"> </span><span lang="EN-US" style="font-size: 10pt; background: white; color: blue; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">1</span><span lang="EN-US" style="font-size: 10pt; background: white; color: navy; line-height: 150%; font-family: &quot;Courier New&quot;; mso-font-kerning: 0pt; mso-highlight: white">;</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><font size="2"><span style="font-size: 9pt; color: #333333; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Tahoma; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">即可删除上一个使用的</span><span lang="EN-US" style="font-size: 9pt; color: #333333; line-height: 150%; font-family: &quot;Tahoma&quot;,&quot;sans-serif&quot;">redo</span><span lang="EN-US"><font face="Calibri">.log</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt 18pt; line-height: 150%"><span lang="EN-US"><o:p></o:p></span></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290939"></a><a name="_Toc248224961"><span style="mso-bookmark: _Toc248290939"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">数据库监控</font></span></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp; 在</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中，有一组每隔一个小时自动抓取一次的快照，可以使用快照分析。如下：</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">&nbsp;&nbsp; 快照，即可看到最新的快照。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">&nbsp;&nbsp; 选中需要查看的报告，点击分析，可以看到一份报告。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp; 查看</span><span lang="EN-US"><font face="Calibri">SQL ordered by CPU Time </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">即可看到那些</span><span lang="EN-US"><font face="Calibri">SQL</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">最占用内存。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">&nbsp;&nbsp; 一般情况下，可以不用分析快照。</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp; 当</span><span lang="EN-US"><font face="Calibri">CPU</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的使用达到了一个峰值，在该分析报告中，可以跟踪到对应的</span><span lang="EN-US"><font face="Calibri">SQL</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp; 如果</span><span lang="EN-US"><font face="Calibri">EM</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">没有启动，只能用命令行去生成报告。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $cd<span style="mso-spacerun: yes">&nbsp; </span></font></span><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">${oracle_home}/rdbms/admin<o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp; $SQLplus /nolog<o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp; SQL&gt;conn /as sysdba<o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp; SQL&gt;@spcreate.SQL<o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="font-size: 10pt; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Verdana; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Verdana">&nbsp;&nbsp;&nbsp;此命令行会需要输入</span><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">perfstat</span><span style="font-size: 10pt; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Verdana; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Verdana">的密码，默认密码为</span><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;">perfstat</span><span style="font-size: 10pt; line-height: 150%; font-family: 宋体; mso-ascii-font-family: Verdana; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Verdana">。</span><span lang="EN-US" style="font-size: 10pt; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;SQL&gt; exec statspack.snap;</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp;&nbsp;隔几分钟后，具体看压力和数据库的</span><span lang="EN-US"><font face="Calibri">CPU</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">反应。再次执行。</span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL&gt; exec statspack.snap;</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><span lang="EN-US"><font face="Calibri" size="2">&nbsp;&nbsp;&nbsp;&nbsp; SQL&gt; @spreport</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">&nbsp;&nbsp;需要选择起至的快照。选择</span><span lang="EN-US"><font face="Calibri">ok</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，需要输入文件名，即可查看文字版本的报告。</span></font></p>
<p><font size="2"><span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">&nbsp; 同理，查看</span><span lang="EN-US" style="font-size: 10.5pt; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">SQL ordered by CPU Time </span><span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">即可看到那些</span><span lang="EN-US" style="font-size: 10.5pt; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">SQL</span><span style="font-size: 10.5pt; font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">最占用内存。</span></font></p>]]></description>
			<link>http://blog.astring.net//show-644-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 11:10</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-643-1.html</guid>
			<title>基于HP-UX的一次测试调整（一）</title>
			<author>string</author>
			<description><![CDATA[<p><font size="2">本次调整不算系统级别的调优，只是让系统处于一个稳定运行的状态，能支持1000在线，1.5S的思考时间的并发，基于RMI，TCP（短连接），WTC协议模拟压力的调整。分五章说明本次调整的方法和原因。</font></p>
<p><font size="2">第一章 全局操作系统内核参数的调整</font></p>
<p><strong><font size="2">硬件说明</font></strong></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri" size="2">CPU info:</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp; </span>4 Intel(R) Itanium 2 processors (1.3 GHz, 3 MB)</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>400 MT/s bus, CPU version B1</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><o:p><font face="Calibri" size="2">&nbsp;</font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri" size="2">Memory: 4027 MB (3.93 GB)应用服务器/<span lang="EN-US" style="font-size: 10.5pt; font-family: 宋体; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><span style="mso-spacerun: yes">&nbsp;</span>12219 MB (11.93 GB)<font size="2">数据库服务器</font></span></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><o:p><font face="Calibri" size="2">&nbsp;</font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri" size="2">Firmware info:</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Firmware revision:<span style="mso-spacerun: yes">&nbsp; </span>006.044</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>FP SWA driver revision: 1.18</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>IPMI is supported on this system.</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>BMC firmware revision: 8.05</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><o:p><font face="Calibri" size="2">&nbsp;</font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri" size="2">Platform info:</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Model:<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>&quot;ia64 hp server rx7620&quot;</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Machine ID number:<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>5981791c-1f2e-11db-b3ef-e251099a55e7</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Machine serial number:<span style="mso-spacerun: yes">&nbsp; </span>SGH4626D96</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><o:p><font face="Calibri" size="2">&nbsp;</font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri" size="2">OS info:</font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Nodename:<span style="mso-spacerun: yes">&nbsp; </span>rx7620</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Release:<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>HP-UX B.11.31</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Version:<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>U (unlimited-user license)</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>Machine:<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>ia64</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>ID Number: 1501657372</font></font></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt"><span lang="EN-US"><font face="Calibri"><font size="2"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span>vmunix _release_version:<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></font></span></p>
<p><span lang="EN-US" style="font-size: 10.5pt; font-family: &quot;Calibri&quot;,&quot;sans-serif&quot;; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><font size="2">@(#) $Revision: vmunix:<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>B.11.31_LR FLAVOR=perf</font></span></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290934"></a><a name="_Toc248224956"><span style="mso-bookmark: _Toc248290934"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">调整说明</font></span></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">基于</span><span lang="EN-US"><font face="Calibri">HP-UX</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的操作系统调优，</span><span lang="EN-US"><font face="Calibri">*NUX</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">系列调整大同小异。本次调整正对应用服务器和数据库服务器，根据并发数，内存分配，场景要求有相关对应。</span></font></p>
<h3 style="margin: 13pt 0cm"><a name="_Toc248290935"></a><a name="_Toc248224957"><span style="mso-bookmark: _Toc248290935"><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin"><font size="2">需调整的内核参数说明</font></span></span></a></h3>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">maxdsiz</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">、</span><span lang="EN-US"><font face="Calibri">maxssiz</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">和</span><span lang="EN-US"><font face="Calibri">maxtsiz </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">这些参数是所有</span><span lang="EN-US"><font face="Calibri">HP-UX </font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">用户进程的三个基本的组成部分（数据、堆栈和文本段）</span><font face="Calibri"> </font><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">单位：</span><span lang="EN-US"><font face="Calibri">byte</font></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US"><font face="Calibri">Maxuprc</font></span><span style="font-family: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，</span><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">单个用户最大并发进程数</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">max_thread_proc </span><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">单个进程最大并发线程数</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">本次测试，数据库需要接受</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">weblogic</span><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">的连接池配置</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">100-350</span><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">的连接。</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span style="color: black; font-family: 宋体; mso-ascii-font-family: Arial; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">我们更改以上的参数</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">#</span><span lang="EN-US" style="font-size: 10pt; color: silver; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;; mso-bidi-font-family: 宋体"> </span><font face="Calibri"><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt">kctune -h maxdsiz=&quot;</span><span lang="EN-US"> </span><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt">4294967296&quot; <o:p></o:p></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">#</span><span lang="EN-US" style="font-size: 10pt; color: silver; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;; mso-bidi-font-family: 宋体"> </span><font face="Calibri"><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt">kctune -h </span><span lang="EN-US">Maxuprc</span><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt"> =&quot;1024&quot;</span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; line-height: 150%"><font size="2"><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">#</span><span lang="EN-US" style="font-size: 10pt; color: silver; line-height: 150%; font-family: &quot;Verdana&quot;,&quot;sans-serif&quot;; mso-bidi-font-family: 宋体"> </span><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt"><font face="Calibri">kctune -h </font></span><span lang="EN-US" style="color: black; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;">max_thread_proc</span><span lang="EN-US" style="line-height: 150%; mso-bidi-font-size: 10.5pt"><font face="Calibri"> =&quot;2048&quot;</font></span></font></p>]]></description>
			<link>http://blog.astring.net//show-643-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-12-11 11:01</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-633-1.html</guid>
			<title>linux,eos,weblogic,性能测试</title>
			<author>string</author>
			<description><![CDATA[<p>自己机器的wiki已经完成了架设的过程，并已经启用了，我会把自己的工作过程和遇到的问题作为tip记录下来，积累和提高。</p>
<p><br />
---------------eos for weblogic的默认安装-----------------</p>
<p>访问console，默认的用户名/密码为&nbsp; system/eosversion</p>
<p>--------------强制杀进程-------------</p>
<p>kill -9 pid</p>
<p>--------------too many open file 文件句柄超出-------------</p>
<p>在使用linux服务器做web应用服务器时，linux默认的对外file连接数量为1024. 也就是说，如果做压力测试的话（偶就是搞这个的），一定需要修改对外的tcp链接数量。</p>
<p>一般这种错误，对应的是日志中的<strong>too money open file</strong>.</p>
<p>在Linux下，我们使用ulimit -n 命令可以看到单个进程能够打开的最大文件句柄数量(socket连接也算在里面)。系统默认值1024。对于一般的应用来说(象Apache、系统进程)1024完全足够使用。但是如何象squid、mysql、java等单进程处理大量请求的应用来说就有点捉襟见肘了。如果单个进程打开的文件句柄数量超过了系统定义的值，就会提到&ldquo;too many files open&rdquo;的错误提示。如何知道当前进程打开了多少个文件句柄呢？下面一段小脚本可以帮你查看：</p>
<p>lsof -n |awk '{print $2}'|sort|uniq -c |sort -nr|more 在系统访问高峰时间以root用户执行上面的脚本，可能出现的结果如下：</p>
<p># lsof -n|awk '{print $2}'|sort|uniq -c |sort -nr|more</p>
<pre class="code">131 24204   
   57 24244   
   57 24231   
   56 24264</pre>
<p>其中第一行是打开的文件句柄数量，第二行是进程号。得到进程号后，我们可以通过ps命令得到进程的详细内容。</p>
<p>ps -aef|grep 24204 即可查看对应的进程。</p>
<p>但是如果系统并发特别大，尤其是squid服务器，很有可能会超过1024。这时候就必须要调整系统参数，以适应应用变化。Linux有硬性限制和软性限制。可以通过ulimit来设定这两个参数。方法如下，以root用户运行以下命令：</p>
<p>ulimit -HSn 4096 以上命令中，H指定了硬性大小，S指定了软性大小，n表示设定单个进程最大的打开文件句柄数量。个人觉得最好不要超过4096，毕竟打开的文件句柄数越多响应时间肯定会越慢。设定句柄数量后，系统重启后，又会恢复默认值。如果想永久保存下来，可以修改 /etc/profile 把上面命令加到最后。</p>
<p>当然，也不建议过多，会对资源有所损耗。 由于我是上的300虚拟用户，我直接给当前连接窗口给开到了10240。<img alt="" border="0" src="http://blog.astring.net/images/smiles/teeth.gif" /></p>
<p>----------------------远程连接相关----------------</p>
<p>用 nohup ./startServer.sh启动服务，可以断掉链接，服务存在。</p>
<p>----------------load runner相关设置--------------</p>
<p>巧用参数生成123456000000到123456150000的编号。设定如下：</p>
<p><a href="http://blog.astring.net//attachment.php?id=82" target="_blank"><img src="http://blog.astring.net//attachments/date_200907/thumb_11de444a8a0694f31b1134664608d029.jpg" border="0" alt="大小: 44.35 K&#13;尺寸: 400 x 356&#13;浏览: 24 次&#13;点击打开新窗口浏览全图" width="400" height="356" /></a></p>
<p>图中的100对应着我的100 vuser的并发。这样设置的意思，到最后就能100并发，生成123456000000到123456150000并且不重复。</p>
<p>-----------------web service压力测试注意------------------</p>
<p>听GZ说起，一个注意点。</p>
<p>获取连接的时候，应该把获取连接的方法提取到静态方法中，不能每次动态获取连接。</p>
<p>不然压力上去，性能就下来了，做个笔记。</p>
<p>---------------------------------------------------------</p>
<p>破解的8.1，100 vuser，一个controller能管理多个clinent，但是并发用户总数还是不能超过100，还需要手工合并压测数据，真晕。</p>]]></description>
			<link>http://blog.astring.net//show-633-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-07-29 23:47</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-622-1.html</guid>
			<title>索引的基本原理，以及数据是如何被访问的</title>
			<author>string</author>
			<description><![CDATA[<p>（一）SQLS如何访问没有建立索引的数据表</p>
<p>（二）SQLS如何访问建立了非聚集索引的数据表</p>
<p>（三）SQLS如何访问建立聚集索引的数据表</p>
<p>（四）SQLS如何访问既有聚集索引、又有非聚集索引的数据表</p>
<p>索引的优点和不足</p><br /><br /><a href="http://blog.astring.net//show-622-1.html" target="_blank">阅读全文</a><br /><br />]]></description>
			<link>http://blog.astring.net//show-622-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2009-06-28 10:42</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-554-1.html</guid>
			<title>基础不扎实，做人要诚实</title>
			<author>string</author>
			<description><![CDATA[<p>昨天输出rss的xml文件。</p>
<p>在jsp中，用java调用biz，得到返回的值。</p>
<p>结果头上引入了太多的包，在头上输出了太多的空格。</p>
<p>我想，这些空格是没法去掉的。经验使然。</p>
<p>做了3年的j2ee，在查看源文件的时候，常发现有这个问题。</p>
<p>于是也没有深究，堂而皇之的说不能去掉。</p>
<p>结果是，下班回宾馆之后，一个写.NET的人，给找到了方法。</p>
<p>并且还不只一种！</p>
<p>记录如下：</p>
<p><code><span style="color: #000000">
<span style="color: #0000BB">out</span><span style="color: #007700">.</span><span style="color: #0000BB">clear</span><span style="color: #007700">();</span><span style="color: #0000BB"></span>
</span>
</code></p>
<p><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">&lt;?</span><span style="color: #0000BB">xml&nbsp;version</span><span style="color: #007700">=</span><span style="color: #DD0000">"1.0"&nbsp;</span><span style="color: #0000BB">encoding</span><span style="color: #007700">=</span><span style="color: #DD0000">"gb2312"&nbsp;</span><span style="color: #0000BB">standalone</span><span style="color: #007700">=</span><span style="color: #DD0000">"no"</span><span style="color: #0000BB">?&gt;</span></span>
</code></p>
<p>呵，看样子基础不扎实的时候，做人一定要诚实。</p>
<p>不会就是不会，别说不能实现，搞得人品好像很不好的样子。</p>]]></description>
			<link>http://blog.astring.net//show-554-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2008-05-20 08:42</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-552-1.html</guid>
			<title>JAVA调用biz</title>
			<author>string</author>
			<description><![CDATA[<p><code><span style="color: #000000">
<span style="color: #0000BB">String&nbsp;xml&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">"&lt;?xml&nbsp;version=\"1.0\"&nbsp;encoding=\"GB2312\"&nbsp;standalone=\"no\"?&gt;&lt;root&gt;&lt;data&gt;&lt;PageCond&gt;&lt;length&gt;"<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">rowNum<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #DD0000">"&lt;/length&gt;&lt;/PageCond&gt;&lt;SessionEntity&gt;&lt;userID&gt;"<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">+&nbsp;</span><span style="color: #0000BB">userID<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">+</span><span style="color: #DD0000">"&lt;/userID&gt;&lt;/SessionEntity&gt;&lt;/data&gt;&lt;/root&gt;"</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">//构造xml<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Document&nbsp;inDom&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">XmlUtil</span><span style="color: #007700">.</span><span style="color: #0000BB">parseString</span><span style="color: #007700">(</span><span style="color: #0000BB">xml</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ProcessCaller&nbsp;pc&nbsp;</span><span style="color: #007700">=&nbsp;new&nbsp;</span><span style="color: #0000BB">ProcessCaller</span><span style="color: #007700">(</span><span style="color: #DD0000">"tm_aqyh"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"0"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"-1"</span><span style="color: #007700">,</span><span style="color: #DD0000">"defaultAppID"</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Document&nbsp;doc&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">pc</span><span style="color: #007700">.</span><span style="color: #0000BB">implement</span><span style="color: #007700">(</span><span style="color: #DD0000">"bizAlldo.bizAlldoXml"</span><span style="color: #007700">,</span><span style="color: #0000BB">inDom</span><span style="color: #007700">);</span><span style="color: #0000BB"></span>
</span>
</code></p>
<p>最后拿到的doc就是调用biz bizAlldo.bizAlldoXml返回的值。</p>
<p>我们可以直接java中调用写好的biz。</p>]]></description>
			<link>http://blog.astring.net//show-552-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2008-05-19 16:53</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-534-1.html</guid>
			<title>CAS单点登陆实例实现</title>
			<author>string</author>
			<description><![CDATA[<p>下面我们以 tomcat 5.0 作为 CAS Server(server1) ，另外一台 tomcat5.0 为 client(client1)</p>
<p>为例进行说明。</p>
<p>1. 下载 cas-server 和 cas-client( 可选，建议使用）</p>
<p><a href="http://www.ja-sig.org/downloads/cas/cas-server-3.0.5.zip">http://www.ja-sig.org/downloads/cas/cas-server-3.0.5.zip</a></p>
<p><a href="http://www.ja-sig.org/downloads/cas-clients/cas-client-java-2.1.1.zip">http://www.ja-sig.org/downloads/cas-clients/cas-client-java-2.1.1.zip</a></p>
<p>2. 将 cas-server-3.0.5.zip 解压，并将 lib/cas.war 拷贝到 server1 的 webapps 下</p>
<p>3. 产生 SERVER 的证书</p>
<p>PS: 参数与各系统本身一致</p>
<p>%JAVA_HOME%\bin\keytool -delete -alias tomcat -keypass changeit</p>
<p>%JAVA_HOME%\bin\keytool -genkey -alias tomcat -keypass changeit -keyalg RSA</p>
<p>%JAVA_HOME%\bin\keytool -export -alias tomcat -keypass changeit&nbsp; -file %FILE_NAME%</p>
<p>%JAVA_HOME%\bin\keytool -import -file server.crt -keypass changeit -keystore %JAVA_HOME%/jre/lib/security/cacerts</p>
<p>%JAVA_HOME%\bin\keytool -import -file server.crt -keystore %JAVA_HOME%\jre\lib\security\cacerts</p>
<p>4. 在 server1 配置 tomcat 使用 HTTPS</p>
<p>$CATALINA_HOME/conf/server.xml 里</p>
<p>&lt;Connector className=&quot;org.apache.coyote.tomcat5.CoyoteConnector&quot;</p>
<p>port=&quot;8443&quot; minProcessors=&quot;5&quot; maxProcessors=&quot;75&quot;</p>
<p>enableLookups=&quot;true&quot; disableUploadTimeout=&quot;true&quot;</p>
<p>acceptCount=&quot;100&quot; debug=&quot;0&quot; scheme=&quot;https&quot;</p>
<p>secure=&quot;true&quot;&gt;</p>
<p>&lt;Factory className=&quot;org.apache.coyote.tomcat5.CoyoteServerSocketFactory&quot;</p>
<p>keystoreFile=&quot;/path/to/your/keystore-file&quot;</p>
<p>keystorePass=&quot;your-password&quot; clientAuth=&quot;false&quot; protocol=&quot;TLS&quot; /&gt;</p>
<p>&lt;/Connector&gt;</p>
<p>5. 在要使用 CAS 的客户端 client1 里设置（以 servlets-examples 这个 APP 为例），我们使用</p>
<p>ServletFilter(CAS client 里提供的 ) 来实现 SSO 的检查。</p>
<p>修改 servlets-examples/WEB-INF/web.xml</p>
<p>&lt;filter&gt;</p>
<p>&lt;filter-name&gt;CASFilter&lt;/filter-name&gt;</p>
<p>&lt;filter-class&gt;edu.yale.its.tp.cas.client.filter.CASFilter&lt;/filter-class&gt;</p>
<p>&lt;init-param&gt;</p>
<p>&lt;param-name&gt;edu.yale.its.tp.cas.client.filter.loginUrl&lt;/param-name&gt;</p>
<p>&lt;param-value&gt;https://your.cas.server.name(eg:server1):port/cas/login&lt;/param-value&gt;</p>
<p>&lt;/init-param&gt;</p>
<p>&lt;init-param&gt;</p>
<p>&lt;param-name&gt;edu.yale.its.tp.cas.client.filter.validateUrl&lt;/param-name&gt;</p>
<p>&lt;param-value&gt;https://your.cas.server.name(eg:server1):port/cas/proxyValidate&lt;/param-value&gt;</p>
<p>&lt;/init-param&gt;</p>
<p>&lt;init-param&gt;</p>
<p>&lt;param-name&gt;edu.yale.its.tp.cas.client.filter.serviceUrl&lt;/param-name&gt;</p>
<p>&lt;param-value&gt;your.client.server.ip(eg:127.0.0.1):port&lt;/param-value&gt;</p>
<p>&lt;/init-param&gt;</p>
<p>&lt;/filter&gt;</p>
<p>&lt;filter-mapping&gt;</p>
<p>&lt;filter-name&gt;CASFilter&lt;/filter-name&gt;</p>
<p>&lt;url-pattern&gt;/servlet/*&lt;/url-pattern&gt;</p>
<p>&lt;/filter-mapping&gt;</p>
<p>PS: 在 client 端配置 filter 时 , 需要将 CAS 的 filter 放在 web.xml 最上端 ,. 如果在你的 web.xml 有类似 encodingFilter 的 filter 也需要将这个 filter 放在 CAS filter 下面 , 否则你会发现每次访问时都需要你进行验证 。</p>
<p>6. 将 cas-client-java-2.1.1.zip 解压，把 java/lib/casclient.jar 拷贝到 client1 服务器上的</p>
<p>webapps/servlets-examples/WEB-INF/lib 目录下（如果没有就建一个）</p>
<p>7. 导出 SERVER 的证书，用来给所有需要用到的客户端导入</p>
<p>keytool -export -file server.crt -alias my-alias-name -keystore keystore-file</p>
<p>8. 在客户端的 JVM 里导入信任的 SERVER 的证书 ( 根据情况有可能需要管理员权限 )</p>
<p>keytool -import -keystore $JAVA_HOME/jre/lib/security/cacerts -file server.crt -alias my-alias-name</p>
<p>9.test &amp; done.</p>
<p>把 server1 和 client1 分别起来，检查启动的 LOG 是否正常，如果一切 OK ，就访问</p>
<p><a href="http://client1:8080/servlets-examples/servlet/HelloWorldExample">http://client1:8080/servlets-examples/servlet/HelloWorldExample</a></p>
<p>系统会自动跳转到一个验证页面，随便输入一个相同的账号 , 密码，验证通过之后就会访问</p>
<p>到真正的 HelloWorldExample 这个 servlet 了</p>
<p>实现自已的认证代码 (java 代码和相关注释 , 需要 cas-server-3.0.5.jar 包 )</p>
<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; word-break: break-all; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee"><img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /> <span style="color: #0000ff">package</span> <span style="color: #000000">&nbsp;com.mcm.sso;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /></span> <span style="color: #0000ff">import</span> <span style="color: #000000">&nbsp;org.jasig.cas.authentication.handler.support.AbstractUsernamePasswordAuthenticationHandler;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /></span> <span style="color: #0000ff">import</span> <span style="color: #000000">&nbsp;org.jasig.cas.authentication.principal.UsernamePasswordCredentials;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /></span> <span style="color: #0000ff">import</span> <span style="color: #000000">&nbsp;org.springframework.util.StringUtils;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /></span> <span style="color: #0000ff">public</span> <span style="color: #000000">&nbsp;</span> <span style="color: #0000ff">class</span> <span style="color: #000000">&nbsp;MyUsernamePasswordAuthenticationHandler&nbsp;</span> <span style="color: #0000ff">extends</span> <span style="color: #000000">&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img id="Codehighlighter1_377_1253_Open_Image" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_377_1253_Open_Text.style.display='none'; Codehighlighter1_377_1253_Closed_Image.style.display='inline'; Codehighlighter1_377_1253_Closed_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gif" /><img id="Codehighlighter1_377_1253_Closed_Image" style="display: none" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_377_1253_Closed_Text.style.display='none'; Codehighlighter1_377_1253_Open_Image.style.display='inline'; Codehighlighter1_377_1253_Open_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AbstractUsernamePasswordAuthenticationHandler&nbsp;</span> <span id="Codehighlighter1_377_1253_Closed_Text" style="border-right: #808080 1px solid; border-top: #808080 1px solid; display: none; border-left: #808080 1px solid; border-bottom: #808080 1px solid; background-color: #ffffff"><img alt="" src="http://www.blogjava.net/Images/dot.gif" /> </span><span id="Codehighlighter1_377_1253_Open_Text"><span style="color: #000000">{&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">public</span> <span style="color: #000000">&nbsp;</span> <span style="color: #0000ff">boolean</span> <span style="color: #000000">&nbsp;authenticateUsernamePasswordInternal(&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img id="Codehighlighter1_514_1111_Open_Image" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_514_1111_Open_Text.style.display='none'; Codehighlighter1_514_1111_Closed_Image.style.display='inline'; Codehighlighter1_514_1111_Closed_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif" /><img id="Codehighlighter1_514_1111_Closed_Image" style="display: none" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_514_1111_Closed_Text.style.display='none'; Codehighlighter1_514_1111_Open_Image.style.display='inline'; Codehighlighter1_514_1111_Open_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">final</span> <span style="color: #000000">&nbsp;UsernamePasswordCredentials&nbsp;credentials)&nbsp;</span> <span id="Codehighlighter1_514_1111_Closed_Text" style="border-right: #808080 1px solid; border-top: #808080 1px solid; display: none; border-left: #808080 1px solid; border-bottom: #808080 1px solid; background-color: #ffffff"><img alt="" src="http://www.blogjava.net/Images/dot.gif" /> </span><span id="Codehighlighter1_514_1111_Open_Text"><span style="color: #000000">{&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">final</span> <span style="color: #000000">&nbsp;String&nbsp;username&nbsp;</span> <span style="color: #000000">=</span> <span style="color: #000000">&nbsp;credentials.getUsername();&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">final</span> <span style="color: #000000">&nbsp;String&nbsp;password&nbsp;</span> <span style="color: #000000">=</span> <span style="color: #000000">&nbsp;credentials.getPassword();&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #008000">//</span> <span style="color: #008000">&nbsp;此处实现你的登陆验证代码&nbsp;</span> <span style="color: #008000"><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /> </span><span style="color: #000000"><br />
<img id="Codehighlighter1_783_983_Open_Image" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_783_983_Open_Text.style.display='none'; Codehighlighter1_783_983_Closed_Image.style.display='inline'; Codehighlighter1_783_983_Closed_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif" /> <img id="Codehighlighter1_783_983_Closed_Image" style="display: none" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_783_983_Closed_Text.style.display='none'; Codehighlighter1_783_983_Open_Image.style.display='inline'; Codehighlighter1_783_983_Open_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">if</span> <span style="color: #000000">&nbsp;(StringUtils.hasText(username)&nbsp;</span> <span style="color: #000000">&amp;&amp;</span> <span style="color: #000000">&nbsp;StringUtils.hasText(password)&nbsp;)&nbsp;</span> <span id="Codehighlighter1_783_983_Closed_Text" style="border-right: #808080 1px solid; border-top: #808080 1px solid; display: none; border-left: #808080 1px solid; border-bottom: #808080 1px solid; background-color: #ffffff"><img alt="" src="http://www.blogjava.net/Images/dot.gif" /> </span><span id="Codehighlighter1_783_983_Open_Text"><span style="color: #000000">{&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;getLog().debug(&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">User&nbsp;[</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">&nbsp;</span> <span style="color: #000000">+</span> <span style="color: #000000">&nbsp;username&nbsp;</span> <span style="color: #000000">+</span> <span style="color: #000000">&nbsp;</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">]&nbsp;was&nbsp;successfully&nbsp;authenticated&nbsp;with&nbsp;ucix.</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">);&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">return</span> <span style="color: #000000">&nbsp;</span> <span style="color: #0000ff">true</span> <span style="color: #000000">;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span> </span><span style="color: #000000">&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;getLog().debug(</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">User&nbsp;[</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">&nbsp;</span> <span style="color: #000000">+</span> <span style="color: #000000">&nbsp;username&nbsp;</span> <span style="color: #000000">+</span> <span style="color: #000000">&nbsp;</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">]&nbsp;failed&nbsp;authentication</span> <span style="color: #000000">&quot;</span> <span style="color: #000000">);&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">return</span> <span style="color: #000000">&nbsp;</span> <span style="color: #0000ff">false</span> <span style="color: #000000">;&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span> </span><span style="color: #000000">&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img id="Codehighlighter1_1186_1249_Open_Image" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_1186_1249_Open_Text.style.display='none'; Codehighlighter1_1186_1249_Closed_Image.style.display='inline'; Codehighlighter1_1186_1249_Closed_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif" /><img id="Codehighlighter1_1186_1249_Closed_Image" style="display: none" alt="" align="top" onclick="this.style.display='none'; Codehighlighter1_1186_1249_Closed_Text.style.display='none'; Codehighlighter1_1186_1249_Open_Image.style.display='inline'; Codehighlighter1_1186_1249_Open_Text.style.display='inline';" src="http://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">protected</span> <span style="color: #000000">&nbsp;</span> <span style="color: #0000ff">void</span> <span style="color: #000000">&nbsp;afterPropertiesSetInternal()&nbsp;</span> <span style="color: #0000ff">throws</span> <span style="color: #000000">&nbsp;Exception&nbsp;</span> <span id="Codehighlighter1_1186_1249_Closed_Text" style="border-right: #808080 1px solid; border-top: #808080 1px solid; display: none; border-left: #808080 1px solid; border-bottom: #808080 1px solid; background-color: #ffffff"><img alt="" src="http://www.blogjava.net/Images/dot.gif" /> </span><span id="Codehighlighter1_1186_1249_Open_Text"><span style="color: #000000">{&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <span style="color: #0000ff">super</span> <span style="color: #000000">.afterPropertiesSetInternal();&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span> </span><span style="color: #000000">&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif" />}</span> </span><span style="color: #000000">&nbsp;<br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /><br />
<img alt="" align="top" src="http://www.blogjava.net/Images/OutliningIndicators/None.gif" /></span></div>
<p>&nbsp;</p>
<p>然后将这个类配置到 deployerConfigContext.xml 文件里 , 替代 &lt;bean class=&quot;org.jasig.cas.authentication.handler.support.SimpleTestUsernamePasswordAuthenticationHandler&quot; /&gt;</p>
<p>可能要用到数据库连接之类的配置，具体可参照 spring framework 相关文档</p>
<p>在 client 端取到登陆相关信息及登出系统</p>
<p>1. 取得用用户 ID</p>
<p>以下两种方式都可以</p>
<p>session.getAttribute(CASFilter.CAS_FILTER_USER);</p>
<p>session.getAttribute(&quot;edu.yale.its.tp.cas.client.filter.user&quot;);</p>
<p>也可以直接取得认证 java 对象</p>
<p>session.getAttribute(CASFilter.CAS_FILTER_RECEIPT);</p>
<p>session.getAttribute(&quot;edu.yale.its.tp.cas.client.filter.receipt&quot;);</p>
<p>JSP2.0 标准写法</p>
<p>&lt;c:out value=&quot;${sessionScope['edu.yale.its.tp.cas.client.filter.user']}&quot;/&gt;</p>
<p>在 jsp 中使用 CAS Tag Library 标签</p>
<p>除实现以上功能完还可以实现登出之类的相关功能，具体参照 cas 官方文档</p>
<p><a href="http://www.ja-sig.org/products/cas/client/jsp/index.html">http://www.ja-sig.org/products/cas/client/jsp/index.html</a></p>]]></description>
			<link>http://blog.astring.net//show-534-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2008-04-17 21:57</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-533-1.html</guid>
			<title>CAS单点登陆原理</title>
			<author>string</author>
			<description><![CDATA[<p>总结主要来源于网上的一些文章和论坛的记录以及我自已的一些想法.<br />
CAS (Central Authentication Service) 是 Yale 大学的 ITS 开发的一套 JAVA 实现的开源</p>
<p>的 SSO(single sign-on) 的服务(主要是2.0，到3.0为ja-sig)。</p>
<p>关键字</p>
<p>TGC(ticket-granting cookie)--------- 受权的票据证明</p>
<p>KDC( Key Distribution Center ) ---------- 密钥发放中心</p>
<p>Service ticket(ST) --------- 服务票据， 由 KDC 的 TGS 发放。 任何一台 Workstation 都需要拥有一张有效的 Service Ticket 才能访问域内部的应用 (Applications) 。 如果能正确接收 Service Ticket ，说明在 CASClient-CASServer 之间的信任关系已经被正确建立起来 , 通常为一张数字加密的证书</p>
<p>Ticket Granting tieckt(TGT) --------- 票据授权票据，由 KDC 的 AS 发放。即获取这样一张票据后，以后申请各种其他服务票据 (ST) 便不必再向 KDC 提交身份认证信息 ( 准确术语是 Credentials) 。</p>
<p>authentication service (AS) --------- 认证用服务，索取 Crendential ，发放 TGT</p>
<p>ticket-granting service (TGS) --------- 票据授权服务，索取 TGT ，发放 ST</p>
<p>&nbsp;</p>
<p>CAS 单点服务器的认证过程，所有应用服务器收到应用请求后，检查 ST 和 TGT ，如果没有或不对，转到 CAS 认证服务器登陆页面，通过安全认证后得到 ST 和 TGT 再重定向到相关应用服务器，在会话生命周期之内如果再定向到别的应用，将出示</p>
<p>ST 和 TGT 进行认证 , 注意 , 取得 TGT 的过程是通过 SSL 安全协议的 ( 换句话说就是如果不用 ssl 协议 , 每访问一个应用服务，就得重新到认证服务中心认证一次 ) ，关于 SSL 的相关描述可以查看附录 .</p>
<p>&nbsp;</p>
<p>白话描述 :</p>
<p>单点登陆 , 无非就是提供给用户一次登陆 , 多个系统共享用户信息的操作 .</p>
<p>这个是怎么操作的呢 ? 有简单的方法 , 当用户访问其他系统的时候 , 写个 URL 带上用户的 ID 和 PASS 提交到相应的系统就可以了 . 这也是一种方法</p>
<p>那 CAS 是怎么操作的呢 ? 或则是 KRB(Kerberos 是一个加密认证协议，允许网络用户不使用明文密码访问服务，一个普通 <br />
的协议实现包括 LOGIN 服务存在伪造欺骗对 Key Distribution Center 的响应 。</p>
<p>) 怎么操作的呢 ?</p>
<p>他并不是很复杂 , 他先是建立一个 专门认证用户的 服务 (SERVER) 这个服务只做一件事 , 负责验证用户的 ID 和 PASS 是否是正确 , 在正确的情况提供用户一个名为 TGT 的票据 ,</p>
<p>相当你要去游乐场玩 , 首先你要在门口检查你的身份 ( 即 CHECK 你的 ID 和 PASS), 如果你通过验证 , 游乐场的门卫 (AS) 即提供给你一张门卡 (TGT).</p>
<p>这张卡片的用处就是告诉 游乐场的各个场所 , 你是通过正门进来 , 而不是后门偷爬进来的 , 并且也是获取进入场所一把钥匙 .</p>
<p>好的 , 现在你有张卡 , 但是这对你来不重要 , 因为你来游乐场不是为了拿这张卡的 , 好的 , 我们向你的目的出发 , 恩 , 你来到一个摩天楼 , 你想进入玩玩 ,</p>
<p>这时摩天轮的服务员 (client) 拦下你 , 向你要求摩天轮的 (ST) 票据 , 你说你只有一个门卡 (TGT), 好的 , 那你只要把 TGT 放在一旁的票据授权机 (TGS) 上刷一下 ,</p>
<p>票据授权机 (TGS) 就根据你现在所在的摩天轮 , 给你一张摩天轮的票据 (ST), 哈 , 你有摩天轮的票据 , 现在你可以畅通无阻的进入摩天轮里游玩了 .</p>
<p>当然如果你玩完摩天轮后 , 想去游乐园的咖啡厅休息下 , 那你一样只要带着那张门卡 (TGT). 到相应的咖啡厅的票据授权机 (TGS) 刷一下 , 得到咖啡厅的票据 (ST) 就可以进入咖啡厅</p>
<p>当你离开游乐场后 , 想用这张 TGT 去刷打的回家的费用 , 呵呵 , 对不起 , 你的 TGT 已经过期了 , 在你离开游乐场那刻开始 , 你的 TGT 就已经销毁了 ~</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Yale CAS Server 的配置过程</p>
<p>&nbsp;</p>
<p>CAS (Central Authentication Service) 是 Yale 大学的 ITS 开发的一套 JAVA 实现的开源</p>
<p>的 SSO(single sign-on) 的服务。该服务是以一个 java web app(eg:cas.war) 来进行服务的，</p>
<p>使用时需要将 cas.war 发布到一个 servlet2.3 兼容的服务器上，并且服务器需要支持 SSL ，</p>
<p>在需要使用该服务的其他服务器（客户），只要进行简单的配置就可以实现 SSO 了。</p>
<p>&nbsp;</p>
<p>CAS 的客户端可以有很多种，因为验证的结果是以 XML 的格式返回的， CAS 的客户端已</p>
<p>打包进去的有 java,perl,python,asp,apache module 等好几种客户端示例，你还可以根据</p>
<p>需要实现一个自己的客户端，非常简单 !~</p>]]></description>
			<link>http://blog.astring.net//show-533-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2008-04-17 21:55</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-489-1.html</guid>
			<title>疑难杂症咋整？</title>
			<author>string</author>
			<description><![CDATA[<p>问：websphere6的下面，为什么ajax的调用会出现乱码？</p>
<p>答：请修改对应web-inf下面的ibm-web-ext.xmi 里面的内容，请将autoRequestEncoding=&quot;true&quot; autoResponseEncoding=&quot;true&quot;中的true改成false，就ok了。</p>
<p>继续问：为什么我改了，还不ok？</p>
<p>继续答：因为websphere的同步机制，在profiles下面对应的config里面，还有一个命名一摸一样的文件，ibm-web-ext.xmi ，请修改其中的相同的地方的内容。</p>
<p>原理猜想：websphere解析的时候，不是类似于tomcat直接解析web目录下面web-inf里面的配置文件，而是解析config里面的web-inf里面的配置文件，中间的同步的机制就不得而知，据我所知，bea的weblogic的同步是根据时间戳的，但是IBM的貌似不跟时间戳打交道，保险起见，还是手工copy的比较好。</p>
<p>同理，添加servlet也一样，需要手工发布2个地方的web.xml.</p>
<p>websphere是一个很严格的J2EE容器，它会严格的检查web.xml里面的配置，还有jsp的页面的java的写法，很多tomcat或者jboss不抛出的错误，在websphere下面都能立显无疑。</p>
<p>eos的应用中，往往会用到hiddensubmit.js的这个文件，也就是说，会用到隐含提交这玩意，如果不修改上面提到的ibm-web-ext.xmi，一定会出现乱码，并且是提交到pr，数据总线中就乱掉。：）</p>
<p>似乎应该考虑，把eos的平台升级成utf-8。</p>
<p>加班到11点，做个记号先！</p>]]></description>
			<link>http://blog.astring.net//show-489-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2007-11-30 00:14</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-488-1.html</guid>
			<title>验证文件大小</title>
			<author>string</author>
			<description><![CDATA[<p>&lt;html&gt;&nbsp; <br />
&lt;input type=&quot;file&quot; name=&quot;file1&quot; onchange=&quot;ShowSize(this.value)&quot;&gt;&nbsp; <br />
&lt;script language=&quot;JavaScript&quot;&gt;&nbsp;&nbsp;<br />
function ShowSize(files)&nbsp; <br />
{&nbsp; <br />
&nbsp; var fso,f;&nbsp; <br />
&nbsp; fso=new ActiveXObject(&quot;Scripting.FileSystemObject&quot;);&nbsp; <br />
&nbsp; f=fso.GetFile(files);&nbsp; <br />
&nbsp; alert(f.size+&quot; Bytes&quot;);&nbsp; <br />
}&nbsp;&nbsp;&nbsp; <br />
&lt;/script&gt;</p>
<p>只是需要fso，怎么才能不用fso呢？</p>]]></description>
			<link>http://blog.astring.net//show-488-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2007-11-26 23:33</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-487-1.html</guid>
			<title>websphere的jndi的获取</title>
			<author>string</author>
			<description><![CDATA[<p><code><span style="color: #000000">
<span style="color: #0000BB">Context&nbsp;ctx</span><span style="color: #007700">=new&nbsp;</span><span style="color: #0000BB">InitialContext</span><span style="color: #007700">();<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Connection&nbsp;conn</span><span style="color: #007700">=</span><span style="color: #0000BB">null</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Hashtable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parms&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">Hashtable</span><span style="color: #007700">();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">parms</span><span style="color: #007700">.</span><span style="color: #0000BB">put</span><span style="color: #007700">(</span><span style="color: #0000BB">Context</span><span style="color: #007700">.</span><span style="color: #0000BB">INITIAL_CONTEXT_FACTORY</span><span style="color: #007700">,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #DD0000">"com.ibm.ejs.ns.jndi.CNInitialContextFactory"</span><span style="color: #007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;try{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ctx&nbsp;</span><span style="color: #007700">=&nbsp;new&nbsp;</span><span style="color: #0000BB">InitialContext</span><span style="color: #007700">(</span><span style="color: #0000BB">parms</span><span style="color: #007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">DataSource&nbsp;ds&nbsp;</span><span style="color: #007700">=&nbsp;(</span><span style="color: #0000BB">DataSource</span><span style="color: #007700">)</span><span style="color: #0000BB">ctx</span><span style="color: #007700">.</span><span style="color: #0000BB">lookup</span><span style="color: #007700">(</span><span style="color: #DD0000">"jdbc/test"</span><span style="color: #007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">conn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">ds</span><span style="color: #007700">.</span><span style="color: #0000BB">getConnection</span><span style="color: #007700">(</span><span style="color: #DD0000">"test"</span><span style="color: #007700">,</span><span style="color: #DD0000">"test"</span><span style="color: #007700">);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}catch(</span><span style="color: #0000BB">NamingException&nbsp;ne</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">System</span><span style="color: #007700">.</span><span style="color: #0000BB">out</span><span style="color: #007700">.</span><span style="color: #0000BB">println</span><span style="color: #007700">(</span><span style="color: #0000BB">ne</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}</span><span style="color: #0000BB"></span>
</span>
</code>&nbsp;</p>]]></description>
			<link>http://blog.astring.net//show-487-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2007-11-21 23:54</pubDate>
		</item>
		<item>
			<guid>http://blog.astring.net//show-486-1.html</guid>
			<title>货币输入自动添加“,“的demo</title>
			<author>string</author>
			<description><![CDATA[<p><code><span style="color: #000000">
<span style="color: #0000BB"></span><span style="color: #007700">&lt;</span><span style="color: #0000BB">input&nbsp;type</span><span style="color: #007700">=</span><span style="color: #DD0000">"text"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">id</span><span style="color: #007700">=</span><span style="color: #DD0000">"id"&nbsp;</span><span style="color: #0000BB">onchange</span><span style="color: #007700">=</span><span style="color: #DD0000">'javascript:te("id");'&nbsp;</span><span style="color: #0000BB">size</span><span style="color: #007700">=</span><span style="color: #DD0000">"50"</span><span style="color: #007700">&gt;<br /><br />&lt;</span><span style="color: #0000BB">script</span><span style="color: #007700">&gt;<br /><br />function&nbsp;</span><span style="color: #0000BB">te</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">value</span><span style="color: #007700">=</span><span style="color: #0000BB">document</span><span style="color: #007700">.</span><span style="color: #0000BB">getElementById</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">).</span><span style="color: #0000BB">value</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">re</span><span style="color: #007700">=/(</span><span style="color: #0000BB">d</span><span style="color: #007700">+)(</span><span style="color: #0000BB">d</span><span style="color: #007700">{</span><span style="color: #0000BB">3</span><span style="color: #007700">})/;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;if(</span><span style="color: #0000BB">value</span><span style="color: #007700">.</span><span style="color: #0000BB">indexOf</span><span style="color: #007700">(</span><span style="color: #DD0000">","</span><span style="color: #007700">)==-</span><span style="color: #0000BB">1</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">s</span><span style="color: #007700">=</span><span style="color: #0000BB">value</span><span style="color: #007700">.</span><span style="color: #0000BB">toString</span><span style="color: #007700">();<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;if(</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">indexOf</span><span style="color: #007700">(</span><span style="color: #DD0000">"."</span><span style="color: #007700">)!=-</span><span style="color: #0000BB">1</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">st&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">split</span><span style="color: #007700">(</span><span style="color: #DD0000">"."</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(</span><span style="color: #0000BB">re</span><span style="color: #007700">.</span><span style="color: #0000BB">test</span><span style="color: #007700">(</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]))</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]=</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">].</span><span style="color: #0000BB">replace</span><span style="color: #007700">(</span><span style="color: #0000BB">re</span><span style="color: #007700">,</span><span style="color: #DD0000">"$1,$2"</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">document</span><span style="color: #007700">.</span><span style="color: #0000BB">getElementById</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">).</span><span style="color: #0000BB">innerText</span><span style="color: #007700">=</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]+</span><span style="color: #DD0000">"."</span><span style="color: #007700">+</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">];<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}else{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(</span><span style="color: #0000BB">re</span><span style="color: #007700">.</span><span style="color: #0000BB">test</span><span style="color: #007700">(</span><span style="color: #0000BB">s</span><span style="color: #007700">))</span><span style="color: #0000BB">s</span><span style="color: #007700">=</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">replace</span><span style="color: #007700">(</span><span style="color: #0000BB">re</span><span style="color: #007700">,</span><span style="color: #DD0000">"$1,$2"</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">document</span><span style="color: #007700">.</span><span style="color: #0000BB">getElementById</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">).</span><span style="color: #0000BB">innerText</span><span style="color: #007700">=</span><span style="color: #0000BB">s</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}else{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">s</span><span style="color: #007700">=</span><span style="color: #0000BB">value</span><span style="color: #007700">.</span><span style="color: #0000BB">toString</span><span style="color: #007700">();<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;while(</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">indexOf</span><span style="color: #007700">(</span><span style="color: #DD0000">","</span><span style="color: #007700">)!=-</span><span style="color: #0000BB">1</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">s</span><span style="color: #007700">=</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">replace</span><span style="color: #007700">(</span><span style="color: #DD0000">","</span><span style="color: #007700">,</span><span style="color: #DD0000">""</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;if(</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">indexOf</span><span style="color: #007700">(</span><span style="color: #DD0000">"."</span><span style="color: #007700">)!=-</span><span style="color: #0000BB">1</span><span style="color: #007700">){<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;</span><span style="color: #0000BB">st&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">split</span><span style="color: #007700">(</span><span style="color: #DD0000">"."</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(</span><span style="color: #0000BB">re</span><span style="color: #007700">.</span><span style="color: #0000BB">test</span><span style="color: #007700">(</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]))</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]=</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">].</span><span style="color: #0000BB">replace</span><span style="color: #007700">(</span><span style="color: #0000BB">re</span><span style="color: #007700">,</span><span style="color: #DD0000">"$1,$2"</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">document</span><span style="color: #007700">.</span><span style="color: #0000BB">getElementById</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">).</span><span style="color: #0000BB">innerText</span><span style="color: #007700">=</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">]+</span><span style="color: #DD0000">"."</span><span style="color: #007700">+</span><span style="color: #0000BB">st</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">];<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}else{<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(</span><span style="color: #0000BB">re</span><span style="color: #007700">.</span><span style="color: #0000BB">test</span><span style="color: #007700">(</span><span style="color: #0000BB">s</span><span style="color: #007700">))</span><span style="color: #0000BB">s</span><span style="color: #007700">=</span><span style="color: #0000BB">s</span><span style="color: #007700">.</span><span style="color: #0000BB">replace</span><span style="color: #007700">(</span><span style="color: #0000BB">re</span><span style="color: #007700">,</span><span style="color: #DD0000">"$1,$2"</span><span style="color: #007700">);<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">document</span><span style="color: #007700">.</span><span style="color: #0000BB">getElementById</span><span style="color: #007700">(</span><span style="color: #0000BB">obj</span><span style="color: #007700">).</span><span style="color: #0000BB">innerText</span><span style="color: #007700">=</span><span style="color: #0000BB">s</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;<br /><br /></span><span style="color: #0000BB">&lt;/script&gt;</span></span>
</code></p>]]></description>
			<link>http://blog.astring.net//show-486-1.html</link>
			<category domain="http://blog.astring.net//category-4-1.html">系统工程师</category>
			<pubDate>2007-11-20 23:54</pubDate>
		</item>
	</channel>
</rss>
