0

I want to search into the result of this query.

Select 
cursor(select * from table(dbms_xplan.display_awr(sql_id,
plan_hash_value,null,'all +outline +peeked_binds'))) "PLAN" 
from gv$sql 
where sql_id='3cu6fsfskqgst'

This query give us the plan of a select execution

{<PLAN_TABLE_OUTPUT=SQL_ID 3cu6fsfskqgst>,
PLAN_TABLE_OUTPUT=-------------------->,<PLAN_TABLE_OUTPUT = 
Select count(*) ................................................ 
Degree of Parallelism is 4 because of hint>,<PLAN_TABLE_OUTPUT=   - 
SQL patch "patch_forzar_paralelo4_tcarga" used for this statement>, 
< PLAN_TABLE_OUTPUT= >,}

But I only want to show this piece of the string

SQL patch "patch_forzar_paralelo4_tcarga"

The "string" is not always the same.

Can I cut this piece of the string and show it into the screen?. I want to use only sql execution (not plSql).

Thanks

2
  • What parts of the string are constant? Would SQL patch " till the next double quote sufficient to identify it?
    – Vérace
    Sep 2, 2019 at 14:47
  • From "SQL patch" some text and finished by ">"
    – estonolose
    Sep 2, 2019 at 15:23

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.