Tags » Tuning

Class tuning 2/21/17: still no sign of subtlety rogues

Death Knight

  • Unholy
    • Virulent Plague damage over time effect has been increased by 67%. Damage unchanged in PvP.
    • Summon Gargoyle: Gargoyle Strike damage has been increased by 50%.
  • 559 more words
Class

SQL TUNING USING DBMS_SQLTUNE

--sqlid
--exec DBMS_SQLTUNE.DROP_TUNING_TASK('STT_TMP_1');
DEFINE v_sql_id='30nf3tqcuj758'

DECLARE
    v_sql_id       VARCHAR2 (13) := '&v_sql_id';
    my_task_name   VARCHAR2 (30);
BEGIN
    my_task_name :=
        DBMS_SQLTUNE.create_tuning_task (sql_id      => '&v_sql_id',
                                         task_name   => 'STT_TMP_1');

    DBMS_SQLTUNE.execute_tuning_task (task_name => my_task_name);
END;
/






--sqltext
--EXEC DBMS_SQLTUNE.DROP_TUNING_TASK('STT_TMP_1');
DECLARE
    my_task_name   VARCHAR2 (30);
    my_sqltext     CLOB;
BEGIN
    my_sqltext := 'select 1 from dual';

    my_task_name :=
        DBMS_SQLTUNE.create_tuning_task (sql_text    => my_sqltext,
                                         task_name   => 'STT_TMP_1');

    DBMS_SQLTUNE.execute_tuning_task (task_name => my_task_name);
END;
/






--historic
SELECT *
  FROM (SELECT snap_id, begin_interval_time, end_interval_time
          FROM dba_hist_snapshot
        ORDER BY snap_id DESC)
 WHERE ROWNUM <= 15;

--EXEC DBMS_SQLTUNE.DROP_TUNING_TASK('STT_TMP_1');

DEFINE v_sql_id='bjf05cwcj5s6p'
DECLARE     my_task_name   VARCHAR2 (30);
     my_sqltext     CLOB;
BEGIN
     my_task_name := DBMS_SQLTUNE.create_tuning_task
                                        (begin_snap   => 62478,
                                         end_snap     => 62479,
                                         sql_id       => '&v_sql_id');

    DBMS_SQLTUNE.execute_tuning_task (task_name => my_task_name);
END;
/



select * from DBA_ADVISOR_TASKS;


--print tuning advice
SET PAGES 1000
SET SERVEROUTPUT ON
ALTER SESSION SET nls_language=american;

DECLARE
    xml_out   XMLTYPE;

    PROCEDURE print_clob (p_clob IN CLOB)
    IS
        v_offset       NUMBER := 1;
        v_chunk_size   NUMBER := 4000;
        v_length       NUMBER;
    BEGIN
        v_length := DBMS_LOB.getlength (p_clob);

        LOOP
            EXIT WHEN v_offset > v_length;
            DBMS_OUTPUT.put_line (
                DBMS_LOB.SUBSTR (p_clob, v_chunk_size, v_offset));
            v_offset := v_offset + v_chunk_size;
        END LOOP;
    END print_clob;
BEGIN
    DBMS_OUTPUT.enable (NULL);
    print_clob (DBMS_SQLTUNE.report_tuning_task ('STT_TMP_1'));
END;
/

ORACLE

beware, this gets technical....

so switch off now, if this type of stuff bores you.

In this blog, I’ve listed some things I’ve learnt when re-building my Cyclemaster engine and some tips that may help you. 842 more words

Cyclemaster

I'll Be Damned... James Taylor's Tuning Works!

A couple of days ago, I wrote an article about how James Taylor tunes his guitars, utilizing the “cents” on the tuner to compensate for the shape of an acoustic guitar, and how the bass notes ring sharper than their tuning, and also to compensate for a capo pulling the strings sharp. 215 more words

Guitars

Index bouncy scan

There’s a thread running on OTN at present about deleting huge volumes of duplicated data from a table (to reduce it from 1.1 billion to about 22 million rows). 1,308 more words

Oracle

Setting up Your New Airforce Rifle/ Tuning an Airgun Without a Chronograph 

So you made the plunge. You threw down some serious cash for a BB gun. You excitedly fill the rifle and take your first shot with premium European pellets. 445 more words

Shooting

Parts worn out?

After stripping the external components i went to get the internals out of the block.

And man, this engine was dirty inside. Dirt is an indicator for worn out cams, bearing shells etc. 696 more words

The Project.