Oracle Application DBA Information

Friday, 12 April 2019

How to Find Last Analyzed Table Date In Apps R12

This query is finding the last analyzed Date in Apps R12:


select owner,table_name,last_analyzed, global_stats
from dba_tables
where owner not in ('SYS','SYSTEM')
order by owner,table_name;
Posted by appsdba.furqan at 03:23
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
appsdba.furqan
View my complete profile

Blog Archive

  • ►  2024 (15)
    • ►  February (1)
    • ►  January (14)
  • ►  2023 (4)
    • ►  December (4)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (15)
    • ►  November (5)
    • ►  September (7)
    • ►  August (1)
    • ►  January (2)
  • ▼  2019 (30)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
    • ►  June (14)
    • ►  May (3)
    • ▼  April (7)
      • Dbms_Scheduler.Create_Job The dbms_s...
      • adcfgclone Fails on Apps Tier with Error : sqlplus...
      • Passwordless permissions (ssh) On Linux 5/6/7 64Bit
      • How to Find Last Analyzed Table Date In Apps R12
      • Ping test in a shell script
      • Create a symbolic link in Unix
      • APP-FND-00204: Concurrent Manager encountered an e...
    • ►  January (1)
  • ►  2018 (13)
    • ►  August (1)
    • ►  July (1)
    • ►  June (11)
  • ►  2017 (31)
    • ►  December (2)
    • ►  November (22)
    • ►  March (7)
  • ►  2016 (66)
    • ►  October (9)
    • ►  August (4)
    • ►  July (19)
    • ►  May (34)
Simple theme. Powered by Blogger.