Главная

Query Running Slow | #dailyDBA 1

Кадры Query Running Slow | #dailyDBA 1

Описание Query Running Slow | #dailyDBA 1

Коментарии Query Running Slow | #dailyDBA 1

Hello,brHow to find query generating more redo/archive log in Oracle database?brThanks Comment from : @AltafHussain-hy6fo

Hi All, is there any option to manage the export/import without Linux level access Can you help on this Comment from : @sureshkrish07

Not 30 days default is 7 Comment from : @robk4099

Great Sir Comment from : @rajendrasingh-sr1eo

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 Comment from : @dillikar2662

Hello Arun sir, long time no episode of Daily DBA? Comment from : @rajatsanwal9919

Thank you sir for your good video Can you make videos about oracle applications ebs 121 or 122 please Comment from : @jonybarua5283

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 Comment from : @arvindkumarlal743

please start a video searies on oracle development course project base Comment from : @InamUllah-dc5bh

Hi ArunbrWould you please help me with how to retrieve billions of records as much faster on Oracle database Comment from : @kaira7710

Arun sir, What will be checklist for database upgradation activity in real time? Comment from : @shwatankbhasin7384

How can we find or auery benefits in library cache when we start using bind variables for similar SQLs instead of hard coded literals Comment from : @viralmody6316

Can you explain please latch and mutex concepts in oracle ? Comment from : @viralmody6316

📣 Comment from : @saleelbagde4558

Thanks a lot for taking your time to explain questions with alternatives point of views! Very useful videos Comment from : @nataliaosorio2691

Why do you prefer manual upgrade instead of DBUA? Comment from : @muhammadmakhshiftanvir3602

Great video Arun, it is really informative, THANKS! Comment from : @alanrodriguez5204

Hai iam freshers Iam intresting towards DBA it's good option for freshers In DBA which Technology now a days trending Comment from : @kishorekrish2254

Very good initiative for busy DBAs to refresh their DBA knowledge - this is go to youtube channel - keep up your good work Arun Comment from : @palpali69

awesome video Comment from : @himabindhu7970

Thanks for sharing it I just started watching your videos Comment from : @chitrakgarg1114

Great content Arun Comment from : @elongemusinga1138

Hi sir brbrThis is SheikshavalibrbrI have one question brbrI 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 )brbrI hope you understood my question brbrPlease give a solutionbrbrThank you sir brSheikshavali Comment from : @shekshavali8513

I recently find your channel For oracle sql plsql developers which videos are useful regarding performance tuning in your channel Comment from : @chandudevarapu1578

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 Comment from : @mohdfaizan4663

Thanks for the video Arun Can we import a single table from full export dump? Comment from : @hareeshb579

Thanks for video Comment from : @abdullahahmadi2264

Hi Sir,brNice videobrDo you have any what's app group for DBA / DATABASE DEVELOPERS?? Comment from : @AniketPatil-yr1iw

Please make a video on PRAGMA COVERAGE,DEPRECATE,INLINE,RESTRICT_REFERENCES Comment from : @02vikassoni

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 Comment from : @KIRANCHAVAN47

very usefull ! Which path did you choose for becoming Web designer Comment from : @mdarif-rt9mg

Great work Arun brI have upgraded (manually) my 11204 database to 12102 and also I have upgraded the dst_timezone to 18 But after running the post_upgrade_fixupssql It's still showing old_time_zoneSo, my question is whether this is some sort of bug in oracle 121 or do I need to upgrade to timezone to some other values?? brPlease do respond :) Comment from : @sahiltyagi4454

Very interesting and useful Thank you Comment from : @thiruardura

Thank u arun Comment from : @nhrafi6563

Good idea Comment from : @syedarshad6055

What does stats gather actually do and how does it would help to improve the performance of the database ?? Comment from : @yoganand7416

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? Comment from : @basilkurian6871

Great work! thanks! Comment from : @asrytube

Thanks a lot Sir Comment from : @sarahsaraswathy3010

Thanks a lot Comment from : @MsSpatana

Supper sir Comment from : @bhavanisankaryerriboyina4939

Really that you Arun bhaiya ! It was really helpful Just now Started watching YouTube series of "DBA genesis" Comment from : @itisvikash

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 Comment from : @dhirensingh5327

Can you tell me how cursors work actually in shared sql areaI am confused why and when the same sql Id will be having its child cursors and version counts??brSometimes 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 Comment from : @sivakumarayachitula6469

Your explanations is very good Can you please make a vidio session on plugable databases and multitent topics for clear understanding Comment from : @abdulgani-iq9bg

Thank you Comment from : @truthhurts9601

Sir, brOne of scheduled job suddenly start takingmore time before it was running properlyand we don't even change anything in databasebrAs i checked there is no BLOCK sessionbrPlease give me some solution to rectify this Comment from : @namitsharma7839

hi sir, we are facing low volume/sound issue for most of your videos,please improve sound qualityTy Comment from : @amitshinde9724

My database size is 500 GB and what's the recommended size for FRA ? brWhat are the parameters need to be considered before we set the FRA ? Comment from : @sadanb4876

Salute sir🙏 Comment from : @bharathkumar-ds8cd

Hi Arune, could you please explain what are differences between flashback database and guaranteed restore point ? Comment from : @imdadkhan7951

Which value from AWR report will give the information that xyz index needs a rebuild? Comment from : @vrushalijwalesh1901

Hi,brbrbrI have a datawarehouse environment 2 node RAC, Oracle DB 12102, Golden Gate 18c Configuration of GG is downstream Everyday around 350 GB archive is being generated DB size is currently 34 TB Can you please advise on a backup strategy to make backup faster? Do you recommend Intelli Snapshots based on hardware? Comment from : @roshanjohn3076

1 In this case of adding new column it will impact on the user, user trying to access the table while adding a columnthe query which has fired by user it was hung and those sessions was block till alter table got completed br br2I 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 br brI really like this videos Comment from : @ranjithkumarks6045

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? Comment from : @atifbhure7554

Difference between Data Guard and Golden Gate and which is recommended for which scenario Comment from : @srikanthlolugu990

Thanks you so much for the video :) Comment from : @udaykiran60

Nice video sir Comment from : @sureshhello-zn4cw

Hi Arun,brKindly explain about blocks and how to recover the corrupted blocks Comment from : @sai3276

A lot of DBA's are woriied about future of what will happen once autonomous DB comesMany thinks they will lose jobs please answer Comment from : @amandeepgera4109

Can you please tell me, what DBA do on daily? brI am new for oracle DBA Comment from : @chintalapurisuresh3330

Arun Sir, your tips and DBA Genesis video are really helpful for me Comment from : @umeshdhote1917

Great initiative :-) lot of useful tips, a must watch series for fellow Oracle DBAs Comment from : @rennybabu8686

Very good initiative Arun😊, thanks lot All the best👍💯 Comment from : @jegdeeshcse

Thx arun, loved it Comment from : @vinod1704

Is it necessary for DBA's to know "How to write a query" / Comment from : @sriramsubramanian8183

Great job bro 👍 Comment from : @vigneshchinna358

Please keep it continue Comment from : @nrsaini29791

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 Comment from : @SandeepSharma-bk6rl

Very useful Request you to raise volume of video for clarity Comment from : @amirmule5333

That’s good, keep post daily Comment from : @sathishram386

After upgrading database do we need to keep old binaries or can we remove it Comment from : @vishalkunden4318

Good,keep more videos on pt Comment from : @babuk3521

Thanks you for the information One correction control_file_record_keep_time is 7 default Comment from : @rocksolid194

Wow, very much excited 😊😄😄😄 Comment from : @matheenahamed2692

Nice viedo siri need viedo on performance tuning Comment from : @satyaprasad2009

Thanks for uploading the video sir, good work keep coming Comment from : @aqeebjaveed3230

Похожие на Query Running Slow | #dailyDBA 1 видео

SQL Server Performance issues || SQL Server Long Running Query || SQL Server Query Running Slow РѕС‚ : Tech and Art Download Full Episodes | The Most Watched videos of all time

How to Troubleshoot a Slow Running Query in SQL Server Azure SQL|Query Tuning|SQL Server Wait Stat РѕС‚ : DataDrivenCommunity Download Full Episodes | The Most Watched videos of all time

Slow Running Query - SQL in Sixty Seconds 146 РѕС‚ : Pinal Dave Download Full Episodes | The Most Watched videos of all time

Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar) РѕС‚ : SQLMaestros Download Full Episodes | The Most Watched videos of all time

How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar) РѕС‚ : DataPlatformGeeks u0026 SQLServerGeeks Download Full Episodes | The Most Watched videos of all time

Interview question 02 - slow running sql query ||sql interview questions #performanceimprovement РѕС‚ : Sql Is Easy Download Full Episodes | The Most Watched videos of all time

interview question 03- slow running query? #sqlserver #performanceimprovement РѕС‚ : Sql Is Easy Download Full Episodes | The Most Watched videos of all time

Interview question 01 -slow running sql query ||sql interview questions РѕС‚ : Sql Is Easy Download Full Episodes | The Most Watched videos of all time

Oracle SQL Tuning Interview Question 1 - My SQL Query Is Running Slow Today РѕС‚ : Virsess !!! Download Full Episodes | The Most Watched videos of all time

Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning РѕС‚ : Siva Academy Download Full Episodes | The Most Watched videos of all time