• Home
  • About
  • Contact

Database In Action

~ Integrated Approach to Data

Database In Action

Previous articles

Range Partitioning with DBMS_REDEFINITION Package & Compression

September 21, 2012

validate index OWNER.TABLE_INDEX; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name = ‘TABLE_INDEX’; OPT_CMPR_COUNT OPT_CMPR_PCTSAVE ————– —————- 1 10 select min(LOG_DATE), …

Continue reading →

Rate this:

Optimize Oracle UNDO Parameters

September 12, 2012

I appreciate the post about the undo tunning, here is the link… http://www.akadia.com/services/ora_optimize_undo.html

Rate this:

Finding Optimum Compression Level & Compression PCT Save for Indexes

September 12, 2012

Simple but subtle compress implementation for indexes.. Check it out.. validate index OWNER.INDEX_NAME; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name …

Continue reading →

Rate this:

Grid Control 11.1.0.1.0 Installation and Upgrade

August 17, 2012

Oracle® Enterprise Manager Grid Control Advanced Installation and Configuration Guide 11g Release 1 (11.1.0.1.0) E16847-09 Complete Steps to Install 11.1.0.1 …

Continue reading →

Rate this:

Zone Creation – Solaris 10

July 24, 2012

  Create Zone Paths and assign permissions bash#mkdir /zones/ bash#cd /zones bash#mkdir /zones/bb2 bash#chmod 700 /zones/bb2/ bash#chown root:root /zones/bb2/ Use …

Continue reading →

Rate this:

APEX, formerly HTMLDB – Installing and Migrating HTMLDB schema

July 23, 2012

user@dbserver[/Setups/htmldb]#sqlplus “sys/password as sysdba” SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 14:33:56 2011 Copyright (c) 1982, 2009, Oracle.  All …

Continue reading →

Rate this:

Oracle 9.2.0.8 – 9i Release2 Dataguard Configuration Basics

July 19, 2012

cold copy or begin backup & end backup ->> All .log .dbf Create standby control file ALTER DATABASE CREATE STANDBY …

Continue reading →

Rate this:

AIX ntp Configuration

July 18, 2012

The Time Synchronization Hierarchy         The NTP daemon can not only adjust its own computer’s system time.        Additionally, each daemon …

Continue reading →

Rate this:

Oracle 9.2.0.8 Windows to AIX Migration using EXP/IMP

July 13, 2012

Installation Process: 9.2.0.1 software + 9.2.0.8 PSU patch those you can acquire from MOS. Indeed, for manuel installation process you …

Continue reading →

Rate this:

World Map Of Dominating Websites

July 13, 2012

Rate this:

← Older posts
Newer posts →

Blog Stats

  • 85,727 hits

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

Blogroll

  • AIX Blog
  • Alejandro Vargas
  • Gavin Soorma
  • Mark Rittman
  • Richard Foote
  • Tom Kyte

Recent Posts

  • Weblogic ServerRuntime Monitoring with Shell Script March 9, 2017
  • Creating SQL Plan Baseline (SPB) / Migrating Execution Plan February 15, 2017
  • Handling an Assertion Failure Sybase IQ February 1, 2016
  • Generate / Recreate DDL for all public and private database links with passwords July 24, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 30, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 3, 2014
  • Optimizer Null-Aware Anti Join – ORA-07445: exception encountered: core dump [rwsstd()+40] May 22, 2014

Category Cloud

Apex ASM Database Mirroring and Log Shipping (SQL Server) vs Oracle Dataguard Database Vault Data Guard Datapump Digital Economy EXP/IMP Fusion Grid Control Hadoop Hardware IBM Tivoli TSM Index Internet Inventory Listener Long Datatype Mirroring Monitoring MSSQLServer Oracle Database Partitioning Performance PLSQL Real Application Testing & SQL Performance Analyzer Software Solaris Sql Storage Switchover || Failover Sybase IQ Unix Upgrade Weblogic

Archives

Create a free website or blog at WordPress.com.

Cancel

 
Loading Comments...
Comment
    ×
    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