Knowledge is a familiarity, awareness, or understanding of someone or something, such as facts (propositional knowledge), skills (procedural knowledge), or objects (acquaintance knowledge).
Tabs
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).
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.
#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-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)
);