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.
kaushalbhati-oracle-applications-erp.blogspot.com
Oracle Applications Oracle Configurator: Oracle Configurator
http://kaushalbhati-oracle-applications-erp.blogspot.com/2012/05/oracle-configurator.html
Oracle Applications Oracle Configurator. Oracle Applications Oracle Configurator Java J2EE Oracle Application Framework. Wednesday, May 9, 2012. Topics to Learn in Oracle Configurator. Getting Started with Configurator Developer. Preparing BOM Model and Rule Data. Working with Model Structure. Connectivity and Network Models. About Configurator User Interfaces. Configurator Extension Event Bindings. Configurator Extension Command Events. Check my blog for more information. February 22, 2014 at 2:45 AM.
kaushalbhati-oracle-applications-erp.blogspot.com
Oracle Applications Oracle Configurator: July 2012
http://kaushalbhati-oracle-applications-erp.blogspot.com/2012_07_01_archive.html
Oracle Applications Oracle Configurator. Oracle Applications Oracle Configurator Java J2EE Oracle Application Framework. Wednesday, July 25, 2012. Creating Inventory Items and Bills of material. Interface tables for creating inventory and category. MTL SYSTEM ITEMS INTERFACE. MTL ITEM CATEGORIES INTERFACE. Apply below insert query to get your item details in to interface tables. INSERT INTO inv.mtl system items interface (TRANSACTION TYPE,. CUSTOMER ORDER ENABLED FLAG,. CONFIG MODEL TYPE,. SET PROCESS ID,.
kaushalbhati-oracle-applications-erp.blogspot.com
Oracle Applications Oracle Configurator: Configurator Extension to get Profile Options
http://kaushalbhati-oracle-applications-erp.blogspot.com/2012/02/configurator-extension-to-get-profile.html
Oracle Applications Oracle Configurator. Oracle Applications Oracle Configurator Java J2EE Oracle Application Framework. Tuesday, February 7, 2012. Configurator Extension to get Profile Options. First create a profile option through Application Developer. FNDLOAD apps/apps O Y DOWNLOAD $FND TOP/patch/115/import/afscprof.lct yourLdtfilename.ldt PROFILE PROFILE NAME="your profile name" APPLICATION SHORT NAME="application short name". Use Below code to get the profile option value. String appsProfile = null;.