Oralce Notes of Paritosh

Notes taken from Mir Hasan tutorials


Popular Databases
1. Oracle
2. DB2
3. Sybase
4. SQL Server
5. Informix

1. One datafile can belong to one Table space only

    2. Segments corresponds to objects like tables, Indexs etc

    3. Minimum two table spaces are required a. SYSTEM &    b. SYSAUX

       (Oracle during default installation creates 6 TableSpaces).

    4.From 11g Onwads - BigFile TableSpace 

              - Max size 128 TB

               - Provides Transparent management ( Manage TableSpace as a Unit without worring about underlying datafiles).

     5. Temporary Table Space - Used for Sort operations ( eg: ORDER BY, UNION, JOIN)

            (If temporary tablespace is not created then SYSTEM tableSpace is used which might slowdown the performance).

SYSTEM TABLE SPACE

Most important table Space, it mandatory table space and contains DATA DICTIONARY.

DataDictionary contains Data about data (Meta Data)

SPACE Management

It can be Dictionary Managed or Locally Managed.

For Dictionary Managed Table Space all the DML operations are managed via EXTENT MANAGEMENT in SYSTEM TableSpace.

For Locally Managed Table Space all the DML operations are managed via EXTENT MANAGEMENT on the same TableSpace

SEGMENT

Smallest Unit of Storage that a End User deals with.

With Oracle 11g ... Rollback Segment is deprecated and Undo Segment is being used.

Program: - Program is a group of Instructions





OralceERP
http://handsonerp.com/oracle-financials-tutorials/

Oracle Application Strength

1. Modular & Integrated
2. Web Enabled
3. Open Standards
4. Localization
5. Multi Language, Multi Currency etc
6. Single Instance - Multiple Companies
7. Multi Node Application

http://oracledbazerotopro.com/oracle-dba-tutorials/62-tables.html?start=1