No question at this time
DBA Top 10
1 A. Kavsek 8700
2 B. Vroman 6600
3 M. Cadot 5600
4 T. Boles 4550
5 P. Wisse 4100
6 J. Schnackenberg 3700
7 G. Lambregts 1100
7 . Lauri 1100
7 T. P 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48379
Total active users1533
Act. users last 24h5
Act. users last hour0
Registered user hits last week231
Registered user hits last month580
Go up

Parallel Query
Next thread: jdbc connection
Prev thread: To find the list of procedures and their respective tables used inside the Procedure in

Message Score Author Date
Hi, How to search/find parallel hint query in d...... Raj thakur May 24, 2019, 11:54
select * from v$sqlarea where lower(sql_text) like...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse May 25, 2019, 07:40

Follow up by mail Click here


Subject: Parallel Query
Author: Raj thakur, India
Date: May 24, 2019, 11:54, 24 days ago
Os info: Solaris
Oracle info: Oracle12c
Message: Hi,

How to search/find parallel hint query in db without fetching awr report.

Thanks
Rakesh
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Parallel Query
Author: Philip Wisse, Netherlands
Date: May 25, 2019, 07:40, 23 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: select * from v$sqlarea where lower(sql_text) like '%parallel%'
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here