admin管理员组

文章数量:1401654

From the DBA_AUDIT_TRAIL table we found that some process is running every second, connecting to DB and does some transactions. What i see in DBA_AUDIT_TRAIL table, ACTION_NAME column as "LOGON or LOGOFF", and in PRIV_USED is "CREATE_SESSION". In prod, it is like 2 servers, and 2 entries (Logon and Logoff) per server, so for an hour, 4 x 60 x 60 = 14,400 logins. I could not find which process or code is doing this, so is there any other "DBA_" table that has details of transactions, like what happens after each logon and before logoff? If i could find the statements/transaction, like Select from table A, or update table A, using that i can figure out which process. Is there any way to figure this out?

Further analyzing, found that there is no action (SELECT, INSERT..) taking place after LOGON(Establishing connection with DB) So i am guessing this could be some spring boot oracle/my-batis config, or AutoSys from where the spring boot app API's are triggered.

本文标签： spring bootORACLE how to find the transactions from the DBA tablesStack Overflow

版权声明：本文标题：spring boot - ORACLE how to find the transactions from the DBA tables - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744232702a2596413.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。