0 ratings0% found this document useful (0 votes) 95 views2 pagesHow To Determine The SQL - ID For A SQL Statement
How to Determine the SQL_ID for a SQL Statement
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
92572018 Document 1627387.1
ORACLE urcancis weronr Btomreniot |} © rr sink) — GO) concep
Dentord Kaowidge Seok Rapes ote Unie oo 2D
soveetents> veto
cede, de rnd Ode int
‘(How to Determine the SQL_ID for a SQL Statement (Doc ID 1627387.1) Qo Bottom
In this Document Was thi document pa?
Soa ws
‘Solution °
How toidentiy he SOL ID ofa statement
Document ets
= aca
APPLIES TO: ee
SEAM Aran
‘race Daabase Eerie Eion- Veron 10.0.2 ander vane A as
Informs ne document pps t any atorm ‘ee: CE]
GOAL
This cocument explains how to determine the SQL_ID fora SQL. Statement’ associated text using Date Dictionary queries that Reise Products
cexeccte agains te AWR, ASH data or VESQL views Cra mate Eee
SOLUTION Shore Saves
How to identity he SQL. 1D ofa statement Sr chas inact -
‘The SQL_ID ofa statement can be found In an AWR or ASH report or by selecting Irom the database data dictionary using the saves
sal view.
Ifthe SQL canbe idented with 2 articular identifiable string or by some kindof unique comment suchas: /* TARGET SQL*/ __Iormation centers
‘hen ths wil make easier to ecate Infrmaton Cet oven
Deane Severe
For Bom: eis
wibion2)
Stuer hy plan atv rissa).
strug htt
sue sate Tren ape
ets Sct 1 HRT SO Fa ad rere Mager 5AM
Fax 946052)
‘The hash_value I Included here for convenience, You canals find the SQL_1D In the VSSQL vew using a susttalon variable: pntune sen Pcs
fiseosaa)
psn, NS ee Yet Paton See (a)
SE set oe atten ahe sis inary
faosa72).
1 SQL not avaiable in v$sa, DBA HIST_SQLTEXT and OBA HIST_SQLSTAT can be used
Document Referencae
toate, How 9 Oxtarin th S19
Cractexts Sfasou stance
Sieesitlehe teas sgt abe 26
. ap. ia betwoan’ 223 and 350 sanapid in vhich the quecy was ran ecenty Viewed
To fin the SQL_1D of statement in a PL/SQL bloc, see the following Document Sayama
aL aac be SOUT
sent Tat 1528741
Ieaseyonn a2 evans
teow)
Restorer OFFLINE
Document 741724.1 How to Determine the SQL_1D ofa SQL Statement in @ PL/SQL Block
Dalal TextBsourceld=3-182064091918
hntpslisupport oracle, comlepmestaces/DocumentDisplay?_afrLoop=2644454599601768pare 1627387.. 112 912572018 Document 1627387.1
Incemental ecage
REFERENCES vous sg RN Cataeg
wars)
NOTE:781724.1 - How to Determine the SQL_ID ofa SQ) Statement in a PL/SQL Block Hortense Tae
stom Mere
>
Dentin what yeu re oa f7?-_ Asin Commi
Related
Products
+ Oral atte Pras > Orc Dla Ste > Ose Dtaace > Orc Ontabse Ener Elon > ROOMS > Gener SO Pearman, SQL Exaoten, Query
‘Sine Cad > crc atom Goud > rac Dba Cu Seve > rice Database Cut Schon Ser
{Se tence > Ok i Gia tc > One bao ea Stree
1 Grol ea > roe Plato Goat > Grace Duane Cut See» Oral Oats Sx Ear Ca See
1 Glace Ges > ree Paton Gout» Grace Danas actup saree = Orde Dsabasa Bacup Svc
{Stele Get 3 Orne Hato Gas» Grace Danae Cl Sevr > Orel Oxtapee oe Server
Keywords
HEALTH: HEALTACHEDY SOLTPLAIN
‘Translations
+ Frat Sores + oapnese 8
vin 208, crate Ahr. Lele a Taree Prey Stent
