querying centralised log database for recent alarms

[drew]

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

[Marco64]

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.