Sir, what are the key points to design a database for next 5 years, if ur company asked u to design a database for software (will be inserting, recording alot of data in DB but u dont know the exact figure) .. I mean how much storage is requied, what would be the size of of index partition, what would be the size of archiving partition , what would be the size of data files partition etc, how much RAM&CPU is required, how do we figure out what would be the best DB Architecture/design for this software. What would be a pre design planning procedures.. Thanx for ur support, ur all videos helped us alot in day to day activity & u r making our life so easy .. God bless u always.
If you do not know exact figures or cannot calculate average row length, then start with any numbers and then increase it as per requirement & DB growth.
Tutorial is nice :) Suppose I create an index on (trunc(TIME)), will this disable the indexing? In this case, suppose I create a virtual column as shown below and create an index on that virtual column, will the indexing work? TIME_TRUNC Date invisible GENERATED ALWAYS AS (trunc(TIME)),
After database patching run make command is mandatory or not, version is 11.2.0.4, aix environment.some times I run and some times ignore , please help me.
If the DBAs are doing monthly / weekly capacity planning then what you said should not arise in any environment. If it does arise, the only option is to move the files from FRA location to some other location where you have space. Later when you get space added from storage team, then copy back the files into FRA location. Or simply trigger the archive backup and make sure to use delete input option. If you are putting RMAN backups in FRA location and FRA is full, again you will have to move those backup files to another location until you get space. Solution to what you said depends on what type of files reside under FRA. All in all, this situation should not arise if proper capacity planning is happening in any environment. As per your estimates, you must have at least next 1 to 3 months of disk space already available.
Hi , I have one question.Can you please look into this? How can we manage DB Links after switch over? Just for example Let a db link present in A database and pointing to B db.After switch over,A will be ADR and B will be BDR.At this moment,how the db link will work ? Please provide us some permanent solution for this issue...
@@dbagenesis It is not Active Data Guard. Db link is present in CCPRD database and pointing to TESTPRD .Both the database is RAC and in same server . After Switch over drill,CCPRD will be CCPRDDR and TESTPRD will be TESTPRDDR.So,CCPRDDR is in READ WRITE mode.The db link still pointing to TESTPRD.It should be TESTPRDDR .At this moment 1 solution is drop the existing db link and recreate it pointing to TESTPRDDR.But is not possible for all db link and all the time.Can you please provide me some permanent solution ?
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
I'm following your channel for some times, great explanation. Thanks for your effort.
It is cleared many doubts for me after watching your videos. Thanks a lot.. Keep it up.
Sir, what are the key points to design a database for next 5 years, if ur company asked u to design a database for software (will be inserting, recording alot of data in DB but u dont know the exact figure) .. I mean how much storage is requied, what would be the size of of index partition, what would be the size of archiving partition , what would be the size of data files partition etc, how much RAM&CPU is required, how do we figure out what would be the best DB Architecture/design for this software. What would be a pre design planning procedures.. Thanx for ur support, ur all videos helped us alot in day to day activity & u r making our life so easy .. God bless u always.
If you do not know exact figures or cannot calculate average row length, then start with any numbers and then increase it as per requirement & DB growth.
Thank you for these videos . Totally enjoy them 😊
Thank you so much for the information sir. Please keep continue
Thanks for your hard work, Keep it up 🙌
Nice video arun ,please explain sqlplan base lines and SQL profiles.
Sure, will be speaking about it soon. Now I feel we must have #dailyPerformanceTuning show as well :P
1.why many indexes can slow down queries?
2. can you please advise on which fields to create indexes after I generate explain plans? Is it predicate expression we should target?
--------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 77537 (100)| | | | |
| 1 | PX COORDINATOR | | | | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10000 | 31M| 5276M| 77537 (1)| 00:00:04 | Q1,00 | P->S | QC (RAND) |
|* 3 | HASH JOIN RIGHT OUTER| | 31M| 5276M| 77537 (1)| 00:00:04 | Q1,00 | PCWP | |
| 4 | TABLE ACCESS FULL | BI_STAFF | 2438 | 75578 | 2 (0)| 00:00:01 | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 41M| 5795M| 77522 (1)| 00:00:04 | Q1,00 | PCWC | |
|* 6 | TABLE ACCESS FULL | CBS | 41M| 5795M| 77522 (1)| 00:00:04 | Q1,00 | PCWP | |
--------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("CID"."MSISDN"="BSO"."MSISDN")
6 - access(:Z>=:Z AND :Z
Nice explanation.. very useful 👍.
Good explanation,kindly explain migration non priemised to aws
Sometime in the upcoming videos!
Thank you
Tutorial is nice :)
Suppose I create an index on (trunc(TIME)), will this disable the indexing? In this case, suppose I create a virtual column as shown below and create an index on that virtual column, will the indexing work?
TIME_TRUNC Date invisible GENERATED ALWAYS AS (trunc(TIME)),
Can you please make one video on oracle index,type and how to check which index is better to create on colummn etc.
Sure, added to my list
Thank you😊
Hi Arun , What does Virtual ip address play role in rac environment using scan ip.
Good one, picked up for upcoming episodes !!
Hi Arun, How many scan listener should be created when my env is 8 node RAC. Also how should we calculate scan listener.
3 and 3 only! No of nodes do not define scan listener. Configure 3. more than enough! No special calculations.
@@dbagenesis Thanks Arun.
It's might be network issue also b/w client and sever machine
After database patching run make command is mandatory or not, version is 11.2.0.4, aix environment.some times I run and some times ignore , please help me.
Make command?
What can we do if FRA is full. Then there is no time to contact respective team to increase the size. Then how can we resolve this issue???
If the DBAs are doing monthly / weekly capacity planning then what you said should not arise in any environment.
If it does arise, the only option is to move the files from FRA location to some other location where you have space. Later when you get space added from storage team, then copy back the files into FRA location.
Or simply trigger the archive backup and make sure to use delete input option.
If you are putting RMAN backups in FRA location and FRA is full, again you will have to move those backup files to another location until you get space.
Solution to what you said depends on what type of files reside under FRA.
All in all, this situation should not arise if proper capacity planning is happening in any environment. As per your estimates, you must have at least next 1 to 3 months of disk space already available.
Hi sir,
Could you please make a video on how to read a explain plan and solution for that
sometime in the upcoming episodes.
Hi sir,can you please tell me what are all skills required for 2yrs experience DBA ?
Get your basics right:
- Data guard
- ASM
- RAC
Hi ,
I have one question.Can you please look into this?
How can we manage DB Links after switch over?
Just for example Let a db link present in A database and pointing to B db.After switch over,A will be ADR and B will be BDR.At this moment,how the db link will work ? Please provide us some permanent solution for this issue...
So here ADR = Active Data Guard ?? Could you use some dummy SIDs and write in detail without abbreviations?
@@dbagenesis It is not Active Data Guard.
Db link is present in CCPRD database and pointing to TESTPRD .Both the database is RAC and in same server .
After Switch over drill,CCPRD will be CCPRDDR and TESTPRD will be TESTPRDDR.So,CCPRDDR is in READ WRITE mode.The db link still pointing to TESTPRD.It should be TESTPRDDR .At this moment 1 solution is drop the existing db link and recreate it pointing to TESTPRDDR.But is not possible for all db link and all the time.Can you please provide me some permanent solution ?
@@suvranshuadhya7680 have you got solution ?
Didn't understand how in your environment it took few seconds.
Was same issue replicated i.e. more indexes,insert trigger s,config etc.
;) even client did't understand but we made them understand.