- in einem produktiven System ist es sinnvoll, die Retention der AWR Snapshots auf einen deutlich höheren Wert als den default von 8 Tagen zu setzen (35-42 Tage oder gleich: unbegrenzt).
- weniger sinnvoll ist es, die AWR Intervalle selbst zu verkürzen: also vom Standard-Intervall von 1h auf (more...)
Quick, how many different Web Service specifications are there?
- less than 20
- between 20 and 40
- more than 40
I was in doubt whether the answer would be 1) or 2) – after all, there is a lot of WS-* stuff. Turns out the answer is 3) – there are currently 50 web service specifications.
A technology with 50 specifications is unlearnable. The basics of web services is simple and useful, but the IT industry (more...)
- beim count(distinct column_value) (more...)
I was recently advising a transition project where a customer was switching support and maintenance supplier. This means that one organization must take over a system that has been maintained by another organization for a number of years.
A lot of information is lost in these transitions because knowledge of the problem domain has been accumulated in the heads of developers over many years. This loss cannot realistically be mitigated.
But sometimes, specific information about (more...)
The UTL_FILE database package is used to read from and write to operating system directories and files. By default, PUBLIC is granted execute permission on UTL_FILE. Therefore, any database account may read from and write to files in the directories specified in the UTL_FILE_DIR database initialization parameter [...] Security considerations with UTL_FILE can be mitigated by removing all directories from UTL_FILE_DIR and using the Directory functionality instead.
I’m currently estimating the effort for a piece of software. With 20 years of experience under my belt, I don’t find estimating hard any longer. But back when I started out, I was terrified whenever I was asked to provide an estimate.
In most organizations, too much of the estimating is art and too little is science. Experienced developers can produce good, realistic estimates, but these are often treated as individual efforts and no organizational (more...)
I was aware that up to Oracle 11g, a PL/SQL program wasn’t allowed use an associative array in a SQL statement. This is what happens when I try to do it.
SQL> drop table test_array purge; Table dropped. SQL> create table test_array as 2 select level num_col from dual 3 connect by level <= 10; Table created. SQL> select * from test_array; NUM_COL ---------- 1 2 3 4 5 6 7 8 9 10 10 (more...)
Steven Feuerstein was dismayed when he found in a PL/SQL procedure a cursor FOR loop that contained an INSERT and an UPDATE statements.
That is a classic anti-pattern, a general pattern of coding that should be avoided. It should be avoided because the inserts and updates are changing the tables on a row-by-row basis, which maximizes the number of context switches (between SQL and PL/SQL) and consequently greatly slows the performance of the code. Fortunately, (more...)
I will speak over our experiences with following
- provide user software
- install servers
- iterative test migrations
- migration plannig
- real migration
- and the problems and pitfall’s we find on our way
If you speak german and you are interested in some of this, you should come and attend my (more...)
Oracle Forms Migration Survey: Oracle Forms to APEX / Oracle Forms to .Net / Oracle Forms to ADF / Oracle Forms to Mobile ?
This year at the Kscope conference we started hearing more and more customers saying they were migrating away from Oracle Forms. Many had not started planning or even thought about what such a project entails but the declarations were loud and clear: “We are migrating our Forms system to ______<plug in development tool of choice… ADF…Java…HTML…Net>”. It was as if they were following some trend of what they thought they were supposed to be saying but no one (more...)
I can't be one to comment on tangential intros (just look at any of my presentations), but he almost lost me when I thought the entire post was going to be soccer jokes I didn't get but switched in time to three controversial (more...)
My rating: 4 of 5 stars
This main point of this book is the principle of “failing fast.” Since you don’t know everything (and a startup knows very little), it is most efficient to quickly create some data to base decisions on.
The distinction between “vanity metrics” and real, useful metrics is illuminating. A “vanity metric” shows (more...)
I’ve been following the discussion on the new In-Memory option in the Oracle 126.96.36.199.0 database. As far as I can see, it’s very easy for a developer to start using this feature, which will cost your company $23,000 per CPU at the next Oracle license audit.
PyOhio gave my lightning talk on ddlgenerator a warm reception, and Brandon Lorenz got me thinking, and PyOhio sprints filled my with py-drenaline, and now ddlgenerator can inspect your data and spit out SQLAlchemy model definitions for you:
$ cat merovingians.yaml
name: Clovis I
name: Childebert I
$ ddlgenerator --inserts sqlalchemy merovingians.yaml
from sqlalchemy import create_engine, Column, Integer, Table, Unicode