thanku sir for this amazing videos ...keep posting sir it helps alot :)
@mdhasibullah318 Жыл бұрын
Prashant it's very nice , please upload more .
@madhusudanaraonallamothu27922 жыл бұрын
Thank you very much for sharing your knowledge. Very much informative..🙏🙏🙏
@vigneshn11212 жыл бұрын
Good Day Prashant, Thank you so much for this explanation. I need to know that, How we should track session details(start and end time, elapsed time, still how much rows pending to complete the session). Kindly suggest.
@harishharish.r3338 Жыл бұрын
Hi Prashanth, very well explained , could you please share the query rea.sql
@MavuriKumaraswamyАй бұрын
Nice information
@suryateja20432 жыл бұрын
Very Good one, Thanks for sharing
@thefatdba2 жыл бұрын
Thanks Surya!
@PKBIJ829 ай бұрын
After creating custom profile , still SQL is picking bad execution plan , how can I fix then, please suggest.
@deepjitsaha753210 ай бұрын
Hi Prashant, could you please tell me how to release PHV value from sql ID after lock PHV value. It will be really helpfull for me if you can.
@Mrpro119 Жыл бұрын
Hello Prashant , Really very good video and you explaining very well . if possible could you please share code snippet which you are using .
@Farhan640 Жыл бұрын
Great video
@thefatdba Жыл бұрын
Thanks for the visit
@mayankbaliyan54412 жыл бұрын
Excellent video Prashant , please keep it up for all of us . Can I have those 1.sql and 2.sql scripts from you ?
@thefatdba2 жыл бұрын
Sure, please share me your email
@thefatdba2 жыл бұрын
Files used: github.com/fatdba/Oracle-Database-Scripts/blob/main/sqlflip1.sql (1.sql) and github.com/fatdba/Oracle-Database-Scripts/blob/main/sqlflip2.sql (2.sql)
@mukkamalamahendra2 жыл бұрын
@@thefatdba Thanks a lot
@harelex072 жыл бұрын
Good one !
@thefatdba2 жыл бұрын
Thanks mate. Stay tuned for all upcoming videos
@helpwithramesh2 жыл бұрын
Hi brother very excellent explain and one suggestion Please share the documents if possible thanks .
@ravinbharathmaharaj92692 жыл бұрын
How can you identify a ‘stale’ sql profile ?
@thefatdba2 жыл бұрын
Thanks Ravin for watching the video and for your comment, and thats a great and a valid question as that can happen to a SQL prflofile. But I guess its not possible to answer it here, so I am pasting a link of asktom where same question was answer by Chris Saxon asktom.oracle.com/pls/apex/asktom.search?tag=sql-profile-stale
@thefatdba2 жыл бұрын
Maybe I have found my next blog topic to test and showcase.
@satendrarajput81202 жыл бұрын
Thanks Sir, very good explanation for sql_id, I am getting issue to execute second query ORA-01476: divisor is equal to zero
@thefatdba2 жыл бұрын
Then you have more than 4 or 5 PHVs
@thefatdba2 жыл бұрын
You can go and use DBA _HIST_SQL_STATS view to get same details
@thefatdba2 жыл бұрын
Or try easyoradba.com/2013/08/23/ora-01476-divisor-is-equal-to-zero/?amp=1
@VenkyPotla369 Жыл бұрын
@Prashanth could you please share the rea.sql script
@thefatdba8 ай бұрын
Though all of them are available on my GitHub public repo, which in particular you are looking for and I will dhare the direct link
@ramkumarsharma54908 ай бұрын
rea.sql Kindly share
@faruqansari33422 жыл бұрын
its possible to share doc
@thefatdba2 жыл бұрын
Hi buddy, Please check description of the video for scripts used in video
@navdeepbhatia50307 ай бұрын
thanks SIr very nicely explained , kindly share rea.sql as well
@palagirikrishna27192 жыл бұрын
Sir.. could you please send @coe_xfr_sql_profile.sql script also..Prashant sir.. i need one more help sir... what is the sql profile and what use sql profile.. could you please explain please
@rafiabbasi19 ай бұрын
you will get this script when you install SQLT ,
@thefatdba8 ай бұрын
Its inside SQLT package, download and you will find inside sqls folder