(James F. Koopmann) In Part III we left off displaying the enabled traces and statistic gatherings we enabled through the DBMS_MONITOR package.
Tag: Oracle
Top 5 Myths About Patching Apps Environments
(Steven Chan) A rational person might contend that actions follow attitudes which follow beliefs. Bad news: there’s a substantial amount of psychological literature that suggests that this isn’t how we really tick.
Transformations
(Joseph Fuda) This tutorial demonstrates how to transform numbers like 1, 12, and 123 into English words like “ONE”, “TWELVE”, and “ONE HUNDRED TWENTY-THREE”. This transformation is a common requirement for cheque printing applications.
Oracle RAC: Checking RAC status with SQL/OS level statements
(Tarry Singh) Our last article was about monitoring RAC, which we will get back to in upcoming articles. Monitoring can be a daunting task for a DBA but fortunately, the EM console is a good place to start. There are vendors that deliver products to monitor RAC–we did a 3-part article reviewing the
Column Naming
(Dominic Delmolino) Laurent’s post on column qualification reminded me of a conversation I had with one of my staff about column naming standards. But before I get to that conversation, I’d like to share my favorite example about using table aliases.
Perils and Pitfalls in Oracle Partitioning: Bind Variables?
(Don Seiler) Recently one of my developers found some articles by Arup Nanda while researching a query performance problem. The articles were title “Perils and Pitfalls in Partitioning,” parts 1 and 2.
Disable a Button
(Joël Asselin) This very simple example will present a Form Personalization to remove the “New PO” button normally found at the bottom of Purchase Order Summary form.
Avoid the @ symbol in Oracle passwords
(Bob Watkins) Password complexity is one of many things that IT auditors examine to see whether a system is secure. IT policies usually state that a password must be a minimum length and include a mix of uppercase and lowercase letters, numbers, and special characters.
Column qualification best practice
(Laurent Schneider) Lazyness at the development can have dramatic costs in production and maintenance. I want to summarize why and where you should always qualify your columns.
Sending binary data from Oracle Application Server to WCF through MTOM: Part II
(John Charles Olamendy) The first to do is to launch Oracle JDeveloper IDE, create a new Empty project from File| New on the main menu and name it MTOM_Server. Then go to the Applications Navigator windows, right-click on the project MTOM_Server and select the New option from the context menu. In th
