In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
1 Oracle General 2770How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Oracle General 1834Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Oracle General 1483Which dictionary tables and/or views would you look at to diagnose a locking issue?
Oracle General 1490An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Oracle General 1626What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Oracle General 1812Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Oracle General 1676Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Oracle General 1544Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Oracle General 1812Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Oracle General 1582