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'
The Linux open source operating system, or Linux OS, is a freely distributable, cross-platform operating system based on Unix
SELECT owner, mview_name, last_refresh_date
FROM all_mviews
where mview_name like 'MATERIALIZED_VIEW_NAME'
My Profile
-
Best Practice for stopping and starting Netbackup Stopping Netbackup Service /usr/openv/netbackup/bin/bp.kill_al Stopping The VERITAS Privat...
-
1) Right Click the VM 2) Select Edit Settings a. Click Options b. Select Boot Options c. Set the Power-on Boot Delay to 5000ms (5 seconds) d... -
Shutdown and Restart Solaris init (runs the shutdown scripts in /etc/rc*) init 0 (shutdown (on sparc it takes it to the ok prompt) init s (s...
-
SOL Commands SQL : Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle datab... -
Oracle Reports is shipped with a collection of PL/SQL constructs that contain many functions, procedures, and exceptions that you can refere...
-
Oracle Identity Manager automates access rights management, security, and provisioning of IT resources. This chapter provides an overview of... -
Concepts and Architecture What is ADF? Oracle ADF is an end-to-end development framework, built on top of the Enterprise Java platform, o...
-
Data Synchronization Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...
-
Veritas NetBackup OpsCenter upgrade Pre-Checks: 1. OpsCenter should run on same version as Netbackup is running or should run on higher vers... -
FNDCPASS system/***** SYSTEM APPLSYS ***** +----------------------------------------------------------------------------+ Working... Oracle ...
Linux
- ACFS
- ADF
- ADOP
- ADR
- ADRCI
- AIX
- Amazon Web Services (AWS)
- Apps DBA
- Backup
- BI Publisher
- bp commands
- Career
- Cloud Computing
- Cluster
- Concurrent Manager
- Daily
- Data Guard
- Database Backup
- Datasource
- Decommissioning
- ESXi - Hypervisor
- Flash Recovery Area
- Flash Recovery Area (FRA)
- FNDCPASS
- FNDLOAD
- Forms
- FRA
- Framework
- Google Compute Engine (GCE)
- Health Checks
- High Availability
- Http Server
- Iaas
- Install
- Interview Question
- Java EE
- Java Web Start
- JDeveloper
- JDK
- JNLP
- JSP
- Linux
- lsinventory
- Media Server
- Monitoring
- Monthly
- nbdecommission
- nbsetconfig
- Netbackup
- OBIA
- OBIEE
- ODI
- OEL
- OFA
- Office 365
- Online-Oracle-DBA
- opatch
- OpsCenter Server
- ORA-
- ORAchk
- Oracle 11.5.x
- Oracle 12.1.x
- Oracle 12.2.x
- Oracle Application DBA
- Oracle Business Intelligence (BI)
- Oracle Cloud Infrastructure (OCI)
- Oracle Database
- Oracle Developer
- Oracle Developer Tools
- Oracle E-Business Suite
- Oracle Fusion Application
- Oracle Fusion Applications
- Oracle Identity Management (OIM)
- Oracle Reports
- Oracle SQL
- Oracle Technical
- Oracle Technology World
- Oracle VM
- Oracle Workflow Java Mailer
- PaaS
- Patching
- Personality Development
- PL/SQL
- RAC
- Redhat
- RMAN
- Robots
- Saas
- Security
- Soft Skills
- Solaris
- SQL
- Symantec
- Techstack
- TOP 10
- Troubleshooting
- Tuning
- UNIX
- UNIX And Linux World
- Upgrade
- Veritas
- Virtualization
- WebCenter Content
- WebLogic
- Weekly
- Workflow Notification
- Workflow Notification mailer
- XML Publisher
Blog Archive
-
▼
2019
(
49
)
-
▼
June
(
26
)
- Veritas NetBackup OpsCenter upgrade
- Decommissioning a media server
- bphdb exit status = 5449: The script is not approv...
- Oracle Home inventory is corrupted LsInventorySess...
- Issue with Robots Missing Path
- Netbackup Important Commands and Explanations
- Netbackup Cheat Sheet
- Best Practice for stopping and starting Netbackup
- Oracle E-Business Suite Current patch level
- Defragment Concurrent Tables
- Creating ACL for UTL_SMTP
- Cost Manager Status
- Cost Manager Datafix
- 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
(
26
)
Useful Scripts
Copyright ©
|
Linux Operating System
| Powered by
Blogger: Muqthiyar Pasha
0 comments :
Post a Comment
Note: Only a member of this blog may post a comment.