Global Temporary Tables in Oracle Database - DBArch Video 21

Поделиться
HTML-код
  • Опубликовано: 22 янв 2025

Комментарии • 33

  • @syedamunawarfatima6989
    @syedamunawarfatima6989 5 лет назад +1

    You are a legend sir..I enjoy listening to u more than watching any movie..

  • @someshanand1799
    @someshanand1799 5 лет назад

    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!

  • @vimeshpatel6479
    @vimeshpatel6479 7 лет назад +3

    Very informative and clear explanation...

  • @jamespintu
    @jamespintu 7 лет назад +3

    Great Work!! Very clear lecture and easy understandable content. thank you. Please upload videos on concepts like RMAN, Dataguard, Datapump and Streams.
    Thank you,

    • @RamkumarSwaminathan
      @RamkumarSwaminathan  7 лет назад

      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....

  • @KrishnaPaneri
    @KrishnaPaneri 4 года назад

    Explained very well 👍🏿

  • @TheAbc9989
    @TheAbc9989 5 лет назад

    very clear explanation thanks. Please post some vedios on data migration from oracle to oracle or other database.

  • @lokeshgurram4589
    @lokeshgurram4589 6 лет назад +2

    Your lecture is splendid and attracting us like men watching a beautiful women.. :P

  • @santosh-panigrahi
    @santosh-panigrahi 9 месяцев назад

    Superb. Thank You.
    Can you pls make similar video for private temporary table.

  • @soumikbanerjee363
    @soumikbanerjee363 7 лет назад +1

    Wonderful description sir...just awesome...it would be of great help if you make a video on snapshot/standby mode of Oracle database

  • @tejasthakur123
    @tejasthakur123 2 года назад

    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 ?

  • @elifkahya6678
    @elifkahya6678 4 года назад

    Hi, How can I read data from already exist temporary table on oracle database? thank you

  • @sadrushya2525
    @sadrushya2525 7 лет назад +1

    Great lesson.please upload stats collection on temp tables

    • @RamkumarSwaminathan
      @RamkumarSwaminathan  7 лет назад

      Thanks Bikash. Will talk about stats when I upload videos on Performance Tuning

  • @udays2
    @udays2 7 лет назад +1

    Short and informative.. Pls upload exadata video also..

    • @RamkumarSwaminathan
      @RamkumarSwaminathan  7 лет назад

      Yup that's also coming up... Will take a few months before that is in here in RUclips.... Shall keep you posted once its up...

  • @amitkumar-ev8im
    @amitkumar-ev8im 6 лет назад +1

    Really good

  • @MegaPurpur
    @MegaPurpur 6 лет назад +1

    Please add video for cache fusion rac in details.

  • @ramchinthakayala2092
    @ramchinthakayala2092 5 лет назад

    nice!!!

  • @brvidya
    @brvidya 5 лет назад

    GTT data will be using SGA or PGA?

  • @Shubham_sapkal32
    @Shubham_sapkal32 4 года назад

    Nice efforts but dont put music in the background as it disturbs in listening.

  • @Nick-ui9dr
    @Nick-ui9dr 5 лет назад

    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. :)

  • @Nick-ui9dr
    @Nick-ui9dr 5 лет назад

    Oops! I promised not to disturb till 35th vedio. :)
    Sorry going...lets move on to next.

  • @knandi73
    @knandi73 2 года назад

    Please remove background music....It can be considered as noise and it disturbs in learning....

  • @sandipsarkar4555
    @sandipsarkar4555 Год назад

    Please remove tha background music, its distracting

  • @Prakashreddy-gq2hi
    @Prakashreddy-gq2hi 7 лет назад +1

    Really Good and clear explanation .