Maintenance Release Oracle Designer available


Today I discovered the maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The is not yet available on OTN’s Designer Software Page, there you will still find If you have an existing Designer/SCM 10g release on your machine (either Oracle Designer 10g ( shipped with Developer Suite 10g (9.0.4) or the release, use this download to upgrade Designer/SCM to release 10g ( 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 and 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 ( 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 Author

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, Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press books: Oracle SOA Suite 11g Handbook and Oracle SOA Suite 12c Handbook. Frequent presenter on community events and conferences such as JavaOne, Oracle Code and Oracle OpenWorld.

Comments are closed.