Skip to primary content
Skip to secondary content

ORACLE-LEARN

Welcome to our oracle learning world !

ORACLE-LEARN

Main menu

  • Home
    • About
    • Timeline
    • Appreciation
    • Disclaimer
  • Library
    • Oracle Documentation
    • FAQ
      • DBA FAQ
      • Backup and Recovery FAQ
      • Dataguard FAQ
      • Oracle GoldenGate FAQ
      • Oracle RAC
      • RAC One Node
      • MySQL FAQ
      • Postgres FAQ
      • MSSQL FAQ
  • RDBMS
    • Oracle
      • Oracle11g
        • Oracle DB Admin-Data Dictionary
        • Oracle DB Admin Advance
        • application support
        • Oracle Streaming Admin
        • Oracle ASM
        • Oracle RAC
          • Three Node Oracle RAC
        • Golden Gate
      • Oracle12c
        • New features
        • Upgrade to Oracle Database 12c
        • MultiTenant Architecture
          • CDB and PDB Administration
        • In-Memory Option
        • Oracle12c RAC
          • Oracle12c Upgrade Workshop (11.2.0.3.0 to 12.1.0.2.0)
        • Oracle Database 12c Administrator Certified Professional Exam
      • OCM
        • Server Configuration
        • Enterprise Manager Grid Control
        • Managing Database Availability
        • Data Management
        • Data Warehouse Management
        • Grid Infrastructure and ASM
        • Performance Tuning
        • Data Guard
      • Oracle Timesten
        • Timesten R&D
    • Postgres
      • PostgreSQL Administration
      • PostgreSQL HA
        • PostgreSQL Active – Passive deployment
    • MySQL
      • MySQL Administration
      • Backup and Recovery
        • MySQL Backup and Recovery
      • MySQL Database on SAN
      • MySQL Optimization
      • MySQL Cluster – Hands on
    • MSSQL
    • Sybase ASE
  • Operating System
    • Linux
      • Red Hat Cluster Suite
      • Bonding Configuration
      • Heartbeat Clustering in Linux
    • Solaris
  • Big Data
    • Storage
    • Mongodb
  • My Activity – OTN Forum
  • Shell Scripting
    • Database Scripting
    • DATAGUARD Scripts
    • Oracle RAC Scripts
  • Presentation
  • Training Program
    • Oracle Database SQL Training Program at Elitecore – Sterlite Tech Ahmedabad
    • Oracle Database PL/SQL Training Program at Sterlite Tech – Elitecore
    • Moving from Oracle11g to Oracle12c Training Program at Sterlite Tech – Elitecore
    • Expert Session in AIOUG Gujarat Chapter, Performance Tuning Meetup
    • Deliver the Industry Expert Session
    • Oracle Database on third party Cloud
    • Effectively Manage the Oracle Database in Cloud
  • OCM 12c Preparation
  • Cloud Architect
    • Oracle Cloud – OCI Notes
      • OCI Database Cloud Services
      • OCI Security Capabilities
      • Multi Cloud Service Mapping
      • My OCI Certifications
      • My AWS Certifications
      • My Azure Certifications
    • ADW -Analytics and Data Warehousing
    • Why OCVS ?
    • Why MDS ?
  • DevOps
    • IaC
    • Terraform – HOL and Notes
  • EXADATA – OCE,OCS
  • Golden Gate – OCS

Category Archives: Database Design

Oracle Performance Comparison between VARCHAR and NUMBER

Posted on February 17, 2015 by hiteshgondalia
Reply
Posted in Database Design, Oracle Performance Tuning | Tagged Oracle Performance Comparison between VARCHAR and NUMBER | Leave a reply

Isolation And Consistency Characteristics of Transaction

Posted on September 2, 2014 by hiteshgondalia
Reply

Oracle Support only two isolation level.
1.) Repeatable Read
2.) Serializable

http://www.youtube.com/watch?v=phZnuHV13rc
http://en.wikipedia.org/wiki/Isolation_(database_systems)

Posted in Database Design, Oracle | Tagged Oracle Isolation Level | Leave a reply

ROWID vs PRIMARY KEY

Posted on July 2, 2014 by hiteshgondalia
Reply

http://www.oracle-base.com/articles/misc/rowids-for-plsql-performance.php

Posted in Database Design, SQL/PL-SQL | Tagged ROWID vs PRIMARY KEY | Leave a reply

ORANA

Aggregated by OraNA

Top 60 Oracle Blogs

Linkedin

Follow me on Linkedin

Recent Posts

  • How the Oracle OCI Proactively protect the customer workload in cloud from day one?
  • Keep your Cloud operation Cost lower with Oracle Bastion Service
  • How to protect your application servers or containers in Cloud?
  • Quick Start for OCI Vault
  • OCI DRG functionality expanded in Oracle Cloud

Follow me on Twitter

My Tweets

Categories

  • 19c (4)
  • Cloud (12)
  • Database Design (3)
  • DATAGUARD (19)
  • DATAPUMP (18)
  • DWH (9)
  • Exadata (7)
  • GoldenGate (3)
  • Linux (31)
  • MySQL (4)
  • OAM (1)
  • OCM 12c Preparation (6)
  • Oracle (210)
    • Hardware Tech (13)
    • Networking (3)
    • Oracle RAC (112)
  • Oracle Application (1)
  • Oracle Performance Tuning (57)
  • Oracle Security (9)
  • Oracle Stream (7)
  • Oracle Timesten (1)
  • Oracle Upgrade (4)
  • Oracle11g (5)
  • Oracle12c (34)
  • PostgreSQL (2)
  • RMAN (37)
    • Backup and Recovery (18)
  • Solaris (1)
  • SQL/PL-SQL (33)
  • Storage (2)

Archives

Blog Stats

  • 275,904 hits

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 38 other followers

Follow ORACLE-LEARN on WordPress.com

Follow me on Twitter

My Tweets
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • ORACLE-LEARN
    • Join 38 other followers
    • Already have a WordPress.com account? Log in now.
    • ORACLE-LEARN
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar