| Count of error messages [message #230984] |
Fri, 13 April 2007 11:15  |
marks20101
Messages: 74
Registered: May 2005
|
Member |
|
|
ERR_LOG_PID NOT NULL NUMBER(10)
PROCESS_RUN_PID NOT NULL NUMBER(10)
ERR_SVRTY_CODE_PID NUMBER(10)
ERR_SRC_SYS_CODE_PID NUMBER(10)
ERR_RPT_GRP_CODE_PID NUMBER(10)
ERR_TS NOT NULL DATE
SQL_ERR_MSG VARCHAR2(2000)
LOCAL_ERR_MSG VARCHAR2(2000)
How can I get a count of the total different messages, err_log_pid is for the whole log.
|
|
|
|
|
|
| Re: Count of error messages [message #230999 is a reply to message #230984] |
Fri, 13 April 2007 11:58  |
marks20101
Messages: 74
Registered: May 2005
|
Member |
|
|
Yes and the count on the messages.. I was using this...
select local_err_msg,
count(process_run_pid) over (partition by process_run_pid order by process_run_pid) total
from err_log
WHERE TRUNC(ERR_TS) = TO_DATE('13-APR-07','DD-MON-YY')
order by process_run_pid
I'll get back with more details(lay out of the data) tonight...thanks
[Updated on: Fri, 13 April 2007 13:48] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
