Databases Reference
In-Depth Information
The Monitoring Dashboard is a functionality of the Administration Console. Make sure the
Administration Server is running.
How to do it...
Follow these steps to create tables in the Oracle
dbhost
database:
1. Connect to the database at
dbhost
, port
1521
, and service name
dbservice
.
2. Run the following SQL script:
DROP TABLE WLS_EVENTS;
CREATE TABLE WLS_EVENTS (
RECORDID number NOT NULL,
TIMESTAMP number default NULL,
CONTEXTID varchar2(128) default NULL,
TXID varchar2(32) default NULL,
USERID varchar2(32) default NULL,
TYPE varchar2(64) default NULL,
DOMAIN varchar2(64) default NULL,
SERVER varchar2(64) default NULL,
SCOPE varchar2(64) default NULL,
MODULE varchar2(64) default NULL,
MONITOR varchar2(64) default NULL,
FILENAME varchar2(64) default NULL,
LINENUM number default NULL,
CLASSNAME varchar2(250) default NULL,
METHODNAME varchar2(64) default NULL,
METHODDSC varchar2(4000) default NULL,
ARGUMENTS clob default NULL,
RETVAL varchar2(4000) default NULL,
PAYLOAD blob default NULL,
CTXPAYLOAD varchar2(4000),
DYES timestamp default NULL,
THREADNAME varchar2(128) default NULL
);
DROP TABLE WLS_HVST;
CREATE TABLE WLS_HVST (
RECORDID number NOT NULL,
TIMESTAMP number default NULL,
DOMAIN varchar2(64) default NULL,
SERVER varchar2(64) default NULL,
TYPE varchar2(64) default NULL,
NAME varchar2(250) default NULL,
ATTRNAME varchar2(64) default NULL,
Search WWH ::
Custom Search