• Home
  • About
  • Contact

Database In Action

~ Integrated Approach to Data

Database In Action

Previous articles

VKTM detected a time drift.

December 9, 2013

Problem Summary VKTM detected a time drift. Please check trace file for more details. Download and apply patch # 11837095. …

Continue reading →

Rate this:

Dataguard Delay / Apply and Transport Lag

November 22, 2013

i.e. SQL> set linesize 2000 select sysdate,sum(apply_finish) apply_finish, sum(apply_lag) apply_lag, sum(transport_lag) transport_lag, sum(startup_time) startup_time, min(TIME_COMPUTED) TIME_COMPUTED from ( select decode(name,’apply …

Continue reading →

Rate this:

Delete Duplicate Rows

November 5, 2013

Finding and deleteing the duplicate rows of a table in Oracle Database. DELETE FROM OWNER.TABLEx z WHERE z.ROWID IN (SELECT …

Continue reading →

Rate this:

MRP0: Detected orphaned datafiles!

September 27, 2013

Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback… Errors …

Continue reading →

Rate this:

File # added to control file as UNNAMED

September 24, 2013

Errors in file …/trace/RAPOR_pr00_2801804.trc: ORA-01119: error in creating database file ‘/data/datafile_1.dbf’ ORA-27054: NFS file system where the file is created …

Continue reading →

Rate this:

Difference between Hadoop and RDBMS

April 3, 2013

Hadoop vs RDBMS: RDBMS and Hadoop are different concepts of storing, processing and retrieving  the information. DBMS and RDBMS are …

Continue reading →

Rate this:

Excluding Table Partitions – expdp EXCLUDE=TABLE_DATA

April 3, 2013

Oracle Datapump – Using expdp utility excluding table & table partitions in a par file can be managed with the …

Continue reading →

Rate this:

Physical Dataguard Configuration

January 21, 2013

Some fast and easy configuration scripts for Physical Dataguard installation… PRIMARY Site ALTER SYSTEM SET db_unique_name = DATABASE; ALTER SYSTEM …

Continue reading →

Rate this:

SQLs for Tivoli Storage Manager

December 12, 2012

http://thobias.org –> I really appreciate the post of SQLs for Tivoli Storage Manager. Check out the site http://thobias.org SQLs for Tivoli …

Continue reading →

Rate this:

Digital Economy Rankings 2010 – EIU

September 27, 2012

Digital Economy Rankings 2010 – EIU EIU Digital Economy Rankings – 2010

Rate this:

← Older posts
Newer posts →

Blog Stats

  • 85,185 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
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