Tracnac

La trace du SORT après

ALTER SESSION SET EVENTS '10032 trace name context forever, level 10';

Tracnac

#VMWare #ESX

• List the inventory ID of the virtual machine with the command

vim-cmd vmsvc/getallvms |grep

Note: The first column of the output shows thvme vmid.

• Check the power state of the virtual machine with the command:

Tracnac

Des vins et des températures

La température des vins blancs :

• 7-8°C : Champagnes simples et vins mousseux, muscats, vins liquoreux simples.
• 9-10°C : Alsace vendanges tardives, vins moelleux, vins blancs secs légers ou acides.
• 11-12°C : Vins blancs secs, vins blancs demi-secs (Vouvray, Pinot gris d'Alsace), Gewurztraminer, beaux champagnes, beaux vins liquoreux, grains nobles.
• 13-14°C : Meilleurs vins blancs secs, vins jaunes et autres vins de style oxydatif.
• 15-16°C : Vins âgés. La température des vins rosés :
• 7-8°C : Champagnes rosés simples et autres effervescents rosés.

Tracnac

CREATE TABLE mytablesave
AS
    SELECT *
    FROM (SELECT *
    FROM mytable
    AS OF TIMESTAMP TO_DATE ('14/11/2011 17:00:00', 'DD/MM/YYYY HH24:MI:SS'));

Tracnac

DECLARE
l_sql_tune_task_id VARCHAR2(100);
BEGIN
l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
sql_id => 'gbu8nxdyd9zt5',
scope => DBMS_SQLTUNE.scope_comprehensive,
time_limit => 60,
task_name => 'Tuning',
description => 'Tuning task for statement gbu8nxdyd9zt5.');

Tracnac

————————————————————————————————————————————
--
-- File name: create_sql_profile.sql
--
-- Purpose: Create SQL Profile based on Outline hints in V$SQL.OTHER_XML.
--
-- Author: Kerry Osborne
--
-- Usage: This scripts prompts for four values.

Tracnac

----------------------------------------------------------------------------------------
--
-- File name: create_sql_profile_awr.sql
--
-- Purpose: creates profile for plan in AWR history
--
-- Author: Kerry Osborne
--
-- Usage: This scripts prompts for five values.

Tracnac

————————————————————————————————————————————
--
-- File name: profile_hints.sql
--
-- Purpose: Show hints associated with a SQL Profile.
-
-- Author: Kerry Osborne
--
-- Usage: This scripts prompts for one value.

Tracnac

-— Shrink Log Sqlserver ---
SELECT
'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
+ 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)'
+ CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM
sys.master_files mf
JOIN sys.databases d
ON mf.database_id = d.database_id

Tracnac

Prérequis :

tnsping source and dest : OK sys account unlock and password set orapwd file for both spfile for both reset controlfile from dest startup nomount dest