How Knowledge Sharing Improves Our Own Learning

Knowledge is a familiarity, awareness, or understanding of someone or something, such as facts (propositional knowledge), skills (procedural knowledge), or objects (acquaintance knowledge).

The term "knowledge" can refer to a theoretical or practical understanding of a subject.
knowledge is non quantifiable , how much knowledge is held by someone can not be determine in exact metric but it can be justified by once expression in accordance to situation.

Top 10 most common tasks performed by any DBA

Administrators of Oracle , MySQL , MS-SQL , DB2 , Postgress or any other database technology have following duties in common to deal, with only change in architecture and command lines to manage them.


  1. Monitoring


Database monitoring has huge significance in database administrations , if not done efficiently it can lead to service outage i.e. application unavailability to users.

Days are gone when DBA used to monitor the database manually through a checklist after every hour or two and making note of DB server load , locking/ blocking sessions , OS mount point utilization , tablespace / container space consumption , Archive log utilization , errors in logs etc . 

Top 30 Oracle 19c feature quick look to make dba life easy

 #1 Dynamic fast_start_failover setting to allow changing standby database without need of stopping and starting the data guard broker. 


 #2 Observe-only mode to discover any failures anticipated during fail over without performing actual transition to available standby database. 


 #3 Propagate restore point to standby which was created in primary database to perform point in time recovery. This allows standby to be restored back to the same state as primary using restore point information kept in control file.


 #4 Standby db flashback when primary flashbacks which helps dba by avoiding overhead task of re-creating standby database.

ORA-12899: value too large for column due to 12c char to data length conversion setting

ORA- Error:

ORA-12899: value too large for column "NSM_USER"."NSM_DOC_TYPE_TAB"."DIVISION" (actual: 103, maximum: 100)




Cause :

Table was created with explicit CHAR mentioned in VARCHAR2 data type.

1 CHAR is 4 BYTES.  

create table NSM_DOC_TYPE_TAB (

STATUS varchar2(32 char),   

CMS_CODE       varchar2(10 char),     

DIVISION    varchar2(100 char),   

DEPT   varchar2(255 char)                    

);        

iPhone Vs Android ... Vote & Know More

The two most powerful mobile operating device around the world, Lets find out their comparison and Vote your favorite !