tag:blogger.com,1999:blog-5532576497841734741.post6985072311639357977..comments2024-01-23T13:36:22.189+01:00Comments on Joords Oracle DBA blog: RDBMS and listener log (xml) from SQL*Plus with V$DIAG_ALERT_EXt view [ADR - Automatic Diagnostic Repository]joordsbloghttp://www.blogger.com/profile/08320570930153541164noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5532576497841734741.post-56455030993967214572013-03-27T09:05:21.297+01:002013-03-27T09:05:21.297+01:00Hi Joaquin,
This is correct. The relation of the x...Hi Joaquin,<br />This is correct. The relation of the xml format of the logfile and the external table. The logical structure information. joordsbloghttps://www.blogger.com/profile/08320570930153541164noreply@blogger.comtag:blogger.com,1999:blog-5532576497841734741.post-68150558144660591692013-03-26T15:32:38.197+01:002013-03-26T15:32:38.197+01:00Hi Jos,
You say:
V$DIAG_ALERT_EXT (X$DBGALERTEXT)...Hi Jos,<br /><br />You say:<br />V$DIAG_ALERT_EXT (X$DBGALERTEXT) is done by External table referencing log*.xml files. Effectively indexed by alert date, so date-based queries are “efficient and performant.”<br /><br />External tables can't be indexed? What do you mean?<br /><br />Cheers<br />Joaquin Gonzalez<br /><br />Joaquin Gonzalezhttps://www.blogger.com/profile/12638256027643700661noreply@blogger.com