Search

Top 60 Oracle Blogs

Recent comments

RDBMS

ORA-14696: MAX_STRING_SIZE migration is incomplete for pluggable database

Like me, in the future or for testing, you might need a database with varchar2(32k) support. Although most is explained, the current documentation is a...
class="readmore">Read More

An AMIS Overview of Oracle Database 12c

The presentation used during the highly successful AMIS Oracle 12c Launch Event is online for those who are interested. Enjoy. Special thanks for Thomas Kyte; for allowing me to use some of his pluggable database presentation content. An AMIS Overview of Oracle database 12c (12.1) from Marco Gralike

Oracle 12c: PGA_AGGREGATE_LIMIT

There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle… From the Oracle 12c Reference manual PGA_AGGREGATE_LIMIT: PGA_AGGREGATE_LIMIT PGA_AGGREGATE_LIMIT specifies a limit on the aggregate PGA memory consumed by the instance. There is no difference in behavior between PGA_AGGREGATE_LIMIT being explicitly set or being set to

Read More...

Oracle 12c: Database Parameters…

For those in a desperate need to learn all 3351 database parameter variations… x_ksppi.txt …if you break it, then… …please let me remind you some info mentioned on my “About”-page: The content presented has been tested as good as humanly possible. But be warned: always properly test it before you use them yourself… Applying ideas,

Read More...

Oracle 12c: DB Express – Sneak Peek

The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a small overview (sneak peek) into this great new tool for, for example, database performance tuning, hereby some pictures to create some appetite. I created some have …

Continue reading »

Oracle 12c: Getting Started with DB Express

Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use of what is called the “XDB Protocol Server”, which among others supports the Oracle APEX standalone PL/SQL Gateway. For people who are unknown still how to …

Continue reading »

Oracle 12c: Oracle XMLDB is now Mandatory!

Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in the new feature section of the Oracle XMLDB Developers Guide for Oracle 12c: Oracle XML DB is now a mandatory component of Oracle Database. You cannot …

Continue reading »

Hotsos Revisited 2013

Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle Performance Symposium Hotsos plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties en discussies, want naast presentaties van Tom Kyte, Cary Millsap, Maria Colgan en Steven Feuerstein over performance, worden er ook onderwerpen behandeld zoals Big Data, noSQL, …

Continue reading »

Farnham’s Seven Steps of Application Design

Here is a snippet I wrote on the oracle-l list today before I remembered that I’m a blogger now. To see the whole thread in context (potentially including someone telling me I’ve got it all wrong later today or in the future) the subject was OT: sheltered little world i live in -> NODB?

Someone opined about where a DBA would start designing. That person might be right about some DBAs. Here is approximately what I wrote (only fixing some typos and grammar, I think.):

gee whiz. I think people think of me as a DBA. re: “That’s true that DBA would start designing application from database.” (sic.)

Larry Constantine has written some excellent books about information systems design. Many of my ideas are well explained in those books.

Enabling and Disabling Database Options

One of those small items that is easy overlooked (at least I overlooked it...) and I think, arrived with Oracle database version 11.2, at least on Windows/Linux...

The Oracle 11gR2 Database Installation Guide for Windows described a new tool, at least for me, that enables or disables database features on Windows. In the manual it is described as follows...

When you install Oracle Database, certain options are enabled and others are disabled. If you must enable or disable a particular database feature for an Oracle home, then shut down the database and use the chopt tool. See Example 5-1.

The chopt tool is a command-line utility that is located in the ORACLE_HOME\bin directory. The syntax for chopt is as follows:

chopt [ enable | disable] db_option

The possible values for db_option described in the following table.