Total Answers Posted # 0
Total Answers Posted for My Questions # 198
Total Views for My Questions # 441162
Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
DB Administration 1511Which dictionary tables and/or views would you look at to diagnose a locking issue?
2 DB Administration 5387An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
1 DB Administration 4591You're getting high "busy buffer waits" - how can you find what's causing it?
1 DB Administration 4739What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
1 DB Administration 3817Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
DB Administration 1547Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
DB Administration 1750Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
DB Administration 1493How do you increase the OS limitation for open files (LINUX and/or Solaris)?
1 DB Administration 3641Provide 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.
DB Administration 1504Which environment variables are absolutely critical in order to run the OUI?
2 DB Administration 3506
