Package org.jmanage.connector.plugin.oracle

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

162
163
164
165
166
167
168
169
    }

    /* MBean Operations */
   
    public CompositeData getHitRatioData() throws Exception {
        DataAccessor da = new DataAccessor(SQL_HIT_RATIO);
        return da.execute().getCompositeData();
    }
View Full Code Here
167
168
169
170
171
172
173
174
        DataAccessor da = new DataAccessor(SQL_HIT_RATIO);
        return da.execute().getCompositeData();
    }

    public TabularData getTablespaceUsage() throws Exception {
        DataAccessor da = new DataAccessor(SQL_TABLESPACE_USAGE);
        return da.execute().getTabularData();
    }
View Full Code Here
172
173
174
175
176
177
178
179
        DataAccessor da = new DataAccessor(SQL_TABLESPACE_USAGE);
        return da.execute().getTabularData();
    }

    public TabularData getFileStatistics() throws Exception {
        DataAccessor da = new DataAccessor(SQL_DATAFILE_STATS);
        return da.execute().getTabularData();
    }
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
        }
    }

    private void initLicenseInfo() {
        try {
            licenseInfo = new DataAccessor(LICENSE_INFO_SQL).execute().getCompositeData();
        }
        catch (Exception e) {
            logger.severe("Error getting licenseInfo. error: " + e.getMessage());
        }
    }
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
        }
    }

    private void initOptionsInstalled() {
        try {
            optionsInstalled = new DataAccessor(OPTION_SQL).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting optionsInstalled. error: " + e.getMessage());
        }
    }
View Full Code Here
40
41
42
43
44
45
46
47
            "v$session.sid = v$sess_io.sid and " +
            "(consistent_gets + block_gets) > 0 and " +
            "Username is NOT NULL";

    public TabularData getSessionHitRatio() throws Exception {
        DataAccessor da = new DataAccessor(SQL_SESS_HIT_RATIO);
        return da.execute().getTabularData();
    }
View Full Code Here
45
46
47
48
49
50
51
52
        DataAccessor da = new DataAccessor(SQL_SESS_HIT_RATIO);
        return da.execute().getTabularData();
    }

    public TabularData getSessionInfo() throws Exception {
        DataAccessor da = new DataAccessor(SQL_SESSION);
        return da.execute().getTabularData();
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
            "select name, value, isdefault, isses_modifiable, issys_modifiable " +
            "from v$parameter order by name";

    public TabularData getParameters() {
        try {
            return new DataAccessor(SQL).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting v$parameter info. error: " + e.getMessage());
            return null;
        }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
            "v$parameter.name = 'shared_pool_size'";
   
   
    public TabularData getSupportedInitParams() {
        try {
            return new DataAccessor(SQL_SUPPORTED_INIT_PARAM).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting supported init params. error: " + e.getMessage());
            return null;
        }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
        }
    }

    public TabularData getTopTenUsers() {
        try {
            return new DataAccessor(SQL_TOP_TEN_USERS_BY_CPU).execute().getTabularData();
        }
        catch (Exception e) {
            logger.severe("Error getting top ten users by cpu. 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.