วีดีโอ

@shashiranjan06cse04 - Thanks for your question. What is your OEM, RU level and full OL-7 version?

@yantrapragadaaneshteja5272 - Please post your question under the relevant video. For example, given below is the link to one of my tutorials on Power Bi dashboard on DB and server performance. th-cam.com/video/bl1RShI8keo/w-d-xo.html

Thanks for your feedback.

Thanks for your feedback.

@neerusharma8482 - Thanks for your question. This tutorial is for creating a Metric Extension (ME) for alerting on long running SQLs. An ME can operate on a single value to alert on. It cannot accept multiple values returned by the base SQL. Moreover it does not matter how many SQLs are running longer than the threshold you set. It may be 1 or 10 or even more. All you need is an alert to notify that a DB performance issue is going on. Now coming to your question about how to get a list of all SQLs running longer. For that, you have to create a report in BI Publisher Reports, a shell script or any other tool. You may modify the SQL used in the ME to remove the MAX grouping and select the columns in the SELECT list such as SQL_ID, SQL_Text, Elapsed_Time etc. You can tweak the ME and the SQL used to get a few of the SQL IDs in question etc, but not all the details.

@@YouVolve Thanks for reply, I just started watching you sessions. That is very good

Thanks for your feedback.

Thanks for your feedback.👍

Thanks for your feedback and honest opinion on the background music. With due respect to the viewer like you, I no more add background music to my videos. But this one was made long back with my limited TH-cam skills and can't edit or remove the music.

Thanks for your interest. These topics are definitely going to be covered.

Thanks for your feedback..will do.

Thanks for your feedback..will do.

Thanks for your feedback..will do.

Thanks for your feedback..will do.

Thanks for your feedback..will do.

Thanks for your feedback..will do.

Thanks for your feedback. Those topics are in my to-do list.

Thanks for your feedback. Those topics are in my to-do list.

Thanks for your feedback. Those topics are in my to-do list.

Thanks for your feedback. Will do.

Thanks for your feedback.

Thanks for your feedback.

Thanks for your feedback. Will do.

Will upload soon

Thanks for your feedback. Will do.

Thanks for your feedback. Will do.

Thanks Sunil for your feedback. Yes I will upload tutorial on upgrading DB in MT architecture also.

Thanks for watching my video and leaving your valuable feedback. I really appreciate that.

@edgardonb - Thanks for your question. Actually it does not matter even if you put a name of the column in the ME like "ABCD". It's just a variable to accept the value returned by the SQL. You can use whatever name is meaningful to you. FOR_MINUTE, FOR_MINUTES, v_MINUTE anything will work.

Sure

@@YouVolve I will let you know. How 🤔 it goes....

SyedShoeb-i8v - Thanks for your question. The observer configuration file is a binary file created automatically in the default location or in the location specified when the observer is started using the "start observer" Command. There are few prerequisites to be fulfilled in the third server where the observer runs. Pay attention to the 12:53 minutes of the video when we initiate the observer. Also I have mentioned a couple of different options/commands to start the observer. They are mentioned in the document in my google drive (link provided in the video description)

Thanks for your feedback. This question has been already answered multiple times. Please uninstall the connector version you currently have and install an older version like 8.0.27 or 28. That should work. This issue started with the newer version of the connectors released after this video was made.

Thanks for your feedback. This has been already answered multiple times to install an older version like 8.0.27 or 28.

You’re welcome 😊

Glad you enjoyed it!

Thanks for your interest. I am working on PT video. Expected to be published first quarter 2025.

Hi, please share the MySQL Connector and the MySQL RDBMS version you are using.

@@YouVolve mysql version : 8.0.39 for Win64 on x86_64 and mysql connector version : 8.1.0

MySQL version : 8.0.39 and MySQL connector version :8.1.0

@shreyarawat4138 - Please remove the connector version 8.1.0 that you currently have and install version 8.0.28. This should work. If not, then go back further by another 2-3 versions. This issue started with the newer versions of connectors.

@@YouVolveThank you sir !! version 8.0.27 worked for me , but now encountering error like this , "MySQL: Host '......' is not allowed to connect to this MySQL server" .

Much appreciated!

Glad you loved it.

Thanks for your feedback!

Thanks for your interest. Yes that is in my list but now in a lower priority. The reason is - very less viewers response. These high level topics require a lot of effort in terms of research and time before publishing to users. However the viewer response is so low that I had to think twice. But don’t worry it is in my list.

@@YouVolve ok we have requirement for setting up DR if you have any documents please share it your videos are useful interesting I really like your content and explanation in detail on every oem topic

@@YouVolve can you create some videos on oem Information Publisher reports for how to get it on dashboard

Thanks for your feedback. I don't have any documents on OEM DR setup as such. Probably you have to go through Oracle documentation for this.

Information publisher report has been deprecated from OEM. You can use BI Publisher report or Oracle Analytics Publisher. I have a few videos on BIP Reports. You may find useful: Database Reporting: th-cam.com/video/oy9mCE-DEaI/w-d-xo.html RMAN Backup Reporting: th-cam.com/video/3d3dy-0X09I/w-d-xo.html etc.

Thanks a lot

@vaishnavinegi4461 - Please remove the connector version that you currently have and install version 8.0.28. This should work. If not go back further by another 2-3 versions. This issue started with the newer version after this video was made.

@sushilsubugade2947 - The DB down, listener down or any target Up/Down alerts have to be handled via Target Availability type events. This is very clearly demonstrated with an example rule created for a listener down event mentioned in 1:02:22 minute marker of this video. Before you add a rule, to the ruleset, a clear understanding of the OEM monitoring framework is required. Please do not skip the video as that will waste more of your time fumbling between the components of this framework to find out how they work together.

@@YouVolve I did by watching your videos by just creating monitoring template and edit responce in collection settings

I got db down alert when I do some lab excercise on it

Thank you.

Thanks for the confirmation.

@luisjosueferreyracalderon8746 - Thanks for your feedback and interest on learning Oracle. I have given the relevant links below. I am working on the tutorials on performance tuning which are not released yet and expected to be available this year end. I suggest to create your virtual learning environment using Oracle VirtualBox virtual machines. Link is given below for how to do that. Also, watch the full series on OEM to have a better understanding on how it works. Automate RMAN Backup, Restore Validation Reporting etc: Part-1: th-cam.com/video/3d3dy-0X09I/w-d-xo.html Part-2: th-cam.com/video/lRePWwuXlr0/w-d-xo.html Part-3: th-cam.com/video/bBLfIAIbwJk/w-d-xo.html Backup failure alert using OEM: th-cam.com/video/z8MuIF2hsuk/w-d-xo.html OEM Monitoring Setup: th-cam.com/video/j9bA-xagpsY/w-d-xo.html Full series on OEM 13c - 16 parts - start to finish: th-cam.com/play/PLgWj5dy2RoFZLk49TIxMjW5g8C5K0ntjq.html Series on Oracle VirtualBox VMs to create your virtual learning env to practice, Oracle, UNIX, Networking etc: th-cam.com/play/PLgWj5dy2RoFZTLn2tIdZ-P0Yhj_WbOQ9U.html

​@@YouVolve Thank you for your response.

Anytime.

@NianOuyang123 - thanks for your feedback. If you have OTBI you don’t need PowerBI as both are BI tools. Also OTBI has better insight into real time transactional data from Oracle fusion.

@@YouVolve We need to combine the data from OTBI with other data sources. So we want to have a try to connect them.

@NianOuyang123 - Thanks for your question. I believe Oracle will not allow any external connections to the data for their SaaS or Cloud applications. But if you have a way to extract the cloud data (if Oracle permits) into an external staging area, then PowerBI will be able to pull it, combine it with other data objects (your requirement) for your analytics. In my knowledge there is no such option available but you can contact Oracle support for such requirements.

@@YouVolve Got it. Thanks!

@Regnum-007 - First uninstall the current connector software. Then install the previous version of the connector. If that also does not work, keep repeating. I remember in the older versions of connector like x.x.28, x.x.27 this problem was not there. One of the older version should work if you don't have a different issue.

@@YouVolve thank you bro ver 8.0.28 work in my case after trying 6-7 version. thank you so much

Anytime! Glad that it helped.

@@Regnum-007 thanks bro, was facing the same problem the version u suggested worked.

Thank you, I will

Please try with an older version like 8.0.28 or something.

@@YouVolve i already tried but it's showing like a later version of MySQL is already installed

@@YouVolve sir please can I get ur number it's very urgent for me to make project as I am a final year student and it is very important for placement please

​​⁠What is your MySQL DB version, MySQL Connector and the OS platform

👍

@deekshidha3794 - Thanks for your question. The MySQL connector and the MySQL database both are different software. You have to download the connector for 3rd party applications like PowerBI to be able to establish a connection to the database.

@@YouVolve yeah bro I downloaded the connector but I am facing the error I didn't connect what can I do

What is your MySQL version and the MySQL Connector version?

@@YouVolve MySQL version 8.0.38 MySQL connector version 8.40

@thetradesecrets2221 - Thanks for your interest and performance tuning is already in my to-do list. But as it is a vast subject, I need sometime to prepare the topics. The ones you mentioned are just a small part in the application side. However, OS tuning, Storage tuning, database and application tuning all comes under performance tuning. I will definitely make some videos on that.

@@YouVolve meanwhile ...kindly make video on "database slow issue" in Oracle...as it is widely asked question in interview and different people have different answers to it ..🙏

Thanks for your interest. I will definitely cover that topic in the future.