tkprof使用语法
tkprof trace_fileoutput_file [ explain=userid/password@database ]
killing my session in oracle
转自http://www.orafaq.com/files/KillingMySessions_1.txt KILLING MY SESSIONS IN ORACLEAuthor JP VijaykumarDate Nov 14th 2009Many a time, developers ask for procedures to kill there own s...
use Sun's JRE/JDK 1.6 Parameter to Specify a Particular JRE with Multiple
How to use Sun's JRE/JDK 1.6.0_10java_version Parameter to Specify a Particular JRE with MultipleVersions on a PC [ID 758823.1]Applies to: Oracle Forms - Version: 10.1.2.3.0 to 10.1.2.3.0Informati...
一些关于JRE和webutil的链接地址
各个版本的JRE的下载地址:http://java.sun.com/javase/6/docs/technotes/guides/deployment/deployment-guide/autodl-files.htmlApplication Server和Form. Builder 10通过论证的JRE和浏览器:http://www.oracle.com/...
Event-Driven Publishing using Database Trigger in Reports 9i/10g [ID 199743.1]
PURPOSE-------Demonstrate the Event-based publishing feature of Reports 9i/10G/10G R2 using a database trigger.NOTE: Please see on OTN, "Oracle® Application Server ReportsServices Publishing Repo...
解决在Form表单中光标移动不了问题
apply p8727236_10123 for Developer Suite 10.1.2.3 in Linux首先到oracle的技术支持下载所需补丁,然后1先打补丁7121788,把p7121788_10123_LINUX.zip解压到/home/oracledev目录下(ORACLE_HOME为/u01/app/o...
oracle 正规表达式
转自 http://www.psoug.org/reference/regexp.htmlGeneral InformationAnchoring Characters Character Class Description^ Anchor the expression to th...
转 Oracle SQL性能优化
转自: http://space.itpub.net/21229923/viewspace-6203491. 选用适合的ORACLE优化器 ORACLE的优化器共有3种:a.RULE(基于规则) b.COST(基于成本) c.CHOOSE(选择性) 设置缺省的...
webutil在Linux下Oracle Application Server的安装和测试
分别下载webutil 1.6,Webutil Demo和jacob 18 http://www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip http://www.oracle.com/technology/products/forms/htdocs/w...
Kickstarting WebUtil 1.06 in Developer Suite 10.1.2.0.2 on Windows [ID 333385.1]
Applies to: Oracle Forms - Version: 1.0.6Microsoft Windows (32-bit)GoalHow to get up and running with WebUtil 1.06 included with Oracle Developer Suite 10.1.2.0.2 on a win32 platform.SolutionAssumi...
How To Install Webutil on 10.1.2.x Oracle AS on Windows ? [ID 566628.1]
Applies to: Oracle Forms - Version: 10.1.2MS WindowsMicrosoft Windows GoalHow to install WebUtil on 10.1.2.x OAS on Windows ?Solution1)- Download Webutil files from the following link: - Webut...
How To Install Webutil on OAS under Linux/Unix [ID 374128.1]
Applies to: Oracle Forms - Version: 10.1.2.0.2Linux x86GoalHow to Install Webutil on Oracle AS 10.1.2.0.2 under Linux/Unix ?SolutionINSTALLATION -------------------------- 0. Linux and vers...
关于Linux下compile的错误FRM-91500解决方法
Linux下编译pll,fmb和mmb时报错[oracleas@tuning forms]$ frmcmp_batch.sh module=WU_TEST_106.fmb userid=webutil/webutil@tuning compile_all=yes module_type=formFRM-91500: Unable to start/complete the buil...
webutil的使用
Subject:Webutil functionalities fail witherror like: "Oracle.forms.webutil.host.Host bean not found.WeBUTIL_HOST.Execute will not work" Doc ID:469183.1Type: PROBLEM Modified Da...
查看表空间使用率SQL语句
spool /home/oracle/tablespace.sql SELECT file_name, tablespace_name, bytes/(1024*1024) bytes1, autoextensible, maxbytes/(1024*1024) maxbytes1, user_bytes/(1024*1024) user_bytes1 FROM dba_data_f...
关于AS and DS的配置文件formsweb.cfg
在$ORACLE_HOME\forms\server或$ORACLE_HOME/forms/server下的formsweb.cfg配置文件,若想用运行时直接调用jre,只要把[default]下的baseHTMLjinitiator=basejini.htm注释掉,如下[default]# System parameter: defa...
OUI-10094:Problem in saving inventory. Installation cannot continue解决办法
我在Linux下先装了oracle application server和oracle developer之后,再安装10.2的DB时,也出现类似的情况,我是用不同的用户安装不同的软件. AS为oracleas, DS为oracledev, DB为oracle,都属于oinstall和dba,即使...
How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS
How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ? 文档 ID:336014.1类型: HOWTO Modified Date: 05-MAR-2008状态: PUBLISHEDIn this Document Goal ...
Linux下的rwbuilder.sh不能运行
Subject: rwserver.sh Generates Segmentation Fault or no Errors, and Standalone is not created Doc ID: 331919.1 Type: PROBLEM Modified Date: 27-JUL-2009 St...
关于linux和unix下的3 of 9 barcode 和中文字体的报表显示问题解决办法
1.解压fontsolutions_pdf.tar.gz文件,并切换到解压后的fontsolutions目录下,最后执行./configurefonts.sh使配置生效$tar zxvf fontsolutions_pdf.tar.gz$cd fontsolutions$ ./configurefonts.sh2. 备份$ORACLE_H...