Package org.jmanage.connector.plugin.oracle

Examples of org.jmanage.connector.plugin.oracle.DataAccessor

121
122
123
124
125
126
127
128
129
130
131
        }
    }
   
    public TabularData getTopTenExpensiveQueries() {
        try {
            return new DataAccessor(SQL_TOP10_EXPENSIVE_QUERY).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting top ten users. error: " + e.getMessage());
            return null;
        }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
        }
    }
   
    public TabularData getLockedObjects() {
        try {
            return new DataAccessor(SQL_LOCKED_OBJECTS).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting locked objects. error: " + e.getMessage());
            return null;
        }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
   
    private static final String SQL = "select POOL || ' - ' || NAME as NAME, BYTES from V$SGASTAT";
   
    public TabularData getStatistics(){
        try {
            return new DataAccessor(SQL).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting SGA stats. error: " + e.getMessage());
            return null;
        }
View Full Code Here
TOP

Related Classes of org.jmanage.connector.plugin.oracle.DataAccessor

  • org.jmanage.connector.plugin.oracle.mbean.Database
  • org.jmanage.connector.plugin.oracle.mbean.Parameters
  • org.jmanage.connector.plugin.oracle.mbean.Performance
  • org.jmanage.connector.plugin.oracle.mbean.Session
  • org.jmanage.connector.plugin.oracle.mbean.SGAStatistics
  • java.sql.PreparedStatement
  • java.sql.Connection
  • java.sql.ResultSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.