Log metrics

2023-07-28 02:55:42  Updated

The GV$SYSSTAT view helps you view the syslog metrics.

obclient> select CON_ID,CLASS,STAT_ID,NAME,VALUE,VALUE_TYPE from v$sysstat where class=128 and stat_id > 160000 and stat_id < 170000 and con_id=1;
+--------+-------+---------+-----------------------------------------------+-----------+------------+
| CON_ID | CLASS | STAT_ID | NAME                                          | VALUE     | VALUE_TYPE |
+--------+-------+---------+-----------------------------------------------+-----------+------------+
|      1 |   128 |  160001 | oblogger log bytes                            | 205153873 | SET_VALUE  |
|      1 |   128 |  160002 | election log bytes                            |    482464 | SET_VALUE  |
|      1 |   128 |  160003 | rootservice log bytes                         | 222306504 | SET_VALUE  |
|      1 |   128 |  160004 | oblogger total log count                      |    418151 | SET_VALUE  |
|      1 |   128 |  160005 | election total log count                      |       521 | SET_VALUE  |
|      1 |   128 |  160006 | rootservice total log count                   |   1068461 | SET_VALUE  |
|      1 |   128 |  160007 | async tiny log write count                    |         0 | SET_VALUE  |
|      1 |   128 |  160008 | async normal log write count                  |         0 | SET_VALUE  |
|      1 |   128 |  160009 | async large log write count                   |         0 | SET_VALUE  |
|      1 |   128 |  160010 | async tiny log dropped count                  |         0 | SET_VALUE  |
|      1 |   128 |  160011 | async normal log dropped count                |         0 | SET_VALUE  |
|      1 |   128 |  160012 | async large log dropped count                 |         0 | SET_VALUE  |
|      1 |   128 |  160013 | async active tiny log count                   |         0 | SET_VALUE  |
|      1 |   128 |  160014 | async active normal log count                 |         0 | SET_VALUE  |
|      1 |   128 |  160015 | async active large log count                  |         0 | SET_VALUE  |
|      1 |   128 |  160016 | async released tiny log count                 |         0 | SET_VALUE  |
|      1 |   128 |  160017 | async released normal log count               |         0 | SET_VALUE  |
|      1 |   128 |  160018 | async released large log count                |         0 | SET_VALUE  |
|      1 |   128 |  160019 | async error log dropped count                 |         0 | SET_VALUE  |
|      1 |   128 |  160020 | async warn log dropped count                  |  65398852 | SET_VALUE  |
|      1 |   128 |  160021 | async info log dropped count                  |   3042983 | SET_VALUE  |
|      1 |   128 |  160022 | async trace log dropped count                 |      1163 | SET_VALUE  |
|      1 |   128 |  160023 | async debug log dropped count                 |         0 | SET_VALUE  |
|      1 |   128 |  160024 | async log flush speed                         |         0 | SET_VALUE  |
|      1 |   128 |  160025 | async generic log write count                 |   1475793 | SET_VALUE  |
|      1 |   128 |  160026 | async user request log write count            |         0 | SET_VALUE  |
|      1 |   128 |  160027 | async data maintain log write count           |         1 | SET_VALUE  |
|      1 |   128 |  160028 | async root service log write count            |         0 | SET_VALUE  |
|      1 |   128 |  160029 | async schema log write count                  |     11339 | SET_VALUE  |
|      1 |   128 |  160030 | async force allow log write count             |    138931 | SET_VALUE  |
|      1 |   128 |  160031 | async generic log dropped count               |  68422128 | SET_VALUE  |
|      1 |   128 |  160032 | async user request log dropped count          |         0 | SET_VALUE  |
|      1 |   128 |  160033 | async data maintain log dropped count         |         0 | SET_VALUE  |
|      1 |   128 |  160034 | async root service log dropped count          |         0 | SET_VALUE  |
|      1 |   128 |  160035 | async schema log dropped count                |     20870 | SET_VALUE  |
|      1 |   128 |  160036 | async force allow log dropped count           |         0 | SET_VALUE  |
|      1 |   128 |  160037 | async tiny log write count for error log      |         0 | SET_VALUE  |
|      1 |   128 |  160038 | async normal log write count for error log    |         0 | SET_VALUE  |
|      1 |   128 |  160039 | async large log write count for err/or log    |         0 | SET_VALUE  |
|      1 |   128 |  160040 | async tiny log dropped count for error log    |         0 | SET_VALUE  |
|      1 |   128 |  160041 | async normal log dropped count for error log  |         0 | SET_VALUE  |
|      1 |   128 |  160042 | async large log dropped count for error log   |         0 | SET_VALUE  |
|      1 |   128 |  160043 | async active tiny log count for error log     |         0 | SET_VALUE  |
|      1 |   128 |  160044 | async active normal log count for error log   |         0 | SET_VALUE  |
|      1 |   128 |  160045 | async active large log count for error log    |         0 | SET_VALUE  |
|      1 |   128 |  160046 | async released tiny log count for error log   |         0 | SET_VALUE  |
|      1 |   128 |  160047 | async released normal log count for error log |         0 | SET_VALUE  |
|      1 |   128 |  160048 | async released large log count for error log  |         0 | SET_VALUE  |
+--------+-------+---------+-----------------------------------------------+-----------+------------+
48 rows in set (0.05 sec)

Contact Us