<HTML><BODY><head><TITLE>Oracle / Windchill / Intralink - JSP / Oracle Query</TITLE>

<SCRIPT language="JavaScript">
<!--
function upd_inpP(QueryForm) {
    selected = QueryForm.sqlQueryP.selectedIndex;
    QueryForm.elements['sqlQuery'].value = QueryForm.sqlQueryP.options[selected].value;
}

function upd_inpO(QueryForm) {
    selected = QueryForm.sqlQueryO.selectedIndex;
    QueryForm.elements['sqlQuery'].value = QueryForm.sqlQueryO.options[selected].value;
}

function upd_inpI(QueryForm) {
    selected = QueryForm.sqlQueryI.selectedIndex;
    QueryForm.elements['sqlQuery'].value = QueryForm.sqlQueryI.options[selected].value;
}
//-->
</SCRIPT>
</head>

<center>
<B> Oracle / Windchill / Intralink - JSP / Oracle Query </B><BR>

<form action="dbjett_get.jsp" method="get" target="FrameBot">

<table BORDER=1 CELLSPACING=1 CELLPADDING=1><tr>
	<td colspan=2><b> Oracle/Windchill/Intralink Server Name: </b><input type="text" name="srvrNm" VALUE="LarrySERVER" size="20"></td>
	<td><b> Port Number: </b><input type="text" name="portNo" VALUE="1521" size="10"></td>
</tr><tr>
	<td><b> SID Name: </b><input type="text" name="sidNm" VALUE="wind" size="15"></td>
	<td><b> UserName: </b><input type="text" name="usrNm" VALUE="system" size="15"></td>
	<td colspan=2><b> Password: </b><input type="password" name="passWd" size="15"></td>
</tr></table>
<br>
<table BORDER=1 CELLSPACING=1 CELLPADDING=1>

<tr><td><b> SQL Query: </b><br>
<input type="text" name="sqlQuery" size="98"></td></tr>

</table>
<br>

<SELECT NAME="sqlQueryP" onChange="upd_inpP(this.form)">
<OPTION VALUE=""> PdmLink SQL Queries
<OPTION VALUE="select * from WCUSER.FVITEM"> WCUSER.FVITEM </OPTION>
<OPTION VALUE="select NAME,CLASSNAMEKEYDOMAINREF,CREATESTAMPA2,MODIFYSTAMPA2,UPDATESTAMPA2,CLASSNAMEA2A2 from WCUSER.WTUSER"> WCUSER.WTUSER </OPTION>
<OPTION VALUE="select CLASSNAMEKEYCONTAINERREFEREN,NAME,WTPARTNUMBER,CLASSNAMEKEYORGANIZATIONREFE from WCUSER.WTPRODUCTMASTER"> WCUSER.WTPRODUCTMASTER </OPTION>
<OPTION VALUE="select CLASSNAMEKEYCONTAINERREFEREN, NAME,WTPARTNUMBER from WCUSER.WTPARTMASTER"> WCUSER.WTPARTMASTER </OPTION>
<OPTION VALUE="select DESCRIPTIONCONTAINERINFO,NAMECONTAINERINFO from WCUSER.WTLIBRARY"> WCUSER.WTLIBRARY </OPTION>
<OPTION VALUE="select NAME,DESCRIPTION from WCUSER.CABINET"> WCUSER.CABINET </OPTION>
<OPTION VALUE="select NAME from WCUSER.CONTAINERTEAM"> WCUSER.CONTAINERTEAM </OPTION>
<OPTION VALUE="select NAME,DESCRIPTION from WCUSER.EPMWORKSPACE"> WCUSER.EPMWORKSPACE </OPTION>
<OPTION VALUE="select NAME from WCUSER.WTGROUP"> WCUSER.WTGROUP </OPTION>
<OPTION VALUE="select * from WCUSER.FVFOLDER"> WCUSER.FVFOLDER </OPTION>
<OPTION VALUE="select * from WCUSER.WTPRODUCT"> WCUSER.WTPRODUCT </OPTION>
<OPTION VALUE="select NAME,WTPARTNUMBER from WCUSER.WTPRODUCTMASTER"> WCUSER.WTPRODUCTMASTER </OPTION>
<OPTION VALUE="select * from WCUSER.WTDOCUMENTMASTER"> WCUSER.WTDOCUMENTMASTER </OPTION>
<OPTION VALUE="select * from WCUSER.WTVIEW"> WCUSER.WTVIEW </OPTION>
<OPTION VALUE="select * from WCUSER.WTORGANIZATION"> WCUSER.WTORGANIZATION </OPTION>
<OPTION VALUE="select FORMATNAME,DESCRIPTION,MIMETYPE from WCUSER.DATAFORMAT"> WCUSER.DATAFORMAT </OPTION>
<OPTION VALUE="select OWNER,TABLE_NAME from dba_tables where owner = 'WCUSER'"> WCUSER - TABLES </OPTION>
<OPTION VALUE="SELECT WTU.NAME, WFP.NAME, WTU.IDA2A2 FROM wcuser.WFPROCESS WFP, wcuser.WTUSER WTU WHERE WTU.IDA2A2=WFP.IDA3B7 order by WTU.NAME"> WCUSER - WORKFLOW </OPTION>
</SELECT>

<SELECT NAME="sqlQueryO" onChange="upd_inpO(this.form)">
<OPTION VALUE=""> Oracle SQL Queries </OPTION>
<OPTION VALUE="select BANNER from SYS.V_$VERSION" onChange="sqlQuery.value = sqlQueryO.value"> Oracle Version </OPTION>
<OPTION VALUE="select database_status from v$instance"> Database Status </OPTION>
<OPTION VALUE="select sum(getmisses)/sum(gets)*100 pool_size from v$rowcache"> Shared Pool Size </OPTION>
<OPTION VALUE="select round((sum(decode(name, 'sorts (memory)', value, 0)) / (sum(decode(name, 'sorts (memory)', value, 0)) + sum(decode(name, 'sorts (disk)', value, 0)))) * 100,2) \"Sort in Memory %\" from v$sysstat"> Memory Sort Rate </OPTION>
<OPTION VALUE="select tablespace_name, status from dba_tablespaces"> Tablespace Status </OPTION>
<OPTION VALUE="select NAME,  DESCRIPTION from v$bgprocess"> Background Processes </OPTION>
<OPTION VALUE="select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0"> Session Info </OPTION>
</SELECT>
<br><br>

<SELECT NAME="sqlQueryI" onChange="upd_inpI(this.form)">
<OPTION VALUE=""> IntraLink SQL Queries </OPTION>
<OPTION VALUE="select * from pdm.pdm_pool"> pdm.pdm_pool </OPTION>
<OPTION VALUE="select * from pdm.pdm_fileserver"> pdm.pdm_fileserver </OPTION>
<OPTION VALUE="select * from pdm.pdm_releaselevel"> pdm.pdm_releaselevel </OPTION>
<OPTION VALUE="select * from pdm.pdm_releasescheme"> pdm.pdm_releasescheme </OPTION>
<OPTION VALUE="select * from pdm.pdm_folder"> pdm.pdm_folder </OPTION>
<OPTION VALUE="select * from pdm.pdm_productitem"> pdm.pdm_productitem </OPTION>
<OPTION VALUE="select * from pdm.pdm_productitemversion"> pdm.pdm_productitemversion </OPTION>
<OPTION VALUE="select * from pdm.pdm_pivrl"> pdm.pdm_pivrl </OPTION>
<OPTION VALUE="select * from pdm.pdm_lovfile"> pdm.pdm_lovfile </OPTION>
<OPTION VALUE="select * from pdm.pdm_action"> pdm.pdm_action </OPTION>
<OPTION VALUE="select * from V$ACCESS"> V$ACCESS </OPTION>
</SELECT>

<input type="submit" value="Submit Query">

</form></center>
</BODY></HTML>
