What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 Oracle General 2927What would you use to improve performance on an insert statement that places millions of rows into that table?
1 Oracle General 3023In what script is snap$ created? In what script is the scott/tiger schema created?
Oracle General 2240If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Oracle General 1653How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Oracle General 1464You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
1 Oracle General 8013I 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 Oracle General 3161