H.Tonguç YILMAZ Blog

I moved my Oracle Blog to here http://tonguc.wordpress.com Please dont forget to add my new blog to your rss reader http://reader.google.com

I will consolidate my Oracle related posts in several category series like;

- Oracle Expanded Supplied Packages with 10g Series
Like DBMS_APPLICATION_INFO, UTL_COMPRESS, DBMS_DB_VERSION etc.

- Oracle New Dictionary Enhancements with 10g Series
Like V$OSSTAT, V$SYSMETRIC_HISTORY, V$ACTIVE_SESSION_HISTORY etc.

- Oracle Built-in Functions Series
Like VSIZE, GREATEST, EXTRACT, NVL2, COALESCE etc.

- Oracle SQL Extentions Series
Like Analytic SQL, SQL Model Clause, Regular Expressions, Hierarchical Queries(Oracle Trees) etc.

- Oracle Database Concepts Series
Like ACID properties, Transaction Management, Concurrency, Read Consistency, Locking Mechanisms, Redo, Undo(Rollback), Latch, Enqueue etc.

- There are more than one NUMBER and Character Native Type Series
Like Other Character Datatypes, Other Numeric Datatypes, LOB Datatypes, RAW and LONG RAW Datatypes, ROWID and UROWID Datatypes, XML Datatypes, and also Data Conversion

- There are more than one TABLE Type Series
Like Partitioned Tables, Nested Tables, Temporary Tables, Object Tables, External Tables, Index Organized Tables(IOT)

- There are more than one INDEX Type Series
Like Unique and Nonunique Indexes, Composite Indexes, Function-Based Indexes, Reverse Key Indexes, Bitmap Indexes, Bitmap Join Indexes, Domain Indexes and also Indexes and Nulls

- Oracle Best Practices Series
Like Backup and Recovery with Recovery Manager, High Availability with Data Guard and Real Application Clusters, Automatic Manageability Features like Automatic Storage Management(ASM) and Automatic Segment Space Management(ASSM)

- Oracle Business Intelligence and Extraction, Transformation, Loading(ETL) Series
Like Materialized Views, Table Compression, Parallel Execution, OLAP Capabilities, Data Mining

- Oracle Content Management Series
Like XML in Oracle, LOBs, Oracle Text, Oracle Ultra Search, Oracle interMedia, Oracle Spatial

- Oracle Security Series
Like User Resource Limits and Profiles, Privileges and Roles, Fine-Grained Access(FGA) Control

- Oracle Information Integration Series
Like Distributed SQL, Oracle Streams, Oracle Transparent Gateways and Generic Connectivity

All these topics mentioned above which I plan to study during 2007 is very easy to get immediately familiar with by reading this chapter and guide;

Oracle® Database Concepts 10g Release 2 (10.2)
Chapter 1 Introduction to the Oracle Database