Avoid getting infected by Corona virus disease by following these 7 simple habits : a personal experience






The coronavirus COVID-19 is affecting 213 countries and territories around the world and 2 international conveyances which can be tracked from world corona tracker.





Let's know more about corona virus and how it impacts human body followed by the habits which can prevent us from getting infected by life threatening corona virus disease as "prevention is better than cure"

ORA-01489: result of string concatenation is too long using listagg function oracle


ORA- Error: 


1.
SQL>select listagg(description,',' ) within group (order by description) from mis_report_2020;

select listagg(
description,',' ) within group (order by description) from mis_report_2020

*
ERROR at line 1:
ORA-01489: result of string concatenation is too long





2.
SQL> select listagg(description,',' ON OVERFLOW TRUNCATE) within group (order by description) from mis_report_2020;

select listagg(
description,',' ON OVERFLOW TRUNCATE) within group (order by description)  from mis_report_2020


*
ERROR at line 1:
ORA-00907: missing right parenthesis



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.