<<Oracle Applications DBA 基础（第二期）>>Week 09 exercise-白红宇

<<Oracle Applications DBA 基础（第二期）>>Week 09 exercise

阅读量：4177 次

发布时间：2019-05-26

本文共 5434 字，大约阅读时间需要 18 分钟。

1. 下载 Oracle workflow client 2.6.3.5, 设计一个简单的 workflow process 并上载到ＥＢＳ上运行。

并在 sqlplus 上列出你的 workflow process 运行过的记录 ( hint:　相关的WF_ 表）

Download wf client from :

Oracle Workflow Client Release 2.6.3.5 for Microsoft Windows

http://www.oracle.com/technetwork/database/options/winclient-101059.html

wf运行记录:

-bash-3.2$ cd $FND_TOP/sql

-bash-3.2$ sqlplus apps/apps @wfstatus.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 26 19:17:13 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter value for 1: MYWFDEMO

Enter value for 2: MYWFDEMO_001

**** WorkFlow Item

Item Type Item Key Begin Date End Date Activity

---------- --------------- ------------------ ------------------ ---------------------------------------------

MYWFDEMO MYWFDEMO_001 26-MAR-14 19:09:02 26-MAR-14 19:09:02 MYWFPROCESS

**** Activity Statuses

Begin Date Activity Status Result User

------------------ --------------------------------------------- -------- --------------- ---------------

26-MAR-14 19:09:02 ROOT/my wf process COMPLETE #NULL

26-MAR-14 19:09:02 my wf process/Start COMPLETE #NULL

26-MAR-14 19:09:02 my wf process/End COMPLETE #NULL

**** Errored Activities

no rows selected

*** Error Process Activity Statuses

no rows selected

**** Error Process Errored Activities

no rows selected

**** Attribute Values

Attribute Name Value

------------------------------ ------------------------------

#SCHEMA APPS

.ADMIN_KEY 191093547499382052000840334587

289665058

.MONITOR_KEY 118322016317057695135788844168

293191100

Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

-bash-3.2$

--EOF--

2. 对应你的 EBS 版本（12.1.1 或 12.1.3) , 下载相应的 Jdeveloper ,安装并做一个简单的 OA HTML page 并发布到 EBS 上去运行。

如果你不熟悉 Java 语言的话，可以不用修改与 controller 相关的 method。

请列出你的程序发布到 $JAVA_TOP 上的目录的内容。请在 sqlplus 上列出你发布到数据库 MDS 上的 XML page 的内容。

（hint：参考课程资源中的 Demo create R12 OAF program.txt 和联机帮助 file:///C:/jdevoaf/jdevdoc/WebHelp/toolbox/toolbox.htm 中的Hello World例子）

$JAVA_TOP目录下的内容:

[appldev@oel57dev webui]$ pwd

/u01/apps/apps_st/comn/java/classes/oracle/apps/ak/hello/webui

[appldev@oel57dev webui]$ ls -l

total 8

-rw-r--r-- 1 root root 1325 Apr 10 22:41 HelloWordPG.xml

-rw-r--r-- 1 root root 1734 Apr 10 22:41 HelloWorldMainCO.class

[appldev@oel57dev webui]$

数据库MDS上的XML page内容:

SQL> exec JDR_UTILS.listContents('/oracle/apps/ak/hello',true);

Printing contents of /oracle/apps/ak/hello recursively

/oracle/apps/ak/hello/webui/HelloWordPG

PL/SQL procedure successfully completed.

SQL> exec JDR_UTILS.listContents('/oracle/apps/ak/hello/webui/',true);

Printing contents of /oracle/apps/ak/hello/webui/ recursively

/oracle/apps/ak/hello/webui/HelloWordPG

PL/SQL procedure successfully completed.

SQL> exec JDR_UTILS.printDocument('/oracle/apps/ak/hello/webui/HelloWordPG');

<?xml version='1.0' encoding='UTF-8'?>

<page xmlns:jrad="http://xmlns.oracle.com/jrad"

xmlns:oa="http://xmlns.oracle.com/oa" xmlns:ui="http://xmlns.oracle.com/uix/ui"

version="10.1.3_1268" xml:lang="en-US"

xmlns:user="http://xmlns.oracle.com/jrad/user"

xmlns="http://xmlns.oracle.com/jrad"

file-version="$Header$">

<oa:pageLayout id="PageLayoutRN" windowTitle="My OAF Window" title="My OAF

Title"

amDefName="oracle.apps.fnd.framework.toolbox.tutorial.server.HelloWorldAM"

controllerClass="oracle.apps.ak.hello.webui.HelloWorldMainCO">

<ui:corporateBranding>

<oa:image id="corporateBrandingImage" source="/OA_MEDIA/FNDSSCORP.gif"/>

</ui:corporateBranding>

<ui:contents>

<oa:contentContainer id="MainRN">

<ui:contents>

<oa:messageTextInput id="HelloName" prompt="Please enter your name" columns="20"

maximumLength="50"/>

<oa:contentContainer id="ButtonLayout">

<ui:contents>

<oa:submitButton id="Go" text="Go" prompt="Go"/>

</ui:contents>

</oa:contentContainer>

</ui:contents>

</oa:contentContainer>

</ui:contents>

</oa:pageLayout>

</content>

</page>

PL/SQL procedure successfully completed.

SQL>

测试页面, 部署在R12.1.1上:

--EOF--

3. "ICX:Session Timeout" profile setting 是控制什么的？default value 是什么？

试修改以证明你的意见。有人说，这个profile 设得过大，会占用过多 JVM resources ，导致 ‘out of memory’ errors ？

请根据这周的内容发表你的看法 ( hint: State Architecture PPT)．

ICX: Session Timeout作用:

This profile option determines the length of time (in minutes) of inactivity in a user's session before the session is disabled. If the user does not perform any operation in Oracle E-Business Suite for longer than this value, the session is disabled. The user is provided the opportunity to re-authenticate and re-enable a timed-out session. If re-authentication is successful, the session is re-enabled and no work is lost. Otherwise, Oracle E-Business Suite ends the session without saving pending work.

http://docs.oracle.com/cd/E18727_01/doc.121/e12894/T202991T202995.htm

ICX: Session Timeout default value:

SQL> select fnd_profile.value('ICX_SESSION_TIMEOUT') from dual;

FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')

--------------------------------------------------------------------------------

SQL>

ICX: Session Timeout 过大会不会导致OOM错误:

ICX: Session TImeout 过大不一定导致OOM错误, 如果系统能承载足够多的用户数, 即可以承担所有人同时登录的负载, 那么ICX: Session TImeout 再大也无所谓;

反之,如果用户数过多,系统只能承载其中一部分,那么适时timeout一部分idle用户有利于减轻负载,这种情况下ICX: Session TImeout 过大可能会导致OOM错误.

--EOF--

转载地址：http://ewtai.baihongyu.com/

你可能感兴趣的文章