Very good initiative for busy DBAs to refresh their DBA knowledge - this is go to youtube channel - keep up your good work Arun
@dbagenesis
3 жыл бұрын
Thanks a ton
@rennybabu8686
4 жыл бұрын
Great initiative :-) lot of useful tips, a must watch series for fellow Oracle DBAs
@dbagenesis
4 жыл бұрын
Yup and we all must share these videos to help fellow DBAs across the globe !!
@nataliaosorio2691
3 жыл бұрын
Thanks a lot for taking your time to explain questions with alternatives point of views! Very useful videos.
@dbagenesis
3 жыл бұрын
Glad you like them!
@ranjithkumarks6045
4 жыл бұрын
1. In this case of adding new column it will impact on the user, user trying to access the table while adding a column.the query which has fired by user it was hung and those sessions was block till alter table got completed. 2.I agree with your concern. If we split mode of accessing like DQL will be in the standby and Others in live. So in this you will definitely improve you performance in environment. I really like this videos.
@dbagenesis
4 жыл бұрын
Awesome!
@itisvikash
4 жыл бұрын
Really that you Arun bhaiya ! It was really helpful. Just now Started watching KZitem series of "DBA genesis".
@dbagenesis
4 жыл бұрын
Yes!
@rajendrasingh-sr1eo
2 жыл бұрын
Great Sir..
@chitrakgarg1114
3 жыл бұрын
Thanks for sharing it. I just started watching your videos.
@dbagenesis
3 жыл бұрын
Thanks for watching!
@matheenahamed2692
4 жыл бұрын
Wow, very much excited 😊😄😄😄
@matheenahamed2692
4 жыл бұрын
I want to know about the important parameters of export/import in real time
@nrsaini29791
4 жыл бұрын
Please keep it continue.
@dbagenesis
4 жыл бұрын
Definitely
@Ganeshay-996
3 ай бұрын
DBA support ❤❤❤❤
@jegdeeshcse
4 жыл бұрын
Very good initiative Arun😊, thanks lot.. All the best👍💯
@umeshdhote1917
4 жыл бұрын
Arun Sir, your tips and DBA Genesis video are really helpful for me.
@dbagenesis
4 жыл бұрын
Glad, its helping you !
@aqeebjaveed3230
4 жыл бұрын
Thanks for uploading the video sir, good work keep coming.
@alanrodriguez5204
3 жыл бұрын
Great video Arun, it is really informative, THANKS!
@dbagenesis
3 жыл бұрын
My pleasure
@himabindhu7970
3 жыл бұрын
awesome video
@dbagenesis
3 жыл бұрын
Thanks!
@thiruardura
4 жыл бұрын
Very interesting and useful. Thank you.
@dbagenesis
3 жыл бұрын
Glad it was helpful!
@rocksolid194
4 жыл бұрын
Thanks you for the information. One correction control_file_record_keep_time is 7 default.
@dbagenesis
4 жыл бұрын
You right, I just missed it coz all DBs that I work have 30 days default setting. Thanks for the correction!
@rocksolid194
4 жыл бұрын
@@dbagenesis no problem..you are welcome..you are doing awesome work..by sharing knowledge👌👌👌👍👍👍👍🙏🙏🙏🙏
@sathishram386
4 жыл бұрын
That’s good, keep post daily
@dbagenesis
4 жыл бұрын
Yes, we will !
@babuk3521
4 жыл бұрын
Good,keep more videos on pt
@vsurendravsurendra6895
2 ай бұрын
give answers with examples also its very help full every one
@asrytube
4 жыл бұрын
Great work! thanks!
@dbagenesis
4 жыл бұрын
Thank you too!
@abdulgani-iq9bg
4 жыл бұрын
Your explanations is very good. Can you please make a vidio session on plugable databases and multitent topics for clear understanding.
@dbagenesis
4 жыл бұрын
Sure.. sometime in upcoming sessions!
@vinod1704
4 жыл бұрын
Thx arun, loved it .
@dbagenesis
4 жыл бұрын
Awesome!
@bharathkumar-ds8cd
4 жыл бұрын
Salute sir🙏
@senthilprakash8989
3 жыл бұрын
Very informative, Thank you. I am a PLSQL Developer with 10+ yrs experience, Now I see very less openings for PLSQL developers. Considering the current situation where more customers are migrating towards cloud & less opening for PLSQL developers, do I need to sharpen my skills in Oracle DBA or right time to learn any other new technology.
@sureshhello-zn4cw
4 жыл бұрын
Nice video sir
@InamUllah-dc5bh
2 жыл бұрын
please start a video searies on oracle development course project base ....
@satyaprasad2009
4 жыл бұрын
Nice viedo sir..i need viedo on performance tuning
@vigneshchinna358
4 жыл бұрын
Great job bro 👍
@elongemusinga1138
3 жыл бұрын
Great content Arun
@dbagenesis
3 жыл бұрын
Thank you!
@amirmule5333
4 жыл бұрын
Very useful. Request you to raise volume of video for clarity.
@dbagenesis
4 жыл бұрын
Good feedback, taken into consideration ;)
@udaykiran60
4 жыл бұрын
Thanks you so much for the video :)
@AltafHussain-hy6fo
Жыл бұрын
Hello, How to find query generating more redo/archive log in Oracle database? Thanks
@syedarshad6055
4 жыл бұрын
Good idea
@dbagenesis
4 жыл бұрын
Keep watching
@sarahsaraswathy3010
4 жыл бұрын
Thanks a lot Sir..
@sivakumarayachitula6469
4 жыл бұрын
Can you tell me how cursors work actually in shared sql area...I am confused why and when the same sql Id will be having its child cursors and version counts?? Sometimes when I try to migrate the base line from one environmnt to another it is confusing me which plan do i actually need to migrate because I see two r three plans for the same sql id but with its child cursors having different sql plans..
@dbagenesis
4 жыл бұрын
Sure, picked it up for future episodes!
@sivakumarayachitula6469
4 жыл бұрын
@@dbagenesis thank you
@pravatkumar2004
4 жыл бұрын
Question 2: Same SQL query was running fine before, But now it is taking 3hrs to 4hrs. And also overall database is slow as per user during this query execution. So I checked - Stale stats = No stale stats are there on the objects that are used in this query. - No other query/transactions was there during this query execution - Ran SQL Tuning pack - no recommendation mentioned except to pin other plan has value. I did the same also. Still issue is there. - Ran ADDM report, no satisfactory recommendation mentioned So could you please explain what else area to check to identify issue.
@dbagenesis
4 жыл бұрын
trace the user session and read the trace file via tkprof, that will give the pin point problem
@roshanjohn3076
4 жыл бұрын
@@dbagenesis How to trace the user session? v$session?
@bhavanisankaryerriboyina4939
4 жыл бұрын
Supper sir
@abdullahahmadi2264
4 жыл бұрын
Thanks for video
@dbagenesis
3 жыл бұрын
Most welcome
@yoganand7416
4 жыл бұрын
What does stats gather actually do and how does it would help to improve the performance of the database ??
@dbagenesis
3 жыл бұрын
DBMS_STATS package lets you collect statistics in parallel, collect global statistics for partitioned objects, and fine tune your statistics collection. This package is concerned with optimizer statistics only.
@sureshkrish07
Жыл бұрын
Hi All, is there any option to manage the export/import without Linux level access.. Can you help on this..
@sai3276
4 жыл бұрын
Hi Arun, Kindly explain about blocks and how to recover the corrupted blocks
@dbagenesis
4 жыл бұрын
Checkout my earlier videos published on youtube related to DB blocks: 1. kzitem.info/news/bejne/x4V62ZWIjqOlZW0
@02vikassoni
4 жыл бұрын
Please make a video on PRAGMA COVERAGE,DEPRECATE,INLINE,RESTRICT_REFERENCES.
@nhrafi6563
4 жыл бұрын
Thank u arun
@MsSpatana
4 жыл бұрын
Thanks a lot
@truthhurts9601
4 жыл бұрын
Thank you.
@shekshavali8513
3 жыл бұрын
Hi sir This is Sheikshavali I have one question I have multipule ORACLE_HOMES. In that oracle homes when I was updating patch like version updated patch. Client says you can apply only one ORACLE_HOME no need to apply another Home? (This is interview question ) I hope you understood my question Please give a solution. Thank you sir Sheikshavali
@dbagenesis
3 жыл бұрын
It's straightforward what client is saying, apply patch to only one ORACLE_HOME!
@sahiltyagi4454
4 жыл бұрын
Great work Arun.. I have upgraded (manually) my 11.2.0.4 database to 12.1.0.2 and also I have upgraded the dst_timezone to 18 .. But after running the post_upgrade_fixups.sql ... It's still showing old_time_zone.So, my question is whether this is some sort of bug in oracle 12.1 or do I need to upgrade to timezone to some other values?? Please do respond... :)
@viralmody6316
3 жыл бұрын
How can we find or auery benefits in library cache when we start using bind variables for similar SQLs instead of hard coded literals.
@johncharles3197
4 жыл бұрын
Great initiative 👍 Thank you Arun for sharing your knowledge... where can I post questions ?
@dbagenesis
4 жыл бұрын
Welcome, just post your doubts below any video that you are watching or send via email: support@dbagenesis.com
@pravatkumar2004
4 жыл бұрын
User is complaining insert statement ( if has a sql query) is very slow now. It is suppose to complete 10 min but now a days it is running 9 hours. I checked this sql query is every time creating new sql_id and this is creating parallel sessions also for same sql_id. Could you please help me how to find the issue.
@dbagenesis
4 жыл бұрын
You need to check if the insert statement is raw insert of it is INSERT INTO .. SELECT .. FROM; statement. If its later, then check if the Oracle going for full table scan or Index scan. Else, enable trace in user session and see where Oracle is spending time while inserting records.
@rajatsanwal9919
2 жыл бұрын
Hello Arun sir, long time no episode of Daily DBA?
@srikanthlolugu990
4 жыл бұрын
Difference between Data Guard and Golden Gate and which is recommended for which scenario.
@dbagenesis
4 жыл бұрын
Check out one of my live events that answers your question: kzitem.info/news/bejne/mW-gv66Ch5aVe6g
@sadanb4876
4 жыл бұрын
My database size is 500 GB and what's the recommended size for FRA ? What are the parameters need to be considered before we set the FRA ?
@dbagenesis
4 жыл бұрын
Good question, picked it up for upcoming episode! happy learning!
@hareeshb579
3 жыл бұрын
Thanks for the video Arun.. Can we import a single table from full export dump?
@dbagenesis
3 жыл бұрын
Yes, you can. Just specify the tables parameter to the table name which you want to import and rest all tables will be ignored.
@dhirensingh5327
4 жыл бұрын
Hi, could you also speak about question to ask client or user about what considerations required to build a DB and how do we suggest best options from oracle on the same so that its cost effective
@dbagenesis
4 жыл бұрын
Depends, most of the time the requirements come from application that will be using the database. You won't have much control or would not think much about Oracle configuration.
@muhammadmakhshiftanvir3602
3 жыл бұрын
Why do you prefer manual upgrade instead of DBUA?
@dbagenesis
3 жыл бұрын
If DBUA fails, you have to perform manual upgrade, so its a good idea to master manual upgrade over DBUA.
@mdarif-rt9mg
4 жыл бұрын
very usefull ! Which path did you choose for becoming Web designer
@vrushalijwalesh1901
4 жыл бұрын
Which value from AWR report will give the information that xyz index needs a rebuild?
@kaira7710
3 жыл бұрын
Hi Arun..... Would you please help me with how to retrieve billions of records as much faster on Oracle database.
@arvindkumarlal743
2 жыл бұрын
Sir, I'm using Oracle 10g database, after 2 to 3 months programmes runs slowly, when drop user cascade with table data and again create the same the application runs faster but again after 2 to 3 months the problems remains same, what should I do.
@arvindkumarlal743
2 жыл бұрын
After dropping user and creating the same user, restored table with data through exported .dmp backup file.
@imdadkhan7951
4 жыл бұрын
Hi Arune, could you please explain what are differences between flashback database and guaranteed restore point ?
@dbagenesis
4 жыл бұрын
Good question, picked it up for upcoming episode! Will answer it soon!
@imdadkhan7951
4 жыл бұрын
DBA Genesis , could you please confirm which episode 6/7 ?
@amitshinde9724
4 жыл бұрын
hi sir, we are facing low volume/sound issue for most of your videos,please improve sound quality.Ty
@dbagenesis
4 жыл бұрын
Have fixed this from episode #2!
@kishorekrish2254
3 жыл бұрын
Hai iam freshers Iam intresting towards DBA it's good option for freshers ... In DBA which Technology now a days trending
@SandeepSharma-bk6rl
4 жыл бұрын
Keep it up it's a Good Job .. Could you please make a common WhatsApp group for this channel it's alos a good option
@dbagenesis
4 жыл бұрын
I am not a fan of WhatsApp but will consider it in future.
@Ganeshay-996
3 ай бұрын
Where is best platform form Rac and datagard and golden gate any KZitem channel please provide us
@kumargaurav4961
4 жыл бұрын
Hi Team , in my DB server when I run "top" command the load average : 3.27,3.47,3.68 And vmstat command result : r = 4 , b = 2 (procs) Swpd = 2202188, free= 170640, buff= 1384 (memory) si = 321 , so=115 (swap) bi = 3933 , bo= 3933 (io) Few more parameters are there but here I am not able to type ... have given some inputs for you and same have send you in Fb messenger . Actually, my client system is getting hang , is there any prob in my db server ?
@dbagenesis
4 жыл бұрын
Send complete details via email to support@dbagenesis.com
@amandeepgera4109
4 жыл бұрын
A lot of DBA's are woriied about future of what will happen once autonomous DB comes....Many thinks they will lose jobs ..please answer..
@dbagenesis
4 жыл бұрын
Already added to upcoming episodes !
@jonybarua5283
2 жыл бұрын
Thank you sir for your good video. Can you make videos about oracle applications ebs 12.1 or 12.2 please
@chintalapurisuresh3330
4 жыл бұрын
Can you please tell me, what DBA do on daily? I am new for oracle DBA
@dbagenesis
4 жыл бұрын
Sure, checkout this video published on KZitem earlier: 1. kzitem.info/news/bejne/rqSL139maXp3gHo 2. kzitem.info/news/bejne/loGHqHZqp4WVg5g 3. kzitem.info/news/bejne/xoxr0paJrF-pgHY
@chintalapurisuresh3330
4 жыл бұрын
@@dbagenesis thank you so much....
@roshanjohn3076
4 жыл бұрын
Hi, I have a datawarehouse environment. 2 node RAC, Oracle DB 12.1.0.2, Golden Gate 18c. Configuration of GG is downstream. Everyday around 350 GB archive is being generated. DB size is currently 3.4 TB. Can you please advise on a backup strategy to make backup faster? Do you recommend Intelli Snapshots based on hardware?
@dbagenesis
4 жыл бұрын
I would like to know how many channels do you allocate in your archivelog RMAN backup scripts and what is the archivelog backup frequency
@roshanjohn3076
4 жыл бұрын
@@dbagenesis 2 channels have been allocated backup incremental level = 0 filesperset = 8 database plus archivelog not backed up;
@roshanjohn3076
4 жыл бұрын
frequency is daily. After backup, I purge the logs delete archivelog until time 'sysdate-1';
@dbagenesis
4 жыл бұрын
Do one thing, remove archive backup from the DB backup script and schedule it separately. See example below: DB Backup script: ---------------------------- Just trigger DB backup and also make sure you taking LEVEL 0 backup only on weekend or non peak hours. Rest all the days of the week, take Level 1 backups. ARCHIVE BACKUP SCRIPT: -------------------------------------------- Create a new archive only backup script and schedule it to run every 4 hours. See if your environment is stable and if not, you can increase the archive backup frequency to every 2 hours. This should be good enough and also, please increase number channels in backups to at least 4. This will speedup the backups. Implement above and send me progress report to support@dbagenesis.com and I am sure you will not have to use any other hardware level backup tools. Enjoy!
@roshanjohn3076
4 жыл бұрын
@@dbagenesis Thanks Arun. The golden gate tables are located in a specific schema. Is it necessary to perform daily RMAN backup of the DB? The point is in case I will perform an RMAN restore, Golden Gate will need to be reconfigured and export and import of all the tables(using flashback_scn) will need to be done for Golden Gate config. In my opinion, an export dump (daily) of specific schemas will be much better. Maybe a full backup once a week will be ok? or still do you suggest me to do daily level 1 RMAN backup? If yes, in case of restore, how should I resync the Golden Gate tables?
@nihalnadaf8126
4 жыл бұрын
Before RMAN backup started, what prepration done inside the RMAN..? is it use current control file to read backup informantion or else its create snapshot control file for the period of backup time.!! pls help for this question.
@dbagenesis
4 жыл бұрын
Will answer in the upcoming episode!
@nihalnadaf8126
4 жыл бұрын
Thanks!😊
@viralmody6316
3 жыл бұрын
Can you explain please latch and mutex concepts in oracle ?
@atifbhure7554
4 жыл бұрын
If we perform a switchover operation in real time. How will we have to manage the connection string for end users? since after switchover standby will act as a primary database. Do we have to modify connection string for all the user at client side? or is there any other thing which is need to be done?
@dbagenesis
4 жыл бұрын
Answering this question in the upcoming episode!
@basilkurian6871
4 жыл бұрын
If I had a performance spike on a particular 2 mins is it a good way to look in awr or how can I troubleshoot?
@namitsharma7839
4 жыл бұрын
Sir, One of scheduled job suddenly start taking...more time ...before it was running properly..and we don't even change anything in database. As i checked there is no BLOCK session. Please give me some solution to rectify this.
@dbagenesis
4 жыл бұрын
Depends on what job the scheduler is running. How was the CPU load at the time of job run? How was the instance load? Investigate in these areas and also try to get ASH report during the scheduler run and look into it.
@namitsharma7839
4 жыл бұрын
@@dbagenesis thanknyou so much for reply sir
@shwatankbhasin7384
3 жыл бұрын
Arun sir, What will be checklist for database upgradation activity in real time?
@ishanmalik3483
4 жыл бұрын
Hi, what if some of the archives deleted by mistake?
@dbagenesis
4 жыл бұрын
It happens sometimes in realtime that RMAN backups will delete the archives from disk and standby is still waiting. In such cases, you will have to restore archives again from RMAN backups and then apply it on standby. In case you have completely lost archives, no possibility of recovering it, then you will have to rebuild the standby.
@dbagenesis
4 жыл бұрын
Just in case, not sure if you asked this question in regards to Oracle data guard or some other sense?
@dillikar2662
2 жыл бұрын
Really good information but what you mentioned in the title that you don't know. I think you need to change the title so that other people don't waist there time.
@sriramsubramanian8183
4 жыл бұрын
Is it necessary for DBA's to know "How to write a query" /
@dn9416
4 жыл бұрын
Yes
@dbagenesis
4 жыл бұрын
Else how would you query data inside database? If you want to interact with database, you must know how to write sql queries.
@mohdfaizan4663
3 жыл бұрын
Sir, how can we gather statistics for all tables (ex-500 tables) in a schema in one go as we can do the rebuild indexes in one go.
@dbagenesis
3 жыл бұрын
You can also gather stats at schema level
@dipeshshah9207
4 жыл бұрын
hlw arun, i am currently working as network administrator, but i want to become DBA. pls suggest how and where to start.
@dbagenesis
4 жыл бұрын
You must start with Linux and follow below order (strictly): - Linux (Oracle Linux or Red Hat) - Oracle SQL (go with 12c version) - Formal course in database administration - Get OCA certified Above is enough to get a job as a DBA, once you are in DBA job / project, you can always upgrade your skillset to RAC, Golden Gate etc...
@vishalkunden4318
4 жыл бұрын
After upgrading database do we need to keep old binaries or can we remove it.
@dbagenesis
4 жыл бұрын
Yes you can only after you are sure that you are not going to rollback to previous version.
@vishalkunden4318
4 жыл бұрын
after removing it will not impact anything to currently running database.
@dbagenesis
4 жыл бұрын
No, coz your DB is now running from new home.
@vishalkunden4318
4 жыл бұрын
ok thanks alot and Happy new year🎂🎂🎊
@reda4tube
4 жыл бұрын
If The diag directory is not in the new home also FRA? So shall we add and configure it?
@chandudevarapu1578
3 жыл бұрын
I recently find your channel. For oracle sql plsql developers which videos are useful regarding performance tuning in your channel
@KIRANCHAVAN47
4 жыл бұрын
Hi Arun do you know hindi language if yes so requested you make video in hindi so lots of our Indian people they understand properly hope you take it as positive ways Thanks in advance
@saleelbagde4558
3 жыл бұрын
📣
@robk4099
2 жыл бұрын
Not 30 days default is 7
@AniketPatil-yr1iw
4 жыл бұрын
Hi Sir, Nice video. Do you have any what's app group for DBA / DATABASE DEVELOPERS.??
Пікірлер: 156