Thursday, June 13, 2019
Check Materialized view Refresh
SELECT owner, mview_name, last_refresh_date
FROM all_mviews
where mview_name like 'MATERIALIZED_VIEW_NAME'
SELECT owner, mview_name, last_refresh_date
FROM all_mviews
where mview_name like 'MATERIALIZED_VIEW_NAME'
About Me
Useful Resources
Oracle BI Publisher Fusion Applications Edition
Search This Blog
Blog Archive
-
▼
2019
(42)
-
▼
June
(19)
- Oracle Home inventory is corrupted LsInventorySess...
- Oracle E-Business Suite Current patch level
- Defragment Concurrent Tables
- Creating ACL for UTL_SMTP
- Cost Manager Datafix
- Cost Manager Status
- Core HR SQL Queries
- Concurrent Request Statistics
- Concurrent Program Statestics
- Concurrent Managers Status
- Compile Forms command line
- Concurrent Manager Cleanup Script
- Check Materialized view Refresh
- Check Database Locks
- Cancel Scheduled Concurrent requests
- Assigning Responsibility using FND_USER_PKG
- Archive Log Statastics
- Application Check List
- Adding Report to Request Group using API
-
▼
June
(19)
Best Books
The contents posted in this blog is for informational and/or educational purpose only
| Maintained by Blogger
(Muqthiyar Pasha M)
0 comments :
Post a Comment
Note: Only a member of this blog may post a comment.