How to avoid getting Dengue Fever and cure it fast : a personal experience

Each year, an estimated 390 million dengue infections occur around the world. Of these, around 5 million cases develop into severe dengue, which results in up to 25,000 deaths annually worldwide.

Dengue Fever is the most dangerous form of fever as it becomes life threatening if not detected in early stages or treatment is delayed. Dengue fever doesn't have medicine to cure it rapidly it has to go through stages of treatment and human immunity response to medicines for recovery matters most.   

To cure from dengue fever the most important step is to prevent it at first , knowing more about dengue helps to attain this step.

What is Dengue Fever ?

Dengue fever is a mosquito borne disease caused by the dengue virus. Dengue virus is primarily transmitted by Aedes mosquito bites.

ORA-01720: grant option does not exist for

ORA- Error:


SQL> GRANT SELECT on MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE;
GRANT SELECT on MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE
*
ERROR at line 1:

ORA-01720: grant option does not exist for 'NEW_ASU_USER.ASU_FINAL_PO_AGR'

SQL>SHOW USER

"NEW_ALT_USER"

Cause:

How to recover from Migraine headache : a personal experience

Over 39% population in world suffers Migraine headache and it has no cure yet in medical science , the only solution is lifestyle correction which can reduce the impact on life.

Various articles cover scientific reason behind Migraine Headache , however i am writing my personal experience how i struggle through the migraine pain and overcome to reduce its frequency from 2-3 times a week to 1-2 time in a month without medicines many times .

How to install Linux on virtual machine in 3 easy steps

Install ubuntu linux using virtual machine on laptop or PC in 3 east steps.  As given in below link or click here

After installing Linux ubuntu virtual host you can use the same for learning UNIX , installing database or application software to improve you hands-on skills.

ORA-13605: The specified task or object does not exist for the current user

ORA- Error:

SQL>Begin
dbms_sqltune.Execute_tuning_task (task_name => 'sql_sta_01151548_85fakm008r9z9');
end;
/

ERROR:
ORA-13605: The specified task or object sql_sta_01151548_85fakm008r9z9 does not exist for the current user.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_ADVISOR", line 5900
ORA-06512: at "SYS.DBMS_SQLTUNE", line 926
ORA-06512: at line 1


Cause/Solution:

I.  The User which is logged into db to create the tuning task doesn't have advisor privilege ; Grant advisor,administer sql tuning set to solve the error

SQL>grant advisor to scott;

SQL>grant administer sql tuning set to scott;

II.  ORA-13605 caused due to ORA-13780 ; as sql statement itself not found in the workload history while creating a tuning task.

SQL> DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id =>'85fakm008r9z9',
scope => 'COMPREHENSIVE',
time_limit => 600,
task_name => 'sql_sta_01151548_85fakm008r9z9',
description => 'Task to tune a query autbywjufccpd');
END;
/ 

ERROR at line 1:
ORA-13780: SQL statement does not exist.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.PRVT_SQLADV_INFRA", line 125
ORA-06512: at "SYS.DBMS_SQLTUNE", line 655
ORA-06512: at line 4


ORA-13780 can be solved by specifying the AWR begin_snap  and end_snap id in create tuning task code to allow tuning task to search for the sql statement in specific range of workload where it exists. 

SQL> DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
begin_snap => 291940,
end_snap => 292266,
sql_id =>'85fakm008r9z9',
scope => 'COMPREHENSIVE',
time_limit => 600,
task_name => 'sql_sta_01151548_85fakm008r9z9',
description => 'Task to tune a query autbywjufccpd');
END;
/ 

PL/SQL procedure successfully completed.



Once tuning task is created successfully, execute the tuning task to get desired result.


SQL>Begin
dbms_sqltune.Execute_tuning_task (task_name => 'sql_sta_01151548_85fakm008r9z9');
end;
/

PL/SQL procedure successfully completed.

Retrieve the Advisory Report ..

SQL>set long 900000
SQL>set linesize 9000
SQL>set pages 9000
SQL>col TUNING_ADVICE_85fakm008r9z9 for a9000
SQL>select dbms_sqltune.report_tuning_task('sql_sta_01151548_85fakm008r9z9') TUNING_ADVICE_85fakm008r9z9 from dual;

PL/SQL procedure successfully completed.

Solved !!!