You are a database administrator managing a set of users on your Oracle database. You notice that some tables created by non-system users are being stored in the SYSTEM tablespace of your database. You understand that non-system user objects should not be stored in the SYSTEM tablespace. You want to ensure that future tables created by non-system users are not stored in the SYSTEM tablespace. You want to accomplish this with the least administrative effort. Which action should you take?
What does it mean when Oracle says, 'Multiplexing control files?' Explain indicating which file lists the control files in Oracle 11g.
You have a user requesting that their password be changed. They will not be in the office until the next Monday but they request that you do this right away, what could you do as a DBA?
You notice that users have been requesting the same query but it appears that it's taking longer to give the results, what could possibly be the problem and how could you resolve it? Explain giving all possibilities.
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.You need to connect to Oracle as one of the users to simulate a problem. Since you don't know the password of the user, how would you connect as that user?
It works by connecting to the database as SYSDBA and switching from an user to another without being required a password.
SQL> CONNECT / as sysdba...