Re: information about SQL PROFILEs and/or SQL BASELINEs in ASH

From: Stefan Koehler <contact@xxxxxxxx>
To: lsantos@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 29 Apr 2020 19:05:40 +0200 (CEST)

Hello Luis,
please check the OTHER_XML section in DBA_HIST_SQL_PLAN
(https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_HIST_SQL_PLAN.html#GUID-893C1D35-70C8-46F1-A355-D5858233CC7E)
- you can extract the information from there.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK

Luis Claudio Dias dos Santos <lsantos@xxxxxxxxx> hat am 29. April 2020 um
18:40 geschrieben:

Is there a way to get information about which sql profile and/or which sql
plan baseline was choosed for a specific sql_id, in the past, using ASH?

--AttLuis Santos

--
//www.freelists.org/webpage/oracle-l

References:
- information about SQL PROFILEs and/or SQL BASELINEs in ASH
  - From: Luis Claudio Dias dos Santos

Other related posts:

» information about SQL PROFILEs and/or SQL BASELINEs in ASH- Luis Claudio Dias dos Santos
» Re: information about SQL PROFILEs and/or SQL BASELINEs in ASH - Stefan Koehler