Quest_in_OracleDBA

Friday, August 9, 2013

IOT (Index Organized Tables) Explained.

A nice link on IOT's:

http://mwidlake.wordpress.com/2011/07/18/index-organized-tables-the-basics/
Posted by Dba Satheesh at 11:38 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: ORACLE, Oracle Performance tuning

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

My other Blog

  • Vivasaayam

Search This Blog

About Me

My photo
Dba Satheesh
View my complete profile

For consulting services or trainings related to Oracle

For consulting services or trainings related to Oracle

Total Pageviews

Labels

  • cloud database migration
  • Hadoop/Bigdata
  • Installation
  • Interview questions
  • Invalid Objects
  • Job openings
  • MariaDB
  • Migration
  • Motivation
  • MySQL
  • mysql failover
  • ORACLE
  • Oracle 12 C New features
  • Oracle 12c
  • oracle ACLs
  • Oracle architecture
  • Oracle backups
  • Oracle Block Corruption
  • oracle database
  • Oracle database health check
  • Oracle database Switch over procedure
  • Oracle Datagaurd- Standby database
  • Oracle DBA Interview questions
  • Oracle DBA query collection
  • oracle enqueue
  • Oracle errors and solutions
  • Oracle Golden gate
  • Oracle indexes
  • Oracle jobs
  • Oracle Licensing information
  • Oracle Listener
  • Oracle Materialized view queries
  • Oracle OraInventory
  • Oracle Performance tuning
  • Oracle queries
  • Oracle RAC
  • Oracle RAC upgrade
  • Oracle Row chaining
  • Oracle sessions related
  • oracle tables
  • oracle users and privileges
  • recovery
  • Recruitment
  • Reference
  • Resize standby redolog
  • RMAN
  • RMAN duplication
  • RMAN FULLBACKUP SCRIPT
  • rman restore and recovery
  • sqlserver
  • sqlserver error and solutions
  • sqlserver restart time
  • sqlserver servicepack
  • sqlserver transactionlogs
  • statspack
  • Tablespace
  • unix for dba - www.oracle.com/technology/dba/index.html
  • Unix/Linux Related
  • Windows

Blog Archive

  • ►  2022 (15)
    • ►  May (1)
    • ►  April (7)
    • ►  March (7)
  • ►  2016 (11)
    • ►  March (1)
    • ►  February (8)
    • ►  January (2)
  • ►  2015 (103)
    • ►  November (3)
    • ►  October (9)
    • ►  September (18)
    • ►  August (21)
    • ►  July (7)
    • ►  June (15)
    • ►  April (7)
    • ►  March (12)
    • ►  February (9)
    • ►  January (2)
  • ►  2014 (87)
    • ►  December (3)
    • ►  November (4)
    • ►  October (11)
    • ►  September (1)
    • ►  August (6)
    • ►  July (10)
    • ►  June (22)
    • ►  May (4)
    • ►  April (4)
    • ►  March (7)
    • ►  February (8)
    • ►  January (7)
  • ▼  2013 (172)
    • ►  November (1)
    • ►  October (15)
    • ►  September (15)
    • ▼  August (65)
      • Useful blog
      • Manual Upgrade of 11g (11.2.0.3 to 12c)
      • Oracle Golden Gate GGSCI commands
      • Archivelog Generation
      • NoLogging and Materialized Views
      • MultiBlock Read Count
      • Oracle Histograms and Why???
      • Export Statistics In Oracle (Lock and Unlock Stati...
      • AWR VS ASH
      • Oracle 11g R2 Silent Installation
      • Oracle 11.2.0.4 Released( Terminal Patchset for 11...
      • Architectural Diagrams
      • What is Snap Shot Too Old Error (ORA-01555)
      • Unix Commands for DBA
      • MySQL INNODB_FILES_PER_TABLE Explained
      • Oracle Latches and Mutexes
      • Interview Questions
      • RMAN Interview questions
      • Oracle 12c: Move Datafile online
      • Setup MySQL Replication
      • Pluggable Architecture
      • Oracle Database Limits for 11g
      • Oracle Database Limits(Physical/Logical) for both ...
      • Oracle 12c: How to change open mode of all databas...
      • How SQL Statement works internally in ORACLE
      • Oracle RAC with OCR mirrored by ASM pitfalls
      • Top 10 Biggest Databases in the WORLD
      • Scope of ORACLE DBA?????
      • Oracle Interview Questions
      • Oracle SCN Explained
      • Bitmap Indexes Vs B-Tree indexes
      • Loss of Undo tablespace datafile and Process to re...
      • Move LOB Segment and Index to a different tablespace
      • Find tables with Fragmentation/Chained Rows and Fix
      • Some Information on Index Rebuilding... Which Coll...
      • Index Rebuild Scripts
      • Draft...
      • Oracle 12c: What Happened to All the background Pr...
      • Oracle 12c Deprecated Parameters and Features( fro...
      • RMAN 12c Restrictions on PDB(Pluggable DataBase)
      • Why is my SYSAUX tablespace So bigg.. Is it worth ...
      • IOT (Index Organized Tables) Explained.
      • Cloudera distribution for Hadoop
      • Map and Reduce Phase
      • Pig.. A comparision with SQL Pig vs Hive
      • HDFS Read and Write..Explained
      • Hadoop Eco-System MAP..
      • How HDFS works????
      • Motivational...Nice Video
      • Oracle 12c...All in One links from Oracle Alchemis...
      • Start and Stop a Pluggable Database in Oracle 12c
      • Backup and Recovery Brief Picture.
      • Oracle Licensing Information
      • Automating DB Startup/Shutdown procedures
      • Upgrading Oracle RAC database 11.2.0.2 to 11.2.0.3...
      • Change IP Address of SCAN in 11g R2 RAC
      • Auditing DBA's - Steps to be followed. (Auditing D...
      • VMSTAT Explained
      • ACFS OVerview
      • Metalink ID'S
      • Oracle 11g RAC Performance
      • MySQL Architecture
      • What is BigData????
      • MySQL Backup and Migration
      • MySQL backup with Version control SCript
    • ►  July (27)
    • ►  June (20)
    • ►  May (26)
    • ►  April (2)
    • ►  February (1)
  • ►  2012 (21)
    • ►  November (1)
    • ►  October (3)
    • ►  September (3)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (1)
    • ►  February (1)
    • ►  January (3)
  • ►  2011 (52)
    • ►  December (3)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (6)
    • ►  May (38)
  • ►  2009 (6)
    • ►  November (6)

Popular Posts

  • RAC : 11gR2 Clusterware Startup Sequence
    RAC : 11gR2 Clusterware Startup Sequence For whoever that has worked with the 11gR2 version of RAC , has ran into the startup sequence ...
  • Oracle Licensing Information
    2  Options and Packs This chapter describes the separately licensed Oracle Database options, management packs, and other products you can pu...
  • Top 10 Biggest Databases in the WORLD
    hrough your life, you may have come across some very large collections. These collections can vary from things that you use in your day to ...
  • Oracle PSU patching - Oracle 11gR2 GRID environment - 3 node RAC
    Overview: 1.Download psu patch and interim patch 2.Move to server 3.Check for conflict patch 4.Bring down the instance on each node  to ro...
  • Move LOB Segment and Index to a different tablespace
    How to move a lob segment and a lob index to a differrent tablespace. ===================================================================== ...
  • Oracle Database 11.2.0.4 installation on Oracle Solaris Sparc server
    Oracle Database Quick Installation Guide 11 g  Release 2 (11.2)   for Oracle Solaris on SPARC (64-Bit) Reference: Oracle support link...
  • Oracle 11.2.0.4 Released( Terminal Patchset for 11g R2)
    For further information about Release Schedules and Maintenance refer to “Release Schedule of Current Database Releases (Doc ID 742060.1)”....
  • RMAN - Clone an Oracle database using a cold backup (same server)
    Clone an Oracle database using a cold backup (same server) This procedure will clone a database using a cold copy of the source database f...
  • Upgrading Oracle RAC database 11.2.0.2 to 11.2.0.3 (Grid+DB)
    A nice link to demonstrate: http://www.gokhanatil.com/2011/09/upgrading-oracle-rac-database-11202-to.html
  • TNS Error: ORA-609 TNS-12537
      11g: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments
Powered By Blogger

Contact Form

Name

Email *

Message *

Followers
Simple theme. Powered by Blogger.