I know, I know… Just answering questions that I keep receiving from folks repeatedly, so if you know this one, love ya, if you need this answer, here it is! 🙂 To secure/unsecure or to resyncronize an agent, you need the agent registration password. This would have been created when you performed the installation and configuration of the Enterprise Manager 12c. If you didn’t perform the installation or you’ve just started to support it, you are most likely scratching your head and asking where could so and so have put that password?!?!? No fear- you can add one to be…
-
-
When an agent reports that it’s blocked and needs to be resync’d, most DBAs are going to log into the Enterprise Manager 12c console and attempt a resynchronization to have it fail. A resync isn’t required very often, but if you do run into “Agent Blocked”, here are the initial steps that should be performed to have a resync complete successfully. Log onto the server that is reporting it’s blocked. If a MS Windows server, then open a command prompt “as an administrator” and go to the agent home, (this can be seen in the console under “home location” and…
-
Training Days 2014 for RMOUG starts in just TWO days. Tim and I have picked up Jonathan Lewis and Pete Sharman this weekend, the flurry of speakers will be arriving in the next couple days. With the fantastic help of Team YCC, we have an incredible conference planned for everyone! If you haven’t downloaded the Guidebook mobile app from the App store or Play store, do so, as you can’t miss out on this great application to make the most of the conference. You can build your schedule, read up on Speaker/exhibitor bios, keep up with all the going on’s…
-
I often have folks ask me for assistance when target discovery isn’t successful. The following is from a client’s environment that shows just how important it is to ensure your server environment is kept pristine. The goal was to discover a new database on an existing RAC cluster. The cluster had already been discovered and configured, but the DBA was experiencing a failure upon adding the database targets. Once the cluster is configured through a manual discovery using the GUID wizard, adding a RAC database is often a simple process. Just click on Targets and Databases from the EM12c console…
-
**Note- This is an article I wrote about 4 years ago that, as far as I know, can only be found in hard copy and although I’ve changed my stance on statistics, etc. with 11g/12c, the main point of CTAS benefits still stands the test of time. As a kid did you ever watch the cartoon Hanna-Barbara’s, “the Jetson’s” and see Elroy drop out of George Jetson’s flying saucer, going to school via his personal, hyper-pod and thought, “forget the bus, I want to go to school in the hyper-pod!”? For any developer or DBA working with large objects…
-
Information Publisher, (IP) Reporting has been a feature of Enterprise Manager for quite some time now, but I’ve just recently started to work with a few clients who’ve wanted to put it to use, but not implement BI Publisher, (yet… :)) If you haven’t investigated the “canned” reports that are already available to a user of the Enterprise Manager, (EM12c) then you are missing out, as there are a number that are highly valuable. Accessing the feature is as simple as logging into the EM12c console and clicking on Enterprise, Reports, then Information Publisher Reports. You will see the list…
-
So yes, I’ve been involved in a number of conferences and in a number of different roles. I started out presenting, then volunteering at conferences, reviewing abstracts, then as a track lead and now as a conference director for RMOUG. This year I also am the database track lead for ODTUG’s KSCOPE for a second year in a row. A lot of folks have asked me recently what they need to know to submit a great abstract, how to get accepted and why they may not have been selected. It’s often a lot more complicated than what it may first seem…
-
Inspecting work area usage for memory is an important aspect of my job when I’m performing a tuning exercise. This is especially true when we are talking about specific processes vs. overall database level. Often, along with SQL enhancements, choices in source objects to a process can improve performance drastically. Most developers are focused on the results of query, especially with tight deadlines vs. performance and the DBA can often assist them in succeeding with both. The process for our example today is a CTAS, (create table as select) that has a number of joins , a union, along with…
-
So I tried to finish out some of my OOW posts, but I ended up talking about this with a friend and thought I would share how I became Facebook friends with Larry Ellison instead…. After returning from Oracle Open World 2011, I sat one day at my desk, staring in disbelief, (as many Oracle folks busy in the social media world during OOW were that day) at a friend request from Larry Ellison’s Facebook account. I accepted it and me and my fellow DBAs then reviewed the account to verify that this was Larry’s official account and yes, he’d…
-
Great day today with a second WIT session and all the interviews and General Session for Enterprise Manager 12c. If you are looking for the ebook, you can download it from Oracle here. A couple people caught on that I was tweeting while discussing the benefits of EM12c, even capturing me in a photo, (will never live it down… :)) They played the trailer for the new Cloud Odyssey movie Oracle has been working on to promote EM12c and cloud. It’s been a lot of fun as they’ve talked about how they came up with the idea based off the…
-
The ACE Director briefings are done and now we are onto Sunday sessions. I’ve already had a couple meetings with folks today and wondering why I didn’t wear flats at 2pm in the afternoon, but there are the important necessities that must be taken care of, like when am I speaking this week, so here’s the schedule: My Oracle Open World Schedule My Oak Table Schedule If you want to meet up to chat, best to hit me up on Twitter @DBAKevlar and loving Oracle Open World 2013 already!
-
Oracle OEM 12c introduces a new feature that enables the creation of Oracle database thin clones by leveraging file system snapshot technologies from either ZFS or Netapp. The OEM adds a graphic interface to the process of making database thin clones. The feature that enables database thin cloning in OEM is called Snap Clone and is part of OEM’s Cloud Control Self Service for data cloning. Snap Clone is available via the feature Database as a Service (DBaaS). Snap clone leverages the copy on write technologies available in some storage systems for database cloning. Support is initially available for NAS…
-
Here are the tuning metrics tables (SQL stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of confusing. AFAI remember they were storing alert history, but apparently they are used for adaptive thresholds – an area for future investigation) I’ve noticed a number of people posting queries using DBA_HIST_SYSSTAT instead of DBA_HIST_SYSMETRIC_SUMMARY which leads me to believe that there is some confusion or lack of information on the metric tables. Oracle 10g introduced metric tables which compute deltas and rates of statistics thus hugely simplifying the ability to answer simple questions like “what is the I/O rate on my…
-
Here is a quick table comparison of different types of metrics views The first line of the table is the classic wait event and statistic views. The following lines are the metric views. The metric views were introduced in Oracle 10g. Why Metrics are good Metric views compute deltas and rates which hugely simplifying the ability to answer simple questions like “what is the I/O rate on my databases right now?” This question, before 10g, was surprisingly tedious to answer. To answer the question one would have to query v$sysstat for example: Select value from v$sysstat where name=’physical reads’; but…
-
This is Part III in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level. You can read Part I and Part II to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Monitoring Templates Monitoring templates, when created via an example database and then used as the default for all databases, allows the DBA control to create incidents and notify on what metrics are important to the business. Creating a Template As templates are…
-
If one is seeing waits for enq: TX – row lock contention then there could be a lot of reasons. One distinguishing factor is the lock mode. If the lock mode is exclusive (mode 6) then it’s most likely a classic row lock where two sessions are trying to modify the same row. On the other hand if the lock mode is share (mode 4) it’s typically going to be Primary/Unique Key: inserting a unique key when someone else has already inserted that key but not committed Foreign Key: Inserting a foreign when then parent value has been inserted but not…
-
One thing that I have found sorely missing in the performance pages of Enterprise Manager is latency values for various types of I/O. The performance page or top activity may show high I/O waits but it won’t indicated if the latency of I/O is unusually high or not. Thus I put together a shell script that shows latency for the main I/O waits db file sequential read db file scattered read log file parallel write direct path reads direct path reads temp Of course it would be nice to add a few others like direct path writes, direct path writes…
-
Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent applications. The number one reason for hard parsing has been applications that don’t use bind variables. Without bind variables queries that would otherwise be shared get recompiled because their text is different and Oracle treats them as different queries. Oracle addressed this issue with a parameter called cursor_sharing. The parameter cursor_sharing has three values exact – the default similar – replace literals with bind variables, if a histogram keep literal in place force – replace literals with…