kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: TABLESPACES
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/tablespaces.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Thursday, January 12, 2012. A tablespace can contain many tables, indexes, and so forth. It has a size that is. Initially assigned by the DBA. As data is inserted and updated, the amount of free. Space in the tablespace diminishes. As the space used reaches 100%, the DBA. May choose to archive rows or expand the tablespace by extending one or more. Existing datafiles or by adding a new datafile to the tablespace. NEXT size of next extent.
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: CREATING YOUR DATABASE
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/creating-your-database.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Thursday, January 12, 2012. The Optimal Flexible Architecture (OFA) model was designed by Oracle to assist. Users in laying out their databases in a way that would support high performance. And ease of maintenance. The Oracle white paper by Cary Millsap entitled “The. OFA Standard” contains the specification in detail. For the purposes of this book,. You will be making use of the characteristics of OFA that identify the logical location.
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: Oracle Server statup modes
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/oracle-server-statup-modes.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Thursday, January 12, 2012. Oracle Server statup modes. Startup nomount Starts the Instance—Creates the SGA and runs the background. Processes after reading the parameters in the. Initora (Instance configuration) file. Startup mount Starts the Instance and mounts the database—Reads the. Control file and identifies the Database files. Startup open Starts the Instance and allows access to the Database for. Users via the Oracle Server.
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: ORACLE NETWORKING: CONFIGURING BASIC NET8/SQL*NET COMPONENTS
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/oracle-networking-configuring-basic.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Thursday, January 12, 2012. ORACLE NETWORKING: CONFIGURING BASIC NET8/SQL*NET COMPONENTS. One of the important components of Oracle networking is the Oracle listener. The listener is the process responsible for receiving database connection requests. And redirecting them to another process, which in turn becomes the main point. Of contact between the client and the database. The process that ultimately services. Into the database, wherea...
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: Oracle server Default DBA Accounts
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/oracle-server-default-dba-accounts.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Thursday, January 12, 2012. Oracle server Default DBA Accounts. SYS CHANGE ON INSTALL SYS owns the data dictionary tables, the. Place where all the information about. Database objects is stored. You should only. Connect to the database as SYS if you are. Explicitly instructed to do so in this book. Or in the Oracle documentation. SYSTEM MANAGER SYSTEM was originally created to maintain. Database objects that support the Oracle.
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: Get Oracle DBA Training
http://kaushal-bhati-oracle-dba.blogspot.com/2012/01/1-intro-2-sql-plus-and-isql-plus-3.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Sunday, January 15, 2012. Get Oracle DBA Training. Topics for the Oracle DBA Training Course(Online Training, Live Sessions). SQL Plus and iSQL Plus. Installing Oracle Software and Creating a Database. Oracle Database and Instance Architecture. Startup, Shutdown, and the Initialization File. Managing Tables, Views, Constraints and Sequences. Triggers, procedures, functions. Oracle's shared server option. Locks, latches, and waits.
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: January 2012
http://kaushal-bhati-oracle-dba.blogspot.com/2012_01_01_archive.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Sunday, January 15, 2012. Get Oracle DBA Training. Topics for the Oracle DBA Training Course(Online Training, Live Sessions). SQL Plus and iSQL Plus. Installing Oracle Software and Creating a Database. Oracle Database and Instance Architecture. Startup, Shutdown, and the Initialization File. Managing Tables, Views, Constraints and Sequences. Triggers, procedures, functions. Oracle's shared server option. Locks, latches, and waits. The li...
kaushal-bhati-oracle-dba.blogspot.com
Oracle DBA Kaushal Bhati: Oracle DBA Training
http://kaushal-bhati-oracle-dba.blogspot.com/p/oracle-dba-training.html
Oracle DBA Kaushal Bhati. All About Oracle DBA,Oracle DBA Training. Topics for the Oracle DBA Training Course(Online Training, Live Sessions). SQL Plus and iSQL Plus. Installing Oracle Software and Creating a Database. Oracle Database and Instance Architecture. Startup, Shutdown, and the Initialization File. Managing Tables, Views, Constraints and Sequences. Triggers, procedures, functions. Oracle's shared server option. Locks, latches, and waits. Backup and Recovery Techniques. March 10, 2014 at 12:16 AM.