This morning a colleague of mine noticed an alert from our plan change monitor and prevented any impact on the users by forcing a SQL’s plan to its normal fast plan before the users could be affected. I want to share the monitor script and describe how we use its output.
I know this is long but I want to paste the SQL text of the monitor script here. Review my comments on each step. (more...)
Cross-posted from VoX.
Behind the Oracle user experience goals of designing for simplicity, mobility, and extensibility is a core design philosophy guiding the Oracle Applications User Experience (OAUX) team’s work in emerging technologies: “Glance, Scan, Commit.”
It nicely boils down a mountain of research and a design experience that shapes the concepts you can see from us.
The philosophy of “Glance, Scan, Commit” permeates all of our work in the Oracle Applications Cloud user (more...)
Who can resist a free book Rich Nimeiec book on SQL Tuning? O.K., those who know everything can resist. If you’re like me, this is an opportunity to learn from Rich. Click on the book image or this link to get a free copy, or if you want to pay $10 for a copy click here to buy Quick Start Guide to Oracle Query Tuning: Tips for DBAs and Developers from Amazon. (more...)
I’m genuinely delighted that Graham Smith has added his profile to our ‘How I Work‘ series. Not just because he’s one of the World’s best known PeopleSoft experts, or just because he’s recently joined Cedar’s family of PeopleSoft consultants, but mainly because I was sure he’d give some really interesting answers.
For those who don’t know Graham, he led the PeopleSoft Technical Team at Oxfam for longer than he’d want me to reveal, (more...)
Jonathan Lewis hat zuletzt zwei Artikel zum Thema Truncate veröffentlicht, in denen er ein paar grundsätzliche Erläuterungen zu Verhalten gibt:
- Truncate: erzeugt kleine Mengen von undo und redo, da nur die Metadaten für Space-Management und Dictionary Informationen protokolliert werden müssen. Diese Aussage überprüft der Autor durch einen Test, bei dem er die Sequenz "switch logfile, truncate table, dump logfile" ablaufen lässt. Ein interessantes Detail in diesem Zusammenhang ist, dass die data_object_id eines zugehörigen Index (more...)
This is the presentation I gave at the Scotland OUG back in June 2015 (Yes, I know I’m late).
The presentation was interrupted by a fire alarm (you can read all about it here).
This is a customer case study on a proof of concept we did with a customer a while ago. The PoC was successful and we are now waiting for the application to catch up and go to Oracle 12c so (more...)
I was attempting to replicate the navigation bar example from the Opportunity Tracker application and I noticed my application was missing icons from the sub list dropping off the username.
|Icons in submenu when visible|
Here are the relevant User Interface settings for the Navigation Bar
|User Interface settings|
It turns out in newly created application with Theme 42 the following is used as the sublist entry template<li data-current="true" data-icon="#ICON_CSS_CLASSES#"><a href="#LINK#">#TEXT_ESC_SC#</a></li>
In my application (more...)
I have two last debuts from the Scotland OUG meeting – the presentations.
First, the SQLcl presentation and the demo.sql file to run the things I showed there.
I thank everybody who found the time to come hear me talk and I hope you enjoyed the presentation.
Direct access on SlideShare: http://www.slideshare.net/zohare/sqlcl-the-next-generation-of-sqlplus
alias cdcl='cd /u01/app/oracle/sqlcl/bin/'
-- ## connection
Maybe you realize how difficult it is to go from an idea to a successful company. Maybe you've attempted one (or more) yourself. Is the American dream a startup? It is for some, but not all. If you start a company and you're the only employee and you don't get paid, is your business a startup? Is it successful? Beauty and success are in the eye of beholder. You might hear people suggest you set (more...)
One of my recent writings got posted on O'Reilly's Radar. It explores the future of development projects and teams while using all the new xPaaS services offered by today's clouds. While the article is more a thought leadership piece based on a vision Mark Little sketched earlier, it also has some aspects in it, which you can find in projects as of today already.xPaaS - All The PaaS OfferingsGartner
uses the term xPaaS (more...)
This small example
is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding: https://apex.oracle.com/pls/apex/f?p=93000:806
I’ve beeen a little slow in the follow-up to my previous posting on possibly redundant indexes. Before going into the slightly more complex stuff, there’s another peripheral point (but a very important one) that’s worth raising about how clever the optimizer can be. Here’s some code for 220.127.116.11 to demonstrate the point:
create table t1
with generator as (
select --+ materialize
level <= (more...)
This is definitely worth of mentioning. Go here
and download this plugin for Firefox or Chrome. You will like it. It switches the panes in the Page Designer so you can much easier access the properties of the selected elements. Congrats Filip
. This is a cool feature. Thanks.
For the past few months a friend has been driving me crazy with all his praise for Splunk. He was going on about how easy it is to install, integrate different sources and build reports. I eventually started playing around to see if it could be used for a personal project I’m working on. In no time at all I understood what he was on about and I could see the value and ease of (more...)
Yesterday I received an Amazon Dash for ordering IZZE juice.
I think it is a great device, not that I would order tons of IZZE from Amazon, but at $5 it has wifi module + a micro controller + a LED light + a battery + nice enclosure, and it’s usually in deep sleep which means the device can last for years. That’s a bargain – a similar device would cost $20 – $40, at (more...)
I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was no asmcmd. In 2005, Oracle released Oracle 10gR2 and asmcmd came into the place and we figured out how to make it work with a 10gR1 ASM. We were very excited to have a command line for ASM until… we tried it ! let’s call a spade a spade, it was very (more...)