CLIENT_LOG

Column Name	Data Type	Field Length	Not Null?	Comments
ID	NUMBER	22	N	Constraint 'client_log_pk' added. With vers. 10.2
CREATED_DATE	DATE
CLIENT_TYPE	VARCHAR2	20
MESSAGING_TYPE	VARCHAR2	20
CLIENT_NAME	VARCHAR2	20
CLASS_NAME	VARCHAR2	200
REQUEST	CLOB
RESPONSE	CLOB
ELAPSED	NUMBER
OUTCOME	VARCHAR2	50
REQUEST_ID	VARCHAR2	100

CREATE INDEX CLIENT_LOG_INDEX1 ON CLIENT_LOG
(OBJECT_ID);
CREATE INDEX CLIENT_LOG_INDEX2 ON CLIENT_LOG
(CLIENT_NAME);

New generic table in Vs. 10.1 for logging requests / responses from any kind of third party clients.

Core Database