You need to shut down the database instantaneously for example if you know a

You need to shut down the database instantaneously

This preview shows page 5 - 7 out of 7 pages.

You need to shut down the database instantaneously (for example, if you know a power shutdown is going to occur in one minute). You experience problems when starting a database instance. When you must do a database shutdown by aborting transactions and user connections, issue the SHUTDOWN command with the ABORT option:
Background image
SHUTDOWN ABORT An aborted database shutdown proceeds with the following conditions: No new connections are allowed, nor are new transactions allowed to be started, after the statement is issued. Current client SQL statements being processed by Oracle are immediately terminated. Uncommitted transactions are not rolled back. Oracle does not wait for users currently connected to the database to disconnect. Oracle implicitly disconnects all connected users. ANSWER 8:A user trace file is produced by the user process connected to the Oracle server through the server process. A user trace file contains statistics for traced SQL statements or user error messages. It is created when a user encounters user session errors. It can also be generated by you or a server process. Its location is defined by USER_DUMP_DEST. Its size is defined by MAX_DUMP_FILE_SIZE and defaults to 10M. If we want to enabling or disabling user tracing: Session level using the ALTER SESSION command: ALTER SESSION SET SQL_TRACE = TRUE Session level by executing DBMS procedure: dbms_system.SET_SQL_TRACE_IN_SESSION Instance level by setting the initialization parameter: SQL_TRACE = TRUE ANSWER 9: These are the UNIX parameter needs to be set in advance:1.Archive Parameters oUse for database recovery oMay also be used for a standby database 2.Data Block Sizing oSets the default database block size oHelps to determine the SORT_AREA_SIZE
Background image
3.File Locations oSpecify paths for trace files oSpecify paths for parameter files 4.Database storage oSpecify storage parameters ANSWER 10:After Oracle database creation, The database contains: Data files, control files, and redo log files User SYS with the password change_on_install User SYSTEM with the password manager Internal tables (but no data dictionary views)
Background image

You've reached the end of your free preview.

Want to read all 7 pages?

  • Spring '18
  • Oracle Database, shutdown command, database shutdown proceeds

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture