9.0.4.5 Maintenance Release Oracle Designer available

Lucas Jellema
0 0
Read Time:1 Minute, 54 Second

Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is not yet available on OTN’s Designer Software Page, there you will still find 9.0.4.4. If you have an existing Designer/SCM 10g release on your machine (either Oracle Designer 10g (9.0.4.3) shipped with Developer Suite 10g (9.0.4) or the release 9.0.4.4), use this download to upgrade Designer/SCM to release 10g (9.0.4.5). Install into the same Oracle home as your existing release, then run the RAU to upgrade the repository.

If you do not have an existing Oracle Designer/SCM 10g release on your machine, you must first install Oracle Developer Suite 10g (9.0.4) and then proceed as for upgrading.

The download is 340 Mb, Client Side install is a breeze and the Server Side upgrade requires only a few minutes.

The 9.0.4.5 and 9.0.4.4 releases, compiled from Metalink.

One remarkable piece of new functionality is a performance enhancement based on the VPD or Fine Grained Access Control facilities in the 9i Enterprise Edition that replaces te rather expensive workarea-context resolution currently in place.

Oracle Designer/SCM 10g (9.0.4.5) will automatically incorporate performance
enhancements into the repository during upgrade if your dataabse has RLS (row
level security) enabled. This will affect the way thay you import a full
repository dump if the name of the database owner performing the import is
different to that of the exporting repository owner. Please install the
Designer/SCM client and read the release notes for full details BEFORE running
the RAU repository upgrade as the additions of the performance enhancements
and use of RLS is an irreversible action. Note that you can prevent the
these changes from happening by denying execute permissions on DBMS_RLS to the
repository owner (“repos owner”).

I have had some feedback from the field that indicated that this performance enhancement actually slowed the system substantially down. Apparently, if after doing this upgrade you are faced with poor performance, you may consider switching of this particular performance enhancement.

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %
Next Post

Steve Muench on improving ADF performance

Yesterday we had a technical session at Amis on ADF. In one discussion a concern was raised on how all the ADF metadata and the abstractionlayers would affect performance. Quite coincidently Steve Muench posted a presentation on Improving ADF performance he gave at Oracle Open World yesterday. A very good […]
%d bloggers like this: