Global Temporary Tables in Oracle Database - DBArch Video 21
Вставка
- Опубліковано 14 жов 2024
- Learn about Global Temporary Tables in Oracle Database. You will learn the internals of Global Temporary tables in Oracle database, and also a demo for the same.
Our Upcoming Online Course Schedule is available in the url below
docs.google.co...
Reach us at learn@tisyasolutions.com
You are a legend sir..I enjoy listening to u more than watching any movie..
your videos are so good and conceptual that i start loving your videos and start learning the how actually oracle work and behaves,as i am L1 oracle dba i am learning many things from your videos. Thank you so much!
Superb. Thank You.
Can you pls make similar video for private temporary table.
Great Work!! Very clear lecture and easy understandable content. thank you. Please upload videos on concepts like RMAN, Dataguard, Datapump and Streams.
Thank you,
Hi James, Thanks for your feedback. Yes I will be uploading videos on them too... Data Guard playlist is already there.. You can explore it in the channel home page....
Hello Ram,
Great work and I really appreciate your video.
Just wanted to ask can you cover quick video on the new features in 12c,19c and 21c ?
Wonderful description sir...just awesome...it would be of great help if you make a video on snapshot/standby mode of Oracle database
Sure, shall make one soon
Very informative and clear explanation...
Thanks Vim Patel...
very clear explanation thanks. Please post some vedios on data migration from oracle to oracle or other database.
Your lecture is splendid and attracting us like men watching a beautiful women.. :P
Enjoy learning
Hi, How can I read data from already exist temporary table on oracle database? thank you
Short and informative.. Pls upload exadata video also..
Yup that's also coming up... Will take a few months before that is in here in UA-cam.... Shall keep you posted once its up...
Great lesson.please upload stats collection on temp tables
Thanks Bikash. Will talk about stats when I upload videos on Performance Tuning
Explained very well 👍🏿
Really good
Thanks
Please add video for cache fusion rac in details.
Yes will do that...
GTT data will be using SGA or PGA?
Not saying u not had a valid point here....but still I feel ur choice of example is somewhat of impractical nature. First u doing loop over same query which won't happen in real case scenario. Every overhead of query done in first instance. Rest u just getting results from cache area repeatedly. Mean oracle didnt have to do any work but just when u fired it first time. Real overheads comes when it had to do processing & I/O...then your ratio might not be that impressive.
Secondly, u doing very typical count value query which results in one variable result size... so to and forth network overhead also to best min possible case. Which making your comparision ratio more impressive. For every call it had to return jus one variable from cache after performing hash checks. :)
Had it had been some real case scenario other overheads might have colored your comparison ratio a lot...depends on a particular case. but sure it wont be this impressive I suppose. ;)
Actually, its no comparison at all but u just showing/calculating how much time it takes to log in and log out....averaging it out for better results. ;)
Quote of day: Statistics is very good tool...but only when u use it sensibly. Otherwise, it may lead to lot of illusions. :)
nice!!!
Nice efforts but dont put music in the background as it disturbs in listening.
Oops! I promised not to disturb till 35th vedio. :)
Sorry going...lets move on to next.
Please remove background music....It can be considered as noise and it disturbs in learning....
Please remove tha background music, its distracting
Really Good and clear explanation .
+Prakash .reddy thanks