Using Advisor to increase the quality of your application.
For the last post in this series, I want to end with something that will help you improve the overall quality of your apex applications. That something is called: “advisor”.
The easiest way to access advisor is through the edit page. If you press the “utilities” button, and then select the option “check”, you will end up in an advisor report for the current page.
You can find the full length video of my Delphix talk that I did at OakTable World on Tuesday here: url
Also, the OakTable folks have updated the OakTable World agenda page with video of all the talks. This has lots of good material and for free. Scroll down to the bottom of the page to find the links to the videos.
When I am trying to install oracle 12c software in windows server 2012 r2, Its asking the windows user credentials. So I had given the windows new user “Test” and password like ” Test@123″ . Oracle installer accepted this password but windows not accepted this password because of password poilcy.
- Atleast 8 characters inlcude letter, number, symbol
- Also Don’t put your password letter as same like user name. It should not be identical.
This morning was my last day of Oracle OpenWorld sessions and this afternoon and evening finished off my day with Delphix Sync.
The first talk was my only NoSQL talk. It was interesting because the claim was that NoSQL was good for large numbers of simple transactions. This seems to be a theme across a couple of sessions. The funny thing is that the NoSQL code reminded me of my pre-SQL mainframe Datacom DB database (more...)
Well, it was a long day but it ended in a fun way.
Today I was back to the normal OpenWorld sessions starting with the general session. It was eye-opening because the speakers described a new CPU chip that they were using in their latest servers. It had some custom elements to support database processing. It was strange because I have recently been studying the latest Intel x86 documentation and it was interesting to compare (more...)
After months of waiting and anticipation. Oracle Forms 12c was released today at the kick off of Oracle OpenWorld. And if you don’t believe me download it HERE !
Join us at Oracle OpenWorld to see demo’s and learn more about 12c new features and Oracle Forms cloud support and mobility. Schedule your 1:1 meeting HERE.
In a hectic year it is good to attend and contribute to Oracle user group sessions. This adds an element of a ‘Working Holiday’ to someones schedule. I can promise you, the vacation isle of Rovinj is a perfect venue for this and especially since it is the last week of the opening of the Hotel for this season.
Of course you can find all information about contributing to these events right here!!
The weather is cooling down, it’s the season of pumpkins, football, and, most importantly, it’s time to get excited for Oracle Open World! There are so many amazing sessions and speakers this year. We wish we could see all of them. To help you narrow down the list of choices, Mia Urman, Oracle ACE Director and AuraPlayer CEO, complied a list her of Must-See Sessions.
Before I discuss Mia’s favorites, I will begin with ones (more...)
A long, long time ago, people started using the following SQL idiom:
with t as (select /*+ materialize */ …..)
select …. from t
If my memory serves me right, Jonathan Lewis was the first person whom I saw using this idiom. The use of that idiom was to speed create a global temporary table and reuse the query results, without having to re-execute query again. Here is an example:
SQL> set autotrace on
One of the under-utilized killer features of Oracle ADF is the Data Visualization (DVT) compontents.
It is easy to build bad visualizations as Oracle themselves show in the documentation:
However, the commercial application that Oracle build with ADF (Fusion Applications, Enterprise Manager) obviously have benefited from the skills of professional visualization designers. These products use of visualizations well.
You application could probably benefit from some visualizations, too. Check out Status Meter and LED gauges as (more...)
Database startup fails:
ORA-16038: log one sequence 3144 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312 online log 1 thread 1 <path to redo log file>
In the alert.log:
ORA-16014 signalled during: ALTER DATABASE open …
ORA-19815: WARNING: db_recovery_file_dest_size of xxx bytes is 100.00% used, and has 0 remaining bytes available.
support id : Flash Recovery Area Full – Database Fails to Open ORA-16038 (Doc ID 337258.1)
(warning: this is a rather detailed technical post on the internal working of the Oracle database’s commit interactions between the committing foreground processes and the log writer)
After the Trivadis Performance days I was chatting to Jonathan Lewis. I presented my Profiling the log writer and database writer presentation, in which I state the foreground (user/server) process looks at the commit SCN in order to determine if its logbuffer contents are written to disk by (more...)
As you may know, not indexing foreign key can have a huge impact on lock behavior and hurt database scalability (Not only with Oracle).
But there is also some rules of thumbs (coming from Asktom) when non indexing the foreign key is considered as reasonable.
So, when do you NOT necessary need to index a foreign key ?
In general when the following conditions are met:
o you do NOT delete from the parent table. (especially with (more...)
On the 6th of October the Oracle Cloud Day 2015 takes place in The Netherlands. iAdvise is proud to be a bronze sponsor on what promises to be a day filled with interesting sessions.
One of the main topics will be the Oracle Database Cloud service. In this blog post, which was published in the OGh Visie earlier this year, you can read what the Oracle Database Cloud Service is, which configuration possibilities there (more...)
The Problem – Missing Target Details
I was evaluating an Information Publisher report containing data about host targets. The report is based on the sysman.mgmt$os_hw_summary view that contains all sorts of information about your hosts. It is an excellent data source for Information Publisher reports. Unless the data is missing.
One of my hosts didn’t appear in that view, even though the host’s console page appeared healthy. Then I looked at the details. Instead (more...)
I am currently working in a team alongside a gentleman known as Roberto Rigliaco. You are unlikely to have heard of Roberto as he is not (yet) a blogger and not (yet) known on the conference circuit.
Nevertheless, Roberto has done some excellent work recently analyzing the use of object statistics in partitioned tables. I haven’t seen his findings published anywhere else and so I am glad to say that Roberto has accepted my offer (more...)
Ever deleted or changed something by accident in your application and wished you could get it back?
You can! The oracle database has a feature called flashback, and APEX can take advantage of this feature. (Flashback needs to be enabled on the database, if you are not sure if it is enabled on your database, you can always ask your DBA).
Today I will show you some of the different places, where you can (more...)
The EM agent’s scheduled activities can be listed using emctl status agent scheduler, like this:
You’ll see a regular cycle of Response calls (anybody home?), metric uploads, and heartbeats.
As of August 1, 2015, Google promoted Fishbowl Solutions to Premier Partner status! This elevation is a testament to our commitment to selling and servicing Google Search Solutions, and we are very excited to be counted among the select companies to attain this level of partnership. Kim Negaard, the Google Product Manager at Fishbowl, took some time to talk about our history with Google and what being a Premier Partner means.
The post Fishbowl (more...)
There is quite a debate going around based on Simon’s linkedin post regarding the future of Forms; but when you read it you’ll see, he doesn’t actually talk about the future of Forms – he talks about the demise of Forms and its replacement with Oracle APEX. As someone who does believe in the future of forms, there are several things I wanted to clarify.
Firstly, it mentions that despite the release of Oracle Forms 12c, Oracle (more...)