Tom is not not a fan of public synonyms, here is why: public synonyms pollute the namespace. public synonyms can lead to security issues. public synonyms can lead to a maintenance headache. public synonyms are public – no one owns them. So, instead of public synonyms… Continue reading… © Eddie Awad’s Blog, 2013. | Permalink [...]★
When an Oracle process starts executing a query and needs to do a full segment scan, it needs to make a decision if it’s going to use ‘blockmode’, which is the normal way of working on non-Exadata Oracle databases, where blocks are read from disk and processed by the Oracle foreground process, either “cached” (read …
Read More
News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL. Oracle: There is a significant update…
This is just a very small post on how to watch the progress of the “CopyBack” state of a freshly inserted disk in an Exadata “Computing” (database) node. A disk failed in the (LSI Hardware) RAID5 set, and the hotspare disk was automatically used. The failed disk was replaced, and we are now awaiting the …
Read More
BLOG UPDATE 2012.05.05: Updated the tar archive distribution file with some bug fixes. Simply preserve your slob.conf file and extract this tar archive over your prior SLOB install directory. BLOG UPDATE 2012.05.04: The PDF README will no longer be bundled in with the tar archive. BLOG UPDATE 2012.05.03: First time visitors should see the introductory page […]
The problem of slow queries on v$lock just came up again on the OTN database forum, so I thought I’d better push out a post that’s been hanging around on my blog for the last few months. This is actually mentioned in MOS in note 1328789.1: “Query Against v$lock Run from OEM Performs Slowly” which … … Continue reading →
This entry is part 5 of 5 in the series Grow Your Career All work and no play makes us dull DBAs. Being a DBA can be a really thankless job. From Jr. Shutdown Immediaters to Sr. Rockstar Oracle DBA ACE OCM PMP LOL A+ BBQs, we’ve all trudged into work at some point in our [...]
The post Gamifying the DBA Experience appeared first on Steve Karam :: The Oracle Alchemist.
@flashdba: If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database: I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond latency, so if you see an [...]★
Following on from last weeks book competition, the kind people at Packt have offered another prize. This time 2 e-book copies of Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook by Andy Penver. The competition will run for about two weeks, so I’ll be selecting the winners on 10th May 2013. To [...]
Win A free copy of the Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook was first posted on April 30, 2013 at 10:59 am.
©2012 “
The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
Materialized views open up all sorts of possibilities for making reporting more efficient – but at the same time they can introduce some “interesting” side effects when you start seeing refreshes taking place. (Possibly one of the most dramatic surprises appeared in the upgrade that switched many refreshes into “atomic” mode, changing a “truncate / … … Continue reading →