Learn about oracle query statement logs

Source: Internet
Author: User

The following describes oracle query statement logs. If you are interested in oracle query statement logs, you may wish to take a look. I believe this will help you.

Select * from v $ sqlarea t where t. PARSING_SCHEMA_NAME in ('username') order by t. LAST_ACTIVE_TIME desc

Select * from v $ sqlarea t order by t. LAST_ACTIVE_TIME desc

Note: To execute this statement and other related statements, you must have the DBA permission. Although this statement is common, it can be used in a timely manner to detect the execution of SQL statements by a person.

------- Check the executed SQL in oracle. These SQL statements exist in the Shared Pool --------->
Select * from v $ sqlarea t order by t. LAST_ACTIVE_TIME desc

----------- View oracle sessions ----------------------------

Select * from v $ session t order by t. LAST_ACTIVE_TIME desc

------------- View oracle permission roles ------------------------------>
Select * from dba_role_privs; grant roles to users and other roles
Select * from dba_sys_privs; grant system permissions to users and other roles
Select * from dba_tab_privs; all permissions on objects in the database
Select * from user_role_privs; view the role of the current user
 
The preceding section describes the oracle query statement logs.

Oracle index Optimization Design

16 oracle query date statements

Oracle index type

Step 5: Create an oracle full-text index

How to create an Oracle Index

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.