<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <%@ include file="Connections/test.jsp" %> <% String Recordset1__MMColParam = "1"; if (request.getParameter("OWNER") !=null) {Recordset1__MMColParam = (String)request.getParameter("OWNER");} %> <% Driver DriverRecordset1 = (Driver)Class.forName(MM_test_DRIVER).newInstance(); Connection ConnRecordset1 = DriverManager.getConnection(MM_test_STRING,MM_test_USERNAME,MM_test_PASSWORD); PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM SYS.ALL_ALL_TABLES WHERE OWNER = " + Recordset1__MMColParam + ""); ResultSet Recordset1 = StatementRecordset1.executeQuery(); boolean Recordset1_isEmpty = !Recordset1.next(); boolean Recordset1_hasData = !Recordset1_isEmpty; Object Recordset1_data; int Recordset1_numRows = 0; %>

OWNER	<%=(((Recordset1_data = Recordset1.getObject("OWNER"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TABLE_NAME	<%=(((Recordset1_data = Recordset1.getObject("TABLE_NAME"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TABLESPACE_NAME	<%=(((Recordset1_data = Recordset1.getObject("TABLESPACE_NAME"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
CLUSTER_NAME	<%=(((Recordset1_data = Recordset1.getObject("CLUSTER_NAME"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
IOT_NAME	<%=(((Recordset1_data = Recordset1.getObject("IOT_NAME"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
PCT_FREE	<%=(((Recordset1_data = Recordset1.getObject("PCT_FREE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
PCT_USED	<%=(((Recordset1_data = Recordset1.getObject("PCT_USED"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
INI_TRANS	<%=(((Recordset1_data = Recordset1.getObject("INI_TRANS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
MAX_TRANS	<%=(((Recordset1_data = Recordset1.getObject("MAX_TRANS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
INITIAL_EXTENT	<%=(((Recordset1_data = Recordset1.getObject("INITIAL_EXTENT"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
NEXT_EXTENT	<%=(((Recordset1_data = Recordset1.getObject("NEXT_EXTENT"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
MIN_EXTENTS	<%=(((Recordset1_data = Recordset1.getObject("MIN_EXTENTS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
MAX_EXTENTS	<%=(((Recordset1_data = Recordset1.getObject("MAX_EXTENTS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
PCT_INCREASE	<%=(((Recordset1_data = Recordset1.getObject("PCT_INCREASE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
FREELISTS	<%=(((Recordset1_data = Recordset1.getObject("FREELISTS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
FREELIST_GROUPS	<%=(((Recordset1_data = Recordset1.getObject("FREELIST_GROUPS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
LOGGING	<%=(((Recordset1_data = Recordset1.getObject("LOGGING"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
BACKED_UP	<%=(((Recordset1_data = Recordset1.getObject("BACKED_UP"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
NUM_ROWS	<%=(((Recordset1_data = Recordset1.getObject("NUM_ROWS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
BLOCKS	<%=(((Recordset1_data = Recordset1.getObject("BLOCKS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
EMPTY_BLOCKS	<%=(((Recordset1_data = Recordset1.getObject("EMPTY_BLOCKS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
AVG_SPACE	<%=(((Recordset1_data = Recordset1.getObject("AVG_SPACE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
CHAIN_CNT	<%=(((Recordset1_data = Recordset1.getObject("CHAIN_CNT"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
AVG_ROW_LEN	<%=(((Recordset1_data = Recordset1.getObject("AVG_ROW_LEN"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
AVG_SPACE_FREELIST_BLOCKS	<%=(((Recordset1_data = Recordset1.getObject("AVG_SPACE_FREELIST_BLOCKS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
NUM_FREELIST_BLOCKS	<%=(((Recordset1_data = Recordset1.getObject("NUM_FREELIST_BLOCKS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
DEGREE	<%=(((Recordset1_data = Recordset1.getObject("DEGREE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
INSTANCES	<%=(((Recordset1_data = Recordset1.getObject("INSTANCES"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
CACHE	<%=(((Recordset1_data = Recordset1.getObject("CACHE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TABLE_LOCK	<%=(((Recordset1_data = Recordset1.getObject("TABLE_LOCK"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
SAMPLE_SIZE	<%=(((Recordset1_data = Recordset1.getObject("SAMPLE_SIZE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
LAST_ANALYZED	<%=(((Recordset1_data = Recordset1.getObject("LAST_ANALYZED"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
PARTITIONED	<%=(((Recordset1_data = Recordset1.getObject("PARTITIONED"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
IOT_TYPE	<%=(((Recordset1_data = Recordset1.getObject("IOT_TYPE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
OBJECT_ID_TYPE	<%=(((Recordset1_data = Recordset1.getObject("OBJECT_ID_TYPE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TABLE_TYPE_OWNER	<%=(((Recordset1_data = Recordset1.getObject("TABLE_TYPE_OWNER"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TABLE_TYPE	<%=(((Recordset1_data = Recordset1.getObject("TABLE_TYPE"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
TEMPORARY	<%=(((Recordset1_data = Recordset1.getObject("TEMPORARY"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
SECONDARY	<%=(((Recordset1_data = Recordset1.getObject("SECONDARY"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
NESTED	<%=(((Recordset1_data = Recordset1.getObject("NESTED"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
BUFFER_POOL	<%=(((Recordset1_data = Recordset1.getObject("BUFFER_POOL"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
ROW_MOVEMENT	<%=(((Recordset1_data = Recordset1.getObject("ROW_MOVEMENT"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
GLOBAL_STATS	<%=(((Recordset1_data = Recordset1.getObject("GLOBAL_STATS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
USER_STATS	<%=(((Recordset1_data = Recordset1.getObject("USER_STATS"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
DURATION	<%=(((Recordset1_data = Recordset1.getObject("DURATION"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
SKIP_CORRUPT	<%=(((Recordset1_data = Recordset1.getObject("SKIP_CORRUPT"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
MONITORING	<%=(((Recordset1_data = Recordset1.getObject("MONITORING"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
CLUSTER_OWNER	<%=(((Recordset1_data = Recordset1.getObject("CLUSTER_OWNER"))==null || Recordset1.wasNull())?"":Recordset1_data)%>

<% Recordset1.close(); StatementRecordset1.close(); ConnRecordset1.close(); %>