Oracle Applications DBA

Monday, 14 November 2016

Querry to find the Last executed SQL statement from particular schema or table

SELECT CREATED, TIMESTAMP, last_ddl_time
FROM all_objects
WHERE OWNER = 'EXSCHEMA'
AND OBJECT_TYPE = 'TABLE'
AND OBJECT_NAME = 'EMPLOYEE_TABLE';
Posted by Vetrivel Subramani | Cloud Enthusiast at 16:16:00
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

142,454

Blog Archive

  • ►  2020 (1)
    • ►  March (1)
  • ►  2019 (3)
    • ►  September (2)
    • ►  January (1)
  • ►  2018 (8)
    • ►  November (3)
    • ►  July (2)
    • ►  June (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2017 (19)
    • ►  December (1)
    • ►  September (2)
    • ►  July (6)
    • ►  June (3)
    • ►  April (3)
    • ►  March (3)
    • ►  January (1)
  • ▼  2016 (29)
    • ►  December (2)
    • ▼  November (5)
      • Querry to find the Last executed SQL statement fro...
      • Database: Query to get current session ID, Process...
      • Database: Query to find the Long running query
      • EBS: Query to find the CPU usage of the user
      • Short Names of Oracle E-Business Suite Modules
    • ►  September (5)
    • ►  July (1)
    • ►  June (12)
    • ►  May (1)
    • ►  February (3)
  • ►  2015 (18)
    • ►  October (7)
    • ►  June (11)
  • ►  2014 (1)
    • ►  July (1)

About Me

My photo
Vetrivel Subramani | Cloud Enthusiast
View my complete profile

Search This Blog

Picture Window theme. Powered by Blogger.