What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 DB Administration 5327What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 DB Administration 5190What are the commands you'd issue to show the explain plan for "select * from dual"?
DB Administration 1723In what script is "snap$" created? In what script is the "scott/tiger" schema created?
DB Administration 1946If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
1 DB Administration 2594How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 DB Administration 2785You create a private database link and upon
connection, fails with: ORA-2085: connects to
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
1 DB Administration 6564From the database level, how can you tell under which time zone a database is operating?
1 DB Administration 3635Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
DB Administration 1979