This issue can be seen in either EM12c or EM13c AWR Warehouse environments. It occurs when there is a outage on the AWR Warehouse and/or the source database that is to upload to it. The first indication of the problem, is when databases appear to not have uploaded once the environments are back up and running. The best way to see an upload, from beginning to end is to highlight the database you want to load manually, (click in the center of the row, if you click on the database name, you’ll be taken from the AWR Warehouse to the…
-
-
This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?” Everyone loves their trusty Top Activity, but the product’s functionality is limited when it comes to custom views and this is what our user had run into. There are numerous ways to display this data, but I’m going to focus on one of my favorite features in the product that was created to replace Top Activity, ASH Analytics. Retaining AWR Data for ASH Analtyics Note: This process to display CPU graphs will work for…
-
SQL Monitor is one cool tool. Via EM12c, it empowers everyone, (yes, that means the developer, too, so give them the access to view this data via Cloud Control, please!) This is a top five list, but it doesn’t stop there, just remember, this is my favorite features when using Cloud Control with SQL Monitoring. Once logged into the database, you can gain access to SQL Monitor by clicking on Performance –> SQL Monitoring. 1. High Level View The main view of active and inactive processing, (just remember, SQL Monitor processes will age out, so keep that in mind that this…
-
Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action. Enterprise Manager also removes some of the syntax options that could get a developer or app support person that is less specialized in creating trace files, all the options and the knowledge of the syntax, etc. from getting into trouble, which creates an option for everyone to be successful. The proposed solution that I’ll post here is where the EM12c user will be able to create trace files, but the DBA will control the…
-
I’ve had a lot of people email and message me asking me what I’m doing with the Raspberry Pi and I wanted to share before the actual RMOUG Quarterly Education Workshop, (QEW) this Friday at Elitches. So a little history- When I was a kid, I was a real handful. My mother used to come into my room and I’d have created “webs” out of yarn strung from every piece of furniture and twisted into patterns. I used to take apart radios and use the parts to create new toys, figuring out how the electronics worked. Dolls suddenly became cyborgs…
-
More and more companies are consolidating environments. Server sprawl has a high cost to any business and finding ways to consolidate to more powerful servers or to the cloud is a productive undertaking for any company. The Consolidation planner in Enterprise Manager has been around for quite some time, but many still don’t utilize this great feature. Creating a Consolidation Project You can access the Consolidation Planner from the main Enterprise menu from Cloud Control in EM12c. There are two consolidation types currently available physical to physical, (P2P) or physical to virtual, (P2V) consolidation. For our example, we’ll perform a…
-
Happy Birthday to me! So for my birthday, I give a present to you… As I want all DBAs to sleep better at night, here are the top ten features you can use in Enterprise Manager Cloud Control to offer a good night’s rest instead of during the day at your desk… 🙂 1. Disable the Default Rule Sets Shipped with Cloud Control. Yes, you heard me. I believe you should use them as a starting point or an example, but don’t put them into production. These were examples set by development to see all that you could be notified…
-
I had a chance to take a closer look at the Zero Data Loss Recovery Appliance, (ZDLRA) via Cloud Control today and really liked the dashboard that’s included in the plugin for the product. This post isn’t going to cover the installation of the plugin or configuration- I was just intrigued by the dashboard and wanted to go over the great features that are part of it. Accessing the ZDLRA As with any Targets, the ZDLRA is going to show up in the All Targets menu and also has a target type filtered drop down in the Targets menu. All…
-
The sales, support and technical teams were brought into the Denver Tech Center office to do some advanced training in Hybrid Cloud. There were many take-aways from the days we spent in the office, (which is saying a lot- most of you likely know how much I hate working anywhere but from home… :)) and I thought I would share a bit of this information with those that are aching for more details on this new and impressive offering from release 5. If you’re new to Hybrid Cloud and want to know the high level info, please see my blog…
-
Last week’s release of 12.1.0.5 was a pleasant surprise for everyone out in the Oracle world. This release hit the bulls-eye for another cloud target of Oracle’s, announcing the introduction of Enterprise Manager 12c’s offering a single pane of glass management of the hybrid cloud. The EM12c team has been been trained and testing out the new features of this release with great enthusiasm and I have to admit, pretty cool stuff, folks! Why is the Hybrid Cloud Important? Many companies are still a bit hesitant to embrace the cloud or due to sensitive data and security requirements, aren’t able to…
-
When you need to have information about one SQL_ID and don’t need everything and the kitchen sink, there are a few different ways to collect this via Oracle. I’m surprised how rarely this is covered in performance tuning/optimization, (whatever the current “acceptable” term is for fixing a database when there are performance issues arise… J) classes, manuals and documentation. I’d like to cover two of my favorite here and know, there are other options that I won’t be digging into, (SQLd360, SQLTXPLAIN, tracing, etc…) The Workload Repository SQL Report I also refer to this as the “SQL ID Specific AWR…
-
There may be a reason that one needs to re-add a database to the AWR Warehouse. This is a new opportunity for me to learn and offer assistance, but I’m working off the grid to figure out a solution. Luckily, it’s just a matter of creating a new process from pre-existing code and processes. The process requires both the AWR Warehouse UI and a SQLPlus connection. 1. Disable the snapshots 2. Extract the AWR for the Database 3. Drop the database from the AWR Warehouse 4. Add the database back into the AWR Warehouse with the retention time or any…
-
When sizing the AWR Warehouse, one of my requirements is to have certain reports for a sampling of databases that will source the AWR Warehouse. This report provides me the right information to create the correct sizing requirements vs. any assumptions done with other choices. The report is the General AWR Information report and can be found in the $ORACLE_HOME/rdbms/admin directory. It provides the following information: Time of Report AWR Retention and interval settings, including if non-default setting. Schema percentage of space used in the SYSAUX tablespace. Objects and space consumption in the SYSAUX tablespace, including breakdown of the AWR space…
-
A common issue I’ve noted are dump files generated from the AWR Warehouse, but upon failure to transfer, the dumpfiles simply exist, never upload and the data is stuck in a “limbo” state between the source database, (target) and the AWR Warehouse. This can be a very difficult issue to troubleshoot, as no errors are seen in the actual AWR Warehouse “View Errors” and no data from the source is present in the AWR Warehouse. Empowered by EM Jobs If you go to Enterprise –> Jobs –> Activity and inspect the Log Report after a search for %CAW% jobs that perform…
-
Here’s a quick guide to my schedule of sessions at IOUG Collaborate 2015 for this year. I’m looking forward to seeing everyone next week, (I’ll be arriving on Saturday, so I really should say in a couple days) and have no doubt we’re up for another phenomenal conference at Las Vegas, this year at the Mandalay! Additionally, there are some great opportunities in professional development at the IOUG Strategic Leadership Program. I’ll be speaking with James Lui on how to improve your value with personal brands and social media. I’m the WIT luncheon speaker on Monday, so for those of you that…
-
Mauro decided to give me another challenge- run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”. It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installation of any packages…) I chose a SQL_ID from one of the source databases loaded and ran it for a 31 day history: SQL> @sqld360.sql 8ymbm9h6ndphq T 31 I saw a few errors scroll by on the screen as the process to collect the data and zip it up ran. There isn’t the same log file to see on successful runs to…
-
I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made were enough to run properly with the AWR Warehouse. The answer is yes and no… and maybe “it depends”… 🙂 The Results The data from the AWR Warehouse to pull the corresponding data for the appropriate SQL_ID from the correct source database in the AWR repository worked, but the environment information still populates incorrectly, as I didn’t update anything outside of the get_database_id function in the SQLT$A package and the executables that call it, as documented in my earlier blog…
-
While presenting at HotSos in Dallas, Tx, an attendee, (thank you Wenju! :)) asked how page performance issues could be identified when the call was being made remotely and not from the Oracle Management Repository, (OMR) using the Page Performance console within Cloud Control. This is a very good question and although not straight forward, I would like to demonstrate what is available to assist in answering the challenge. First, I have to add that the answer is provided using release 12.1.0.4 of the Enterprise Manager 12c, so if you are still running an earlier version, your results may not…