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 !!!


ORA-04023: Object could not be validated or authorized



ORA- Error:


SQL>SELECT DAT.*,DATE_MODE||';'||SYS_META_KEY MIS_XDISPARE
FROM MIS_SYS_DATA DAT WHERE 1 = 0 

ORA-04023: Object could not be validated or authorized

Bermuda Triangle The Mystery Solved ?

What is Bermuda Triangle ?


The Bermuda Triangle, also known as the Devil's Triangle or Hurricane Alley, is a loosely defined region in the western part of the North Atlantic Ocean where a number of aircraft and ships are said to have disappeared under mysterious circumstances.

Where is Bermuda Triangle Located ?

About 500,000 square miles of ocean off the southeastern tip of Florida , In Atlantic Ocean roughly bounded by Miami, Bermuda and Puerto Rico. The total area varying from 1,300,000 to 3,900,000 km (500,000 to 1,510,000 sq mi)."Indeed, some writers even stretch it as far as the Irish coast."











(Graphical Image of Bermuda Triangle)


                                                                                                                            



 (Satellite Image of Bermuda Triangle)




Who found Bermuda Triangle ?