DB File Sequential Read |
Vložit
- čas přidán 21. 07. 2024
- In this episode of daily DBA, I pick up 5 important #DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!
00:00 Intro
1:41 Can data exists above High Water Mark?
3:55 I have two tables: TABLE_A and TABLE_B. Table_B structure is same as TABLE_A except that it has one extra column. How can I copy records from table_A into table_B even though Table_B is having one extra column?
7:22 Difference between db_file_sequential_read and db_file_scattered_read.
10:43 How can I upgrade from Oracle 9.2.0.1 32bit to 11g 32bit version?
10:58 #dba Challenge!
12:29 Can I create DB link between databases hosted on different OS platforms?
Bonus Question
15:09 How can i prepare for Oracle 19c certification?
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis - Věda a technologie
Thank you for sharing good knowledge.
Very nice job! I also have a question. What is the best ORACLE DB monitoring solution? Thank you very much for this show!
OEM
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!!
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.
Is there any query or a way to identify if the database performance is degrading because of high water mark??
Nice explaination
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...?
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...
You are right!
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?
Sure, picked your question for upcoming episodes!
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!
Before insert we can make extra column as invisible
How do we read awr report please make a video for tha same.
we already have it. check here: czcams.com/video/QPJL1fswbO4/video.html
Hi team, How to schedule jobs in DB level and how to check logs of Jobs in Db
goto support.dbagenesis.com >> search for dbms_scheduler
Do we really need oracle certification to go for an interview ?
I am not a fan but it does make difference in western world.
can you please put a video on oem 13c overview.
I am all set to launch online training for OEM 13c soon!
Thanks for your reply
How to choose optimizer hints.
Depends on your requirement
Upgrade path
9.2.0.1 -> 9.2.0.8 -> 11.2
#DBA Challenge : 9.2.0.1 can be upgraded to 9.2.0.8 and then a direct upgrade to 11.2.0.4
First to comment.... woooowwww.. yahooooooooo...
Oracle Database Upgrade Path Reference List (Doc ID 730365.1)
9.2.0.8
9.2.0.7 (or lower)=> 9.2.0.8 => 11.2.x