as I saw ur last video where you make me understood high water mark ...1 bottle capacity 1 litre ..and ever it has filled till 1lire ... last ever it filled only 1/2 of the capacity and so high water mark is mid of the bottle rt ... now I am trying to make that bottle full ..so previously HWM was at mid of the bottle ..but now it has increased to top of the bottle ... so we can say off course high water mark can be increased...
Hi Arun...your videos has been of great help....can you suggest or make in depth video for awr report reading....I have watched 1hr plus one video.....but need more in depth help.
Hi Varun, I am working on goldan gate 12cR1. And want to replicate a table. Ex - source table T with column X,Y,Z and target have table T with column X,A,Z . So, how can I replicate the data. Thanks in advance!!
How the oracle will assign the threads to the oracle PL/SQL block ,on what basis oracle will assign the multiple threads to the PL/SQL block. can you explain me please sir?
Hi Arun and team, just a few questions here, so for the high water mark.. you mentioned that its the highest level or amount of data that ever existed in the data block. So if the data block was not fully utilised and in subsequent operation it is fully utilised, will it not superceed the existing data mark? And for the data insert ijn the extra column, cant we make that column hidden and then insert the data and then unhide the column?
Hahaha.. I like the idea of hide and unhide. You can hide it from users but how will you hide it from Oracle? :) :) Yes, you are right when you say the HWM will surpass the previous HWM!
Hi Team I have performed Online index rebuild, now app team team trying to generate report they are facing slowness issue. as i checked in awr report showing sequential and scattered read issue what should i do...?