Hurriyet

11 Mart 2015 Çarşamba

Oracle Database: Reading X$DBGALERTEXT Table - Reading Alert Log Via SQL - SQL ile Alert.log'ları okumak



With Oracle Database 11g, we can read the alerts which are critical for us from a table. In the prior editions, we had to parse the table so that we could extract the information that we need but we can access it directly.

How to read from x$dbagalertext?

 In order to read from x$dbagalertext we need to be a user who is sys or sys privileged. However we could also access to the x$dbagalertext by creating a  view so that we can query it.(Ref-1)

References:

 1- Reading from x$dbagalertext from a use who is not "sys"  privileged.

https://community.oracle.com/thread/2356037

2-  Alert Log Reading

http://www.oradba.ch/2013/07/query-alert-log-from-sqlplus/

3-  Reading alert log

http://blog.tanelpoder.com/2009/03/21/oracle-11g-reading-alert-log-via-sql/
Gönderen zaman:
Etiketler: ,

1 yorum:

  1. Unknown24 Şubat 2020 10:18

    Do this hack to drop 2lb of fat in 8 hours

    Well over 160000 women and men are losing weight with a simple and SECRET "water hack" to lose 1-2lbs each night while they sleep.

    It is simple and it works on everybody.

    This is how you can do it yourself:

    1) Hold a glass and fill it up half glass

    2) Then do this strange hack

    so you'll be 1-2lbs thinner the very next day!

    YanıtlaSil

Kaydol: Kayıt Yorumları (Atom)