Shulou(Shulou.com)05/31 Report--

Editor to share with you how to query a user in the past period of time to run the SQL statement, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

With his as (

Select sql_id, sql_exec_start,user_id

From dba_hist_active_sess_history t

Where user_id = (select user_id from dba_users where username = 'JMSS')

And t.sql_exec_start between to_date ('2017-09-09 08000mm hh34miss')

And to_date ('2018-09-09 23000mm hh34miss') order by 2 desc

)

Select * from dba_hist_sqltext where sql_id in (select sql_id from his)

Where username is the user name of a user.

The above is all the contents of the article "how to query the SQL statements that a user has run in the past period of time". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.