About Instance Shutdown Instance shutdown is the reverse of instance startup. When you shut down the Oracle instance, the default mode is a NORMAL shutdown, which means users are not allowed to create new connections to the database, but the shutdown process waits for all currently connected use...
About Managing Undo Data Although by default Oracle Database manages undo data and the undo tablespace automatically, if your installation uses Oracle Flashback features, then you may have to perform some undo management tasks to ensure ...
About Online Redo Log Files Every Oracle database has a set of two or more online redo log files. The set of online redo log files is collectively known as the redo log for the database. A redo log is made up of redo entries, which are also called redo records. The online redo log stores a copy ...
About Oracle Database Oracle Database is a relational database with object and Extensible Markup Language (XML) capabilities. In a relational database, all data is stored in tables that are composed of rows and columns. Oracle Database e...
About Password Policies When you create a user account, a default password policy is assigned to that user account. The default password policy for a newly installed database includes these directives: ■ The password for the user account expires automatically in 180 days. ■ The user account is ...
About Program Code Stored in the Database Oracle Database offers the ability to store program code in the database. Developers write program code in PL/SQL or Java, and store the code in ...
About Server and Client Processes In addition to background processes, Oracle Database creates server processes that handle the connection requests of user or client processes. A user con...
About Software Management and Patch Releases Software management involves keeping your Oracle Database software up-to-date with the latest product fixes. When a product defect, or a bug, is discovered, a patch is created to fix the probl...
About SQL Developer Oracle SQL Developer is a graphical version of SQL*Plus that gives database administrators a convenient way to perform basic tasks involving schema objects. For example, you can browse, create, edit, and delete (drop) database...
About SQL*Plus SQL*Plus is a command-line program that you use to submit SQL and PL/SQL statements to an Oracle database. You can submit statements interactively or as SQL*Plus scripts. SQL*Plus is installed with the database and is located in your ORACLE_HOME/bin directory. You can start SQL*P...
