I'm following your channel for some times, great explanation. Thanks for your effort.
@PawanKumar-tx2jd
4 жыл бұрын
It is cleared many doubts for me after watching your videos. Thanks a lot.. Keep it up.
@kellytchoffo2837
4 жыл бұрын
Thank you for these videos . Totally enjoy them 😊
@mahmudurkhan5754
4 жыл бұрын
Thank you so much for the information sir. Please keep continue
@arifansari42
4 жыл бұрын
Thanks for your hard work, Keep it up 🙌
@muruganandamramasamy
4 жыл бұрын
Nice explanation.. very useful 👍.
@mbh1212
4 жыл бұрын
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.
@dbagenesis
4 жыл бұрын
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.
@bharathkumar-ds8cd
4 жыл бұрын
Nice video arun ,please explain sqlplan base lines and SQL profiles.
@dbagenesis
4 жыл бұрын
Sure, will be speaking about it soon. Now I feel we must have #dailyPerformanceTuning show as well :P
@SANDATA764
4 жыл бұрын
Thank you
@saisruthi9609
4 жыл бұрын
Good explanation,kindly explain migration non priemised to aws
@dbagenesis
4 жыл бұрын
Sometime in the upcoming videos!
@roshanjohn3076
4 жыл бұрын
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
@devangsangani7580
3 жыл бұрын
Can you please make one video on oracle index,type and how to check which index is better to create on colummn etc.
@dbagenesis
3 жыл бұрын
Sure, added to my list
@devangsangani7580
3 жыл бұрын
Thank you😊
@MegaSaikiran143
4 жыл бұрын
It's might be network issue also b/w client and sever machine
@chandrashekharbr6514
3 жыл бұрын
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???
@dbagenesis
3 жыл бұрын
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.
@Data_360
4 жыл бұрын
Hi sir, Could you please make a video on how to read a explain plan and solution for that
@dbagenesis
4 жыл бұрын
sometime in the upcoming episodes.
@RameshKumar-dw9fs
4 жыл бұрын
Hi Arun , What does Virtual ip address play role in rac environment using scan ip.
@dbagenesis
4 жыл бұрын
Good one, picked up for upcoming episodes !!
@udaykiran60
4 жыл бұрын
Hi Arun, How many scan listener should be created when my env is 8 node RAC. Also how should we calculate scan listener.
@dbagenesis
4 жыл бұрын
3 and 3 only! No of nodes do not define scan listener. Configure 3. more than enough! No special calculations.
@udaykiran60
4 жыл бұрын
@@dbagenesis Thanks Arun.
@bharathkumar-ds8cd
4 жыл бұрын
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.
@dbagenesis
4 жыл бұрын
Make command?
@suvranshuadhya7680
4 жыл бұрын
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
4 жыл бұрын
So here ADR = Active Data Guard ?? Could you use some dummy SIDs and write in detail without abbreviations?
@suvranshuadhya7680
4 жыл бұрын
@@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 ?
@shefalishah164
2 жыл бұрын
@@suvranshuadhya7680 have you got solution ?
@roshanjohn3076
4 жыл бұрын
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)),
@smartdba5784
4 жыл бұрын
Hi sir,can you please tell me what are all skills required for 2yrs experience DBA ?
@dbagenesis
4 жыл бұрын
Get your basics right: - Data guard - ASM - RAC
@vijaybarangale554
4 жыл бұрын
Didn't understand how in your environment it took few seconds. Was same issue replicated i.e. more indexes,insert trigger s,config etc.
@dbagenesis
4 жыл бұрын
;) even client did't understand but we made them understand.
Пікірлер: 38