As part of the projects I work on at Oracle, it’s often ensuring that those customers that wish to deploy Enterprise Manager, (EM12c) to large environments, have the correct settings and are tuned to offer the best performance from the Oracle Management repository database, weblogic and up to the console URL’s accessed by users. This means that these large environments often receive recommendations from our experts that differ from what EM12c comes “out of (more...)
No, not the 10th posting about first_rows() this week – whatever it may seem like – just an example that happens to use the “calculate costs for fetching the first 10 rows” optimizer strategy and does it badly. I think it’s a bug, but it’s certainly a defect that is a poster case for the inherent risk of using anything other than all_rows optimisation. Here’s some code to build a couple of sample tables:
begin dbms_stats. (more...)
Information Technology units will continue to be challenged by the unbridled growth of their organization’s data stores. An ever-increasing amount of data needs to be extracted, cleansed, analyzed and presented to the end user community. Data volumes that were unheard of a year ago are now commonplace. Day-to-day operational systems are now storing such large amounts of data that they rival data warehouses in disk storage and administrative complexity. New trends, products, and strategies, (more...)
With the recent publicity about the POODLE bug, many web masters are turning off SSLv3 support. Depending on your Oracle database version/patch, that can present a bit of a problem for people using UTL_HTTP to access HTTPS resources, as described here.
My lab server has 2 SSDs, one is connected using SATA 2 and another is connected using SATA 3. I’d expect the SATA 3 connected device to be equally well equipped or even better to do work than the “old” interface. I ran SLOB on these devices to find out if there was a difference. To my great surprise the SATA2 – connected SSD performed a lot better than the SATA 3 device, as shown (more...)
A quick question out to the world. What management tools do you use for MySQL?
We currently have:
- MySQL Workbench : It’s OK, but I don’t really like it. It feels like half a product compared to tools I’ve used for other database engines…
- phpMyAdmin : I’ve used this on and off for over a decade for my own website. While I’m typing this sentence, they’ve probably released 4 new versions. We have an installation of (more...)
Sometimes I get excited over simple things. Today, I learned something new, something about human behaviors.
Basically, there are 4 quadrants for human behaviors.
If one does not understand the other person’s behavior, then communication can be very difficult.
To find more about human behaviors, read The DISC Model of Human Behavior – A Quick Overview.
Which quadrant are you in, versus your manager?
In Oracle, if we add a column to a table which is NOT NULL, we are allowed to do it directly, in a single statement, as long as we supply a DEFAULT value to populate any pre-existing rows.
This would mean that every row in the table was updated with the default value. This could be a pretty nasty side effect, as lengthening every row in the table will inevitably lead to chained rows, and (more...)
Here’s a little puzzle that came up on OTN recently. (No prizes for following the URL to find the answer) (Actually, no prizes anyway). There’s more in the original code sample than was really needed, so although I’ve done a basic cut and paste from the original I’ve also eliminated a few lines of the text:
execute dbms_random.seed(0) create table t as select rownum as id, 100+round(ln(rownum/3.25+2)) aS val2, dbms_random.string('p',250) aS pad from (more...)
Then a thought occurred to me. While he was here, why not setup an informal Oracle users meetup, much like the various ones at cities around the world like Sydney, Birmingham and (more...)
This is pretty simple, but I thought I would share it since it is helpful to me. I have been preparing for a large migration which involves table, index, type, function, package, and procedure changes. When I run a big migration like this I check for invalid objects before and after the migration and attempt to recompile any that are invalid. By checking before and after the migration I know which objects (more...)
Metric thresholds have come a long way since I started working with OEM 10g. I remember how frustrating it could be if an ETL load impacted the metric values that had to be set for a given IO or CPU load for a database when during business hours, a much lower value would be preferable. Having to explain to the business why a notification wasn’t sent during the day due to the threshold (more...)
I’ve mentioned this before, but I thought I would show something visual…
The majority of my readers come from the USA and India. Since they are in different time zones, it spreads the load throughout the day. When I wake up, India are dominant.
In the afternoon the USA come online, by which time Russia have given up, but there is still a hardcore of Indian’s going for it!
I haven’t posted an evening shot as (more...)
Got an interesting question today: There are tables TABLE1, TABLE2 and a junction table that joins them called JUNCTABLE. Need the following output as XML
I know the output could be aggregated using XMLAGG, but I have never looked into how to format the tag names and attributed in the output like requested.
Data in my very simplified sample tables:
SQL> select * from table1; ID ---------- 1 2 3 SQL> select * from table2; (more...)
After server crash you realized that local disks are corrupted and with local disks you lost all Oracle installations. Even though this is important system you don’t have database backup (always take backups!).
But you managed to save all ASM disks as they were located on separate storage.
This will be small beginner guide on how to help yourself in such (more...)