Catégorie : Système

Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches script à lancer sous SQLT :  coe_xfr_sql_profile.sql http://kerryosborne.oracle-guy.com/2010/07/24/sqlt-coe_xfr_sql_profilesql/ https://carlos-sierra.net/2018/12/15/scripts-to-deal-with-sql-plan-baselines-sql-profiles-and-sql-patches/ https://www.bobbydurrettdba.com/2013/07/10/using-coe_xfr_sql_profile-sql-to-force-a-good-plan/

Méthode classique :  select * from table(dbms_xplan.display_awr(sql_id => ‘drur701xgm5nd’, format => ‘ALL’));

spool hist_sess.htmlset markup html onalter session set nls_timestamp_format=’YYYY-MM-DD HH24:MI’;select * from DBA_HIST_ACTIVE_SESS_HISTORY where sample_time between ‘2020-03-09 18:00’ and ‘2020-03-12 17:01’; set markup html offspool off

set serveroutput on size unlimited spool awr_8408_8478.txt declare   dbid number := 644588240; — a remplacer par ton dbid   instance_id number := 1;   l_premier number := 8408;   […]

tracer un sql id : exec dbms_sqldiag.dump_trace(p_sql_id=>’tamere’,p_child_number=>0,p_component=>’Compiler’,p_file_id=> »);

Désolé J-F tu avais raison :   select SQL_ID,COST,TIME from DBA_HIST_SQL_PLAN

Researching Further Re-querying v$session_wait, I see that a couple of latches are hot. I will consider one latch children with latch address 19875043200 as an example, and drill down further.   Hang Those […]

ouais

avocat généraliste : 01 64 86 14 05 Le lundi : de 09h00 à 12h00 et de 13h30 à 18h45 Le mardi : de 09h00 à 12h00 et de 13h30 […]

lsdev -Cc disk exemple :  hdisk0 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)hdisk26 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)hdisk27 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)hdisk28 Available C6-T1-01 Hitachi […]