querying centralised log database for recent alarms

hi, a bit of a rookie question here

i’m looking to query the centralised log database to elicit and the most recent alarms (the same as those raised by SCI), typically for the last 24 hours. the purpose of this is to port the alarms into a 3rd party monitoring tool (bespoke)

i’ve narrowed down my search to the G_LOG_MESSAGES table on the centralised log database but as you’re probably aware it’s HUGE. i’m currently investigating a way of querying this table effectively in order to display these alarms…

does anyone have any advice / has anyone ever done this before? anything would be appreciated

Best pratices are to partition the Table and then narrowing the query to that active partition. We are quering a big QINFO table in this way:

SELECT LTRIM (TO_CHAR (CONNID, ‘XXXXXXXXXXXXXXXXXXXX’))
FROM QINFO partition (P_20110321)
WHERE LTRIM (TO_CHAR (CONNID, ‘XXXXXXXXXXXXXXXXXXXX’))=‘11701E2FCC980E4’

Other methods will work as well. DBA could work out a “query execution plan” for your needs.