Come cucirae la pizza sulla griglia


      La pizza non manca mai sulla nostra tavola, soprattutto in estate, ma così forse non avete mai osato cucirala! Sorgente: Come cucirae la pizza sulla griglia

DBMS_STATS


The SYSTEM Statistics were stale, once updated the EXPDP flew! I ran the following DBMS jobs (as SYSDBA): EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NULL); EXEC DBMS_STATS.GATHER_DICTIONARY_STATS; EXEC DBMS_STATS.GATHER_SYSTEM_STATS;

Automatic Workload Repository (AWR) in Oracle Database 10g


Workload Repository Reports [oracle@ira 20160530]$ sqlplus /nolog SQL*Plus: Release 10.2.0.5.0 – Production on Tue May 31 09:40:35 2016 Copyright (c) 1982, 2010, Oracle.  All Rights Reserved. SQL> conn /as sysdba Connected. SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~ DB Id    DB Name      Inst Num Instance ———– ———— ——– ———— 3534277614 IRCL              1 ircl1 Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like an HTML report, or a plain text report? Enter ‘html’ for an HTML report, or ‘text’ for plain text Defaults to ‘html’ Enter value for report_type: html Type Specified:  html Instances in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id                Inst Num         […]