APEX Training in Bensheim (23.03 - 25.03.2009)

We (Denes Kubicek, Patrick Wolf and Dietmar Aust) are happy to announce the next APEX Training in Bensheim/Germany. Thus the rest of the post is in German.

Das nächste APEX Training findet am 23.03.2009 bis zum 25.03.2009 erneut in Bensheim bei Frankfurt statt, im dortigen Aleehotel.

Oracle APEX: Knowhow aus der Praxis

Nutzen Sie das Wissen und die Erfahrung von

• Patrick Wolf, langjähriger Oracle Veteran und Senior Solution Architect bei einer Wiener IT Firma, wurde erst kürzlich vom Oracle Magazin zum „Oracle APEX Developer of the year 2007“ ausgezeichnet. Er ist weiterhin ein Oracle ACE und Betreiber des bekannten Blogs Inside Oracle APEX,


• Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, diesjähriger Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und


• Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle Apex, aktiv in den OTN Foren zu Apex und Oracle XE, mit Präsentationen auf den letzten DOAG Veranstaltungen

, um Best Practice Vorgehensweisen aus vielen erfolgreichen APEX Projekten zu lernen.

Neben einer Fülle an Informationen, die wir in vielen erfolgreichen APEX Projekten erarbeitet haben, sind insbesondere die abendlichen Sessions (von 19:00-21:00) als Highlight zu nennen.

Dort stehen wir Ihnen für zusätzliche Hands-On Sessions zur Verfügung, um die Beispiele des Tages durchzuarbeiten oder auch, um konkrete Fragestellungen in Ihren aktuellen Projekten zu diskutieren.

Insgesamt haben wir das Kursprogramm noch etwas aufgeräumt und einige Hands-on Übungen integriert.

Weitere Details zum Kurs sowie die Anmeldung finden Sie hier.

~Dietmar Aust.

Troubleshooting the 404-not found error on 9iOHS

As already posted here and here, you can easily configure the plsql gateway or the dbms_epg to display the oracle errors directly in the browser instead of receiving a http 404 error and searching for the oracle error in the logfiles.

This is a very good solution for development and test environments, but not for any production system due to security implications.

Recently, I wanted to configure an older Oracle Apache (included in the Oracle 9i release of the database).
It uses the older plsql configuration of the wdbsvr.app configuration file.

Here are the instructions on how to configure APEX with that OHS:
http://www.oracle.com/technology/products/database/application_express/howtos/howto_use9ir2ohs.html.

But how do you configure the DAD now to display the error messages directly?

You can use the following syntax for that:

error_style=Gateway
error_style=GatewayDebug
error_style=WebServer

The default is "WebServer".

See the instructions here:

http://download.oracle.com/docs/cd/A97335_02/apps.102/a90099/config.htm#1005872

Regards,
~Dietmar.

Goodbye Carl, we will miss you

Since I have heard about the death of Carl Backstrom, I am still totally shocked. I had the pleasure to meet him personally at OOW 2007 and at ODTUG 2008 in New Orleans this year. We all had a great time and he is a person who will certainly be remembered.

He left a mark on this world! He was very friendly, always helpful and very passionate about his work. And he was very good at it, too.

It really touches me and reminds me at the same time to always live our lives to the fullest!

Carl, we already miss you and wish you the best wherever you are now.

~Dietmar.

Ubiquituous computing - the future

This post is only partly related to APEX - in more general terms.

Back in 1995 I was finishing my computer science degree at the University of Dortmund in Germany. For my Master's thesis I have spent a year at the Graphics Visualization and Usuability Lab (GVU) at the Georgia Institute of Technology in Atlanta / USA.

There I was working on future computing environments (in the FCE group). Especially I worked on the Cyberguide and Classroom 2000 projects.

Also, I was working as a summer intern at the Xerox Palo Alto Research Centre (PARC) in the Silicon Valley. I supported Eric Saund with his ZombieBoard project.

There I had the chance to personally meet Mark Weiser, who did the orginal research in ubiquitous computing environments. Especially his paper "The computer for the 21st century" has become very famous.

This has always been a fascinating topic for me, how computers can support us in our everday tasks in a more subtle way to let us continue to focus on the task at hand and not force us to comply with any sort of "user interface". This way the computer steps out of the way and lets us live in "our world". The tools have to become that intuitive that you wouldn't even notice them anymore.

Today I have come across some very interesting articles / presentations I would like to share with you.

The presentation by Adam Greenfield called "Everyware- The dawning age of ubiquitous computing" has really caught my attention. It is really well presented and entertaining. It also talks a lot about the too often neglected social implications of the technology we create and the responsibility that come with it.

One thing that did strike me during his presentation was our (as designers and developers of user interfaces, e.g. with APEX) assumptions about the users and how they were supposed to interact with the software (from our point of view).

I think I will do more usuability testing of my software in the future. We need to sit down with the key users of our systems more often and actually watch them using the software. We need to understand that the way they "actually" use the software and what is "obvious" for them might be very different from what we expect.

We need to sit down and try to use the software to actually solve their business problems they needed the software for in the first place. This way we can understand what we need to do in order to build a cleaner and more transparent user interface.

Also, I have found this very cool video how the iPhone haptic user interface will change the way we interact with computer dramatically and profoundly.

Even more, the new Songdo city in South Korea (video on youtube) and other engagements in this field demonstrate how our lives and the world we live in will change dramatically.

Regards,
~Dietmar.

Database modeling support in SQL Developer

There is an updated statement of direction for Oracle SQL Developer availble at OTN.

Finally there will be support for data modeling using graphical tools:

• Design of logical Entity Relationship Diagrams
• Design of physical schemas
• Reverse engineering of existing schemas
• Import of existing models from Designer and CA Erwin
• Support for objectrelational types and new 11g features

It took Oracle really a long time to decide on a replacement for Oracle Designer (with regards to data modeling, design capture and change propagation).

Finally it is here. Really looking forward to it. It will be available as an optional plugin for SQL Developer.

Regards,
~Dietmar.

My presentation at ODTUG Kaleidoscope 2008

Two weeks ago I attended the ODTUG Kaleidoscope 2008 conference in New Orleans. This was a great event.

The view from my hotel room was truly awesome:


On Saturday I did have some time to hang out with Patrick Wolf in the French Quarter for breakfast:


On the first (pre conference) day, there was an APEX symposium held. The focus was on customer success stories showing off successful real world implementations of APEX projects to add even more "street" credibility to APEX.

It was very interesting to hear about the different projects.

My presentation was about the successful implementation of two projects at the German Telecom Shops. My main struggle there has been the very tight deadlines (only a few weeks) in which I had to deliver the applications.

(Scott Spendolini and me)

(giving the presentation)

(answering questions)

I am very happy that my presentation was well received. You can download the presentation here.

Also, it was the first time for me to record my online demo and show the video during my presentation. This way I could pause the demo and explain more details where necessary. Also I wouldn't have to switch between screens so often to copy/paste information for the demo. Sometimes this makes a presentation a bit hard to follow. The tool I used for that was the Camtasia Studio by Techsmith. I am very pleased with the produced results.

I really enjoyed hanging out with the APEX development team and meeting really nice folks I know from the Oracle APEX forum.

Regards,
~Dietmar.

APEX Advanced Training held in Munich

It is a little bit late, but I still wanted to share the photos from our last Advanced APEX Training held in Munich on 02.06.2008-04.06.2008.

Once again, (Denes Kubicek, Patrick Wolf and me) held another APEX Advanced Training in Munich.


Although the class wasn't as packed as the previous one, it was again very successful and the participants enjoyed the training, judging by their feedback. And we truly enjoyed it, too.


The class covered the complete life cycle of an APEX project, starting with the analysis and planning, design, indepth coverage of the implementation, PDF reporting alternatives, forms, reports, tabular forms, AJAX, Javascript and ended with the deployment, change propagation and administration.

We also covered the ApexLib framework and other extensions as well as our favourite tools we work with. It was the essence of all the lessons we have learned in our previous projects delivering successful and scalable APEX solutions.

We were especially happy to have Marc Sewtz from Oracle join us with two presentations. He is one of the managers responsible for the development of Oracle Application Express (APEX).

(in the picture you see Patrick, Denes, Dietmar and Marc from left to right)

He was talking about Oracle SQL Developer, also showing the integration with APEX: deployment, browsing the data dictionary information of the applications and also how to debug an APEX application.

Futhermore he was giving us some insight about the possible new features of the next APEX release, targeted for 2009. There is no definite feature list at this time.

Many of the packaged applications will become multi-tenant capable.

Websheets will become one of the major features for the next release. Based on the interactive reports (part of the 3.1 release) it will be possible to edit and share the information.

Forms Migration will be another hot topic for the next release.

The APEX framework will be opened up further, giving us a documented PLSQL API and custom item types.

There will be declarative client side validations using AJAX, cascading AJAX select lists, better error handling, more native authentication schemes (NTLM, OpenID, LDAP/SSL) and finally a new DHTML tree component as well as a new DHTML calendar popup for date fields.

Regards,
~Dietmar.

Troubleshooting the 404-not found error on XE

A few weeks ago, Patrick Wolf, Denes Kubicek and me held an advanced APEX training in Bensheim.

After the training, I helped someone from the class troubleshoot an APEX issue. He received a 404 error sporadically.

How do you find the database error which caused the Apache to show the 404-error?

Usually the error is found in the Apache error log. But you can also configure the mod_plsql to show more detailed information in the browser. This is very useful but should only used in development environments due to security reasons. Patrick wrote a nice blog posting about it.

But using Oracle Express Edition (XE) you don't have an Apache / mod_plsql configuration.
How do you find the errors here?

Since Oracle XE uses the http listener of the XMLDB, it needs to be configured through the DBMS_EPG interface. The documentation can be found here.

To see the error log similar to Apache, logon as SYSTEM via SQL*Plus and execute:

SQL>execute dbms_epg.set_global_attribute('log-level', 3);

The error log will go to the database trace file app/oracle/admin/XE/bdump/xe_s00?_????.trc.
Please ignore the bogus error message "Embedded PL/SQL Gateway: Unknown attribute 3" in the error log.

The log levels are:

0 - LOG_EMERG
1 - LOG_ALERT
2 - LOG_CRIT
3 - LOG_ERR
4 - LOG_WARNING
5 - LOG_NOTICE
6 - LOG_INFO
7 - LOG_DEBUG

To turn off the error logging, execute the following as SYSTEM:

SQL>execute dbms_epg.set_global_attribute('log-level', 0);

In order to show the error messages in the browser, you would configure parameter error-style using the DBMS_EPG.

Almost all parameters of the mod_plsql are configurable in the DBMS_EPG, too. They are just named differently (why?). You can find the mapping in the Oracle documentation.

So, how can we enable the debug style messages in XE. It is easy, just connect as SYSTEM to the database and issue the following command:

SQL>exec dbms_epg.set_dad_attribute('APEX', 'error-style', 'DebugStyle');

In order to revert to the standard message format, issue:

SQL>exec dbms_epg.delete_dad_attribute('APEX', 'error-style');

Then your browser will show the following error message instead of the standard 404-error page:


That's it.

Now I have shown how to configure the DAD for XE, but how can you see the current configuration? My next post will cover these instructions.

Regards,
~Dietmar.

APEX Advanced Training in Munich (02.06.2008 - 04.06.2008)

After the successful first training event in March we (Denes Kubicek, Patrick Wolf and Dietmar Aust) are happy to announce the second APEX Advanced Training in Munich. The class three day training (02.06.2008 - 04.06.2008) will be held in the Arabella Sheraton Westpark Hotel.

More detailed information follows in German:

Wir freuen uns, folgende Oracle Application Express (APEX) Schulung für Fortgeschrittene bekanntgeben zu können:

Oracle APEX: Fortgeschrittene Techniken aus der Praxis

Nutzen Sie das Wissen und die Erfahrung von

• Patrick Wolf, langjähriger Oracle Veteran und Senior Solution Architect bei einer Wiener IT Firma, wurde erst kürzlich vom Oracle Magazin zum „Oracle APEX Developer of the year 2007“ ausgezeichnet. Er ist weiterhin ein Oracle ACE und Betreiber des bekannten Blogs Inside Oracle APEX
  


• Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle Apex, aktiv in den OTN Foren zu Apex und Oracle XE, mit Präsentationen auf den letzten DOAG Veranstaltungen,


• Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und ApEx mit multisite Applikationen und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und

, um fortgeschrittene Techniken und Best Practice Vorgehensweisen aus vielen erfolgreichen Apex Projekten zu lernen.

Neben einer Fülle an Informationen, die wir in vielen erfolgreichen APEX Projekten erarbeitet haben, sind insbesondere die abendlichen Sessions (von 19:00-21:00) als Highlight zu nennen.

Dort stehen wir Ihnen für zusätzliche Hands-On Sessions zur Verfügung, um die Beispiele des Tages durchzuarbeiten oder auch, um konkrete Fragestellungen in Ihren aktuellen Projekten zu diskutieren.

Weitere Details zum Kurs sowie die Anmeldung finden Sie hier.

~Dietmar.

APEX Advanced Training in Germany - a success!

We (Denes Kubicek, Patrick Wolf and Dietmar Aust) finally held our first APEX Advanced Training in Germany.

The class was quickly booked out having 30 participants. It was a true success judging by the feedback from the participants. And we truly enjoyed it, too.


The class covered the complete life cycle of an APEX project, starting with the analysis and planning, design, indepth coverage of the implementation, PDF reporting alternatives, forms, reports, tabular forms, AJAX, Javascript and ended with the deployment, change propagation and administration.

We also covered the ApexLib framework and other extensions as well as our favourite tools we work with. It was the essence of all the lessons we have learned in our previous projects delivering successful and scalable APEX solutions.


During the evenings we joined the group for another hands-on session from 7-9 pm. They were given the opportunity to discuss the samples of the class as well as their problems in their current projects. This opportunity and the extensive sample application was perceived as a big plus of the class.

We were especially happy to have Carsten Czarski from Oracle join us with a presentation. He was talking about the various possibilities to leverage the Oracle database features in APEX applications, i.e. XML, web services, Oracle Text and Analytic Functions. He also talked about the current release 3.1 of APEX as well as the upcoming features in 4.0.

We will shortly announce the next training which will be held in June in Munich.

Regards,
~Dietmar.

APEX 3.1 released!

Finally, the much anticipated release of APEX 3.1 has hit the streets!

You can download it here.

Make sure to check out the new features list and the sample application showcasing the new features.

Also, there are three more Oracle by Examples tutorials specific to release 3.1.

Enjoy!
~Dietmar.

APEX 3.1 is coming closer ...

The release date of Oracle APEX 3.1 seems to be coming closer :). The hosted online version on apex.oracle.com has been upgraded yesterday.

I presume they will just fix some minor bugs and resolve some performance issues, then it should be ready for prime time !!!

Many interesting features are coming along, see

• the new features list
• a sample application showcasing the new features
• Patrick's blog posts about some not so obvious interesting features
• undocumented features
• more undocumented features
  

Greetinx,
~Dietmar.

Customer success story at ODTUG Kaleidoscope 2008

I will be presenting two customer success stories at the ODTUG Kaleidoscope 2008 in New Orleans this year. This is about the work I have done for the German Telecom Shops (T-Punkt Vertriebsgesellschaft mbH). This presentation is not so much about the technical details but more about the business related stuff.

Why ist this application important for the customer? What were the greatest benefits? Why was APEX chosen as a technology. How did this technology perform compared to the usual suspects ;) ?

Thanks to Scott Spendolini, he invited me to give this presentation. Hope to finally meet him there.

And I do look forward to meet up again with all the APEX developers and enthusiasts around the world, like Joel Kallman, Patrick Wolf, Carl Backstrom, Dimitri Gielis, John Scott (this time spelled correctly ;), David Peake, ... and meet some new ones, too.

It will be real fun to come back to New Orleans. I have been there in 1996 for mardi gras, it was a pure blast !!! I wonder how things have changed since Katrina.

Hope to see you there,
~Dietmar.

Gathering Apex Installation Requirements

Did you ever wonder how to determine the installation requirements for Apex?

Which steps are really neccessary? Is the JavaVM installed? What about XML DB? What about Oracle Text? How can you find out?

And even more, what if you don't have access to a DBA account on the target instance? What information needs to be gathered by the DBA?

I have created a simple script to gather all relevant information.

Comments are welcome!

In another post I might explore a way to programmatically analyze the outcome and determine the exact steps to be taken.

Here is the script:

/*
 * Check installation requirements for Oracle Application Express 3.0.1
 *
 * http://download-uk.oracle.com/docs/cd/B32472_01/doc/install.300/b32468/overview.htm
 * 
 * Version  Date        Author            Comment
 * #####################################################################
 * 0.5.0    22.01.2008  D. Aust           initial creation
 * 
 */

SET serveroutput on
set linesize 200
set pagesize 10000
set trimspool on
SPOOL oracle_info.lst

PROMPT ***
PROMPT *** database version must be >= 9.2.0.3
PROMPT ***

DECLARE
   l_version         VARCHAR2 (100);
   l_compatibility   VARCHAR2 (100);
BEGIN
   DBMS_UTILITY.db_version (VERSION            => l_version,
                            COMPATIBILITY      => l_compatibility
                           );
   DBMS_OUTPUT.put_line (   'Version: '
                         || l_version
                         || '  Compatibility: '
                         || l_compatibility
                        );
END;
/

PROMPT ***
PROMPT *** v$version
PROMPT ***
column banner format A100;
SELECT banner
  FROM v$version;

PROMPT ***
PROMPT *** installed components
PROMPT ***
column comp_id format A15;
column comp_name format A40;
column version format A15;
column status format A10;
column schema format A15;
SELECT comp_id, comp_name, VERSION, status, SCHEMA
  FROM dba_registry;

PROMPT ***
PROMPT *** installed options
PROMPT ***
column parameter format A50;
column value format A10;
SELECT parameter, value
  FROM v$option;

PROMPT ***
PROMPT *** parameters
PROMPT ***
COLUMN name format A30;
COLUMN value format A40;
COLUMN isdefault format A10;
COLUMN ismodified format A10;
COLUMN isadjusted format A10;
COLUMN description format A80;
SELECT   NAME, VALUE, isdefault, ismodified, isadjusted, description
    FROM v$parameter
ORDER BY NAME;


PROMPT ***
PROMPT *** tablespaces
PROMPT ***
COLUMN name format A30;
COLUMN value format A40;
select  TABLESPACE_NAME,
 round(sum(BYTES) / 1024 / 1024, 2) Total_free_space_MB,
    round(max(BYTES) / 1024 / 1024, 2) largest_free_extent_MB
from  dba_free_space
group  by TABLESPACE_NAME
order   by tablespace_name;

PROMPT ***
PROMPT *** version of the owa_toolkit, must be >= 10.1.2.0.6
PROMPT ***
select owa_util.get_version OWA_VERSION from dual;

PROMPT ***
PROMPT *** NLS database parameters
PROMPT ***
select * from nls_database_parameters;

PROMPT ***
PROMPT *** NLS session parameters;
PROMPT ***
select * from nls_session_parameters;

PROMPT ***
PROMPT *** 
PROMPT ***
COLUMN param format A20;
COLUMN value format A60;
SELECT 'SESSION_USER' param, SYS_CONTEXT ('USERENV', 'SESSION_USER') value FROM DUAL
union all
SELECT 'CURRENT_SCHEMA' param, SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') value FROM DUAL
union all
SELECT 'DB_DOMAIN' param, SYS_CONTEXT ('USERENV', 'DB_DOMAIN') value  FROM DUAL
union all
SELECT 'DB_NAME' param, SYS_CONTEXT ('USERENV', 'DB_NAME')  value FROM DUAL
union all
SELECT 'DB_UNIQUE_NAME' param, SYS_CONTEXT ('USERENV', 'DB_UNIQUE_NAME')  value FROM DUAL
union all
--SELECT 'IP_ADDRESS' param, SYS_CONTEXT ('USERENV', 'IP_ADDRESS')  value FROM DUAL
--union all
--SELECT 'HOST' param, SYS_CONTEXT ('USERENV', 'HOST')  value FROM DUAL
--union all
SELECT 'SERVICE_NAME' param, SYS_CONTEXT ('USERENV', 'SERVICE_NAME') value  FROM DUAL
union all
SELECT 'SERVER_HOST' param, SYS_CONTEXT ('USERENV', 'SERVER_HOST') value  FROM DUAL
union all
SELECT 'SERVER_HOST_NAME' param, UTL_INADDR.get_host_name value FROM dual
union all
SELECT 'SERVER_ADDRESS' param, UTL_INADDR.get_host_address value from dual;
--union all
--SELECT 'TERMINAL' param, SYS_CONTEXT ('USERENV', 'TERMINAL') value  FROM DUAL;
   
   
spool off; 

--host start oracle_info.lst

exit

Run the script as SYS, SYSTEM or any other DBA or a normal user having SELECT_CATALOG_ROLE privileges.

It will generate a file called oracle_info.lst.

Here is a sample output:

***
*** database version must be >= 9.2.0.3
***
Version: 10.2.0.1.0  Compatibility: 10.2.0.1.0

PL/SQL-Prozedur erfolgreich abgeschlossen.

***
*** v$version
***

BANNER
----------------------------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

***
*** installed components
***

COMP_ID         COMP_NAME                                VERSION         STATUS     SCHEMA
--------------- ---------------------------------------- --------------- ---------- ---------------
APEX            Oracle Application Express               2.2.0.00.32     VALID      FLOWS_020200
EM              Oracle Enterprise Manager                10.2.0.1.0      VALID      SYSMAN
SDO             Spatial                                  10.2.0.1.0      VALID      MDSYS
ORDIM           Oracle interMedia                        10.2.0.1.0      VALID      ORDSYS
AMD             OLAP Catalog                             10.2.0.1.0      VALID      OLAPSYS
XDB             Oracle XML Database                      10.2.0.1.0      VALID      XDB
CONTEXT         Oracle Text                              10.2.0.1.0      VALID      CTXSYS
EXF             Oracle Expression Filter                 10.2.0.1.0      VALID      EXFSYS
RUL             Oracle Rules Manager                     10.2.0.1.0      VALID      EXFSYS
OWM             Oracle Workspace Manager                 10.2.0.1.0      VALID      WMSYS
ODM             Oracle Data Mining                       10.2.0.1.0      VALID      DMSYS
CATALOG         Oracle Database Catalog Views            10.2.0.1.0      VALID      SYS
CATPROC         Oracle Database Packages and Types       10.2.0.1.0      VALID      SYS
JAVAVM          JServer JAVA Virtual Machine             10.2.0.1.0      VALID      SYS
XML             Oracle XDK                               10.2.0.1.0      VALID      SYS
CATJAVA         Oracle Database Java Packages            10.2.0.1.0      VALID      SYS
APS             OLAP Analytic Workspace                  10.2.0.1.0      VALID      SYS
XOQ             Oracle OLAP API                          10.2.0.1.0      VALID      SYS

18 Zeilen ausgewählt.

***
*** installed options
***

PARAMETER                                          VALUE
-------------------------------------------------- ----------
Partitioning                                       TRUE
Objects                                            TRUE
Real Application Clusters                          FALSE
Advanced replication                               TRUE
Bit-mapped indexes                                 TRUE
Connection multiplexing                            TRUE
Connection pooling                                 TRUE
Database queuing                                   TRUE
Incremental backup and recovery                    TRUE
Instead-of triggers                                TRUE
Parallel backup and recovery                       TRUE
Parallel execution                                 TRUE
Parallel load                                      TRUE
Point-in-time tablespace recovery                  TRUE
Fine-grained access control                        TRUE
Proxy authentication/authorization                 TRUE
Change Data Capture                                TRUE
Plan Stability                                     TRUE
Online Index Build                                 TRUE
Coalesce Index                                     TRUE
Managed Standby                                    TRUE
Materialized view rewrite                          TRUE
Materialized view warehouse refresh                TRUE
Database resource manager                          TRUE
Spatial                                            TRUE
Visual Information Retrieval                       TRUE
Export transportable tablespaces                   TRUE
Transparent Application Failover                   TRUE
Fast-Start Fault Recovery                          TRUE
Sample Scan                                        TRUE
Duplexed backups                                   TRUE
Java                                               TRUE
OLAP Window Functions                              TRUE
Block Media Recovery                               TRUE
Fine-grained Auditing                              TRUE
Application Role                                   TRUE
Enterprise User Security                           TRUE
Oracle Data Guard                                  TRUE
Oracle Label Security                              FALSE
OLAP                                               TRUE
Table compression                                  TRUE
Join index                                         TRUE
Trial Recovery                                     TRUE
Data Mining                                        TRUE
Online Redefinition                                TRUE
Streams Capture                                    TRUE
File Mapping                                       TRUE
Block Change Tracking                              TRUE
Flashback Table                                    TRUE
Flashback Database                                 TRUE
Data Mining Scoring Engine                         FALSE
Transparent Data Encryption                        TRUE
Backup Encryption                                  TRUE
Unused Block Compression                           TRUE

54 Zeilen ausgewählt.

***
*** parameters
***

NAME                           VALUE                                    ISDEFAULT  ISMODIFIED ISADJUSTED DESCRIPTION
------------------------------ ---------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
active_instance_count                                                   TRUE       FALSE      FALSE      number of active instances in the cluster database
aq_tm_processes                0                                        TRUE       FALSE      FALSE      number of AQ Time Managers to start
archive_lag_target             0                                        TRUE       FALSE      FALSE      Maximum number of seconds of redos the standby could lose
asm_diskgroups                                                          TRUE       FALSE      FALSE      disk groups to mount automatically
asm_diskstring                                                          TRUE       FALSE      FALSE      disk set locations for discovery
asm_power_limit                1                                        TRUE       FALSE      FALSE      number of processes for disk rebalancing
audit_file_dest                D:\ORACLE\PRODUCT\ADMIN\ODS\ADUMP        FALSE      FALSE      FALSE      Directory in which auditing files are to reside
audit_sys_operations           FALSE                                    TRUE       FALSE      FALSE      enable sys auditing
audit_trail                    NONE                                     TRUE       FALSE      FALSE      enable system auditing
background_core_dump           partial                                  TRUE       FALSE      FALSE      Core Size for Background Processes
background_dump_dest           D:\ORACLE\PRODUCT\ADMIN\ODS\BDUMP        FALSE      FALSE      FALSE      Detached process dump directory
backup_tape_io_slaves          FALSE                                    TRUE       FALSE      FALSE      BACKUP Tape I/O slaves
bitmap_merge_area_size         1048576                                  TRUE       FALSE      FALSE      maximum memory allow for BITMAP MERGE
blank_trimming                 FALSE                                    TRUE       FALSE      FALSE      blank trimming semantics parameter
buffer_pool_keep                                                        TRUE       FALSE      FALSE      Number of database blocks/latches in keep buffer pool
buffer_pool_recycle                                                     TRUE       FALSE      FALSE      Number of database blocks/latches in recycle buffer pool
circuits                                                                TRUE       FALSE      FALSE      max number of circuits
cluster_database               FALSE                                    TRUE       FALSE      FALSE      if TRUE startup in cluster database mode
cluster_database_instances     1                                        TRUE       FALSE      FALSE      number of instances to use for sizing cluster db SGA structures
cluster_interconnects                                                   TRUE       FALSE      FALSE      interconnects for RAC use
commit_point_strength          1                                        TRUE       FALSE      FALSE      Bias this node has toward not preparing in a two-phase commit
commit_write                                                            TRUE       FALSE      FALSE      transaction commit log write behaviour
compatible                     10.2.0.1.0                               FALSE      FALSE      FALSE      Database will be completely compatible with this software version
control_file_record_keep_time  7                                        TRUE       FALSE      FALSE      control file record keep time in days
control_files                  D:\ORACLE\ORADATA\ODS\CONTROL01.CTL, D:\ FALSE      FALSE      FALSE      control file names list
                               ORACLE\ORADATA\ODS\CONTROL02.CTL, D:\ORA
                               CLE\ORADATA\ODS\CONTROL03.CTL

core_dump_dest                 D:\ORACLE\PRODUCT\ADMIN\ODS\CDUMP        FALSE      FALSE      FALSE      Core dump directory
cpu_count                      2                                        TRUE       FALSE      FALSE      number of CPUs for this instance
create_bitmap_area_size        8388608                                  TRUE       FALSE      FALSE      size of create bitmap buffer for bitmap index
create_stored_outlines                                                  TRUE       FALSE      FALSE      create stored outlines for DML statements
cursor_sharing                 EXACT                                    TRUE       FALSE      FALSE      cursor sharing mode
cursor_space_for_time          FALSE                                    TRUE       FALSE      FALSE      use more memory in order to get faster execution
db_block_buffers               0                                        TRUE       FALSE      FALSE      Number of database blocks cached in memory
db_block_checking              FALSE                                    TRUE       FALSE      FALSE      header checking and data and index block checking
db_block_checksum              TRUE                                     TRUE       FALSE      FALSE      store checksum in db blocks and check during reads
db_block_size                  8192                                     FALSE      FALSE      FALSE      Size of database block in bytes
db_cache_advice                ON                                       TRUE       FALSE      FALSE      Buffer cache sizing advisory
db_cache_size                  0                                        TRUE       FALSE      FALSE      Size of DEFAULT buffer pool for standard block size buffers
db_create_file_dest                                                     TRUE       FALSE      FALSE      default database location
db_create_online_log_dest_1                                             TRUE       FALSE      FALSE      online log/controlfile destination #1
db_create_online_log_dest_2                                             TRUE       FALSE      FALSE      online log/controlfile destination #2
db_create_online_log_dest_3                                             TRUE       FALSE      FALSE      online log/controlfile destination #3
db_create_online_log_dest_4                                             TRUE       FALSE      FALSE      online log/controlfile destination #4
db_create_online_log_dest_5                                             TRUE       FALSE      FALSE      online log/controlfile  destination #5
db_domain                                                               FALSE      FALSE      FALSE      directory part of global database name stored with CREATE DATABASE
db_file_multiblock_read_count  16                                       FALSE      FALSE      FALSE      db block to be read each IO
db_file_name_convert                                                    TRUE       FALSE      FALSE      datafile name convert patterns and strings for standby/clone db
db_files                       200                                      TRUE       FALSE      FALSE      max allowable # db files
db_flashback_retention_target  1440                                     TRUE       FALSE      FALSE      Maximum Flashback Database log retention time in minutes.
db_keep_cache_size             0                                        TRUE       FALSE      FALSE      Size of KEEP buffer pool for standard block size buffers
db_name                        ODS                                      FALSE      FALSE      FALSE      database name specified in CREATE DATABASE
db_recovery_file_dest          D:\oracle\product/flash_recovery_area    FALSE      FALSE      FALSE      default database recovery file location
db_recovery_file_dest_size     2147483648                               FALSE      FALSE      FALSE      database recovery files size limit
db_recycle_cache_size          0                                        TRUE       FALSE      FALSE      Size of RECYCLE buffer pool for standard block size buffers
db_unique_name                 ODS                                      TRUE       FALSE      FALSE      Database Unique Name
dbwr_io_slaves                 0                                        TRUE       FALSE      FALSE      DBWR I/O slaves
db_writer_processes            1                                        TRUE       FALSE      FALSE      number of background database writer  processes to start
db_16k_cache_size              0                                        TRUE       FALSE      FALSE      Size of cache for 16K buffers
db_2k_cache_size               0                                        TRUE       FALSE      FALSE      Size of cache for 2K buffers
db_32k_cache_size              0                                        TRUE       FALSE      FALSE      Size of cache for 32K buffers
db_4k_cache_size               0                                        TRUE       FALSE      FALSE      Size of cache for 4K buffers
db_8k_cache_size               0                                        TRUE       FALSE      FALSE      Size of cache for 8K buffers
ddl_wait_for_locks             FALSE                                    TRUE       FALSE      FALSE      Disable NOWAIT DML lock acquisitions
dg_broker_config_file1         D:\ORACLE\PRODUCT\10.2.0\DATABASE\DR1ODS TRUE       FALSE      FALSE      data guard broker configuration file #1
                               .DAT

dg_broker_config_file2         D:\ORACLE\PRODUCT\10.2.0\DATABASE\DR2ODS TRUE       FALSE      FALSE      data guard broker configuration file #2
                               .DAT

dg_broker_start                FALSE                                    TRUE       FALSE      FALSE      start Data Guard broker framework (DMON process)
disk_asynch_io                 TRUE                                     TRUE       FALSE      FALSE      Use asynch I/O for random access devices
dispatchers                    (PROTOCOL=TCP) (SERVICE=ODSXDB)          FALSE      FALSE      FALSE      specifications of dispatchers
distributed_lock_timeout       60                                       TRUE       FALSE      FALSE      number of seconds a distributed transaction waits for a lock
dml_locks                      748                                      TRUE       FALSE      FALSE      dml locks - one for each table modified in a transaction
drs_start                      FALSE                                    TRUE       FALSE      FALSE      start DG Broker monitor (DMON process)
event                                                                   TRUE       FALSE      FALSE      debug event control - default null string
fal_client                                                              TRUE       FALSE      FALSE      FAL client
fal_server                                                              TRUE       FALSE      FALSE      FAL server list
fast_start_io_target           0                                        TRUE       FALSE      FALSE      Upper bound on recovery reads
fast_start_mttr_target         0                                        TRUE       FALSE      FALSE      MTTR target of forward crash recovery in seconds
fast_start_parallel_rollback   LOW                                      TRUE       FALSE      FALSE      max number of parallel recovery slaves that may be used
fileio_network_adapters                                                 TRUE       FALSE      FALSE      Network Adapters for File I/O
file_mapping                   FALSE                                    TRUE       FALSE      FALSE      enable file mapping
filesystemio_options                                                    TRUE       FALSE      FALSE      IO operations on filesystem files
fixed_date                     NONE                                     FALSE      FALSE      FALSE      fixed SYSDATE value
gc_files_to_locks                                                       TRUE       FALSE      FALSE      mapping between file numbers and global cache locks
gcs_server_processes           0                                        TRUE       FALSE      FALSE      number of background gcs server processes to start
global_context_pool_size                                                TRUE       FALSE      FALSE      Global Application Context Pool Size in Bytes
global_names                   FALSE                                    TRUE       FALSE      FALSE      enforce that database links have same name as remote database
hash_area_size                 131072                                   TRUE       FALSE      FALSE      size of in-memory hash work area
hi_shared_memory_address       0                                        TRUE       FALSE      FALSE      SGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregister                TRUE                                     TRUE       FALSE      FALSE      enable automatic server DD updates in HS agent self-registration
ifile                                                                   TRUE       FALSE      FALSE      include file in init.ora
instance_groups                                                         TRUE       FALSE      FALSE      list of instance group names
instance_name                  ods                                      TRUE       FALSE      FALSE      instance name supported by the instance
instance_number                0                                        TRUE       FALSE      FALSE      instance number
instance_type                  RDBMS                                    TRUE       FALSE      FALSE      type of instance to be executed
java_max_sessionspace_size     0                                        TRUE       FALSE      FALSE      max allowed size in bytes of a Java sessionspace
java_pool_size                 0                                        TRUE       FALSE      FALSE      size in bytes of java pool
java_soft_sessionspace_limit   0                                        TRUE       FALSE      FALSE      warning limit on size in bytes of a Java sessionspace
job_queue_processes            10                                       FALSE      FALSE      FALSE      number of job queue slave processes
large_pool_size                0                                        TRUE       FALSE      FALSE      size in bytes of large pool
ldap_directory_access          NONE                                     TRUE       FALSE      FALSE      RDBMS's LDAP access option
license_max_sessions           0                                        TRUE       FALSE      FALSE      maximum number of non-system user sessions allowed
license_max_users              0                                        TRUE       FALSE      FALSE      maximum number of named users that can be created in the database
license_sessions_warning       0                                        TRUE       FALSE      FALSE      warning level for number of non-system user sessions
local_listener                 LISTENER_ODS                             FALSE      FALSE      FALSE      local listener
lock_name_space                                                         TRUE       FALSE      FALSE      lock name space used for generating lock names for standby/clone database
lock_sga                       FALSE                                    TRUE       FALSE      FALSE      Lock entire SGA in physical memory
log_archive_config                                                      TRUE       FALSE      FALSE      log archive config parameter
log_archive_dest                                                        TRUE       FALSE      FALSE      archival destination text string
log_archive_dest_state_1       enable                                   TRUE       FALSE      FALSE      archival destination #1 state text string
log_archive_dest_state_10      enable                                   TRUE       FALSE      FALSE      archival destination #10 state text string
log_archive_dest_state_2       enable                                   TRUE       FALSE      FALSE      archival destination #2 state text string
log_archive_dest_state_3       enable                                   TRUE       FALSE      FALSE      archival destination #3 state text string
log_archive_dest_state_4       enable                                   TRUE       FALSE      FALSE      archival destination #4 state text string
log_archive_dest_state_5       enable                                   TRUE       FALSE      FALSE      archival destination #5 state text string
log_archive_dest_state_6       enable                                   TRUE       FALSE      FALSE      archival destination #6 state text string
log_archive_dest_state_7       enable                                   TRUE       FALSE      FALSE      archival destination #7 state text string
log_archive_dest_state_8       enable                                   TRUE       FALSE      FALSE      archival destination #8 state text string
log_archive_dest_state_9       enable                                   TRUE       FALSE      FALSE      archival destination #9 state text string
log_archive_dest_1                                                      TRUE       FALSE      FALSE      archival destination #1 text string
log_archive_dest_10                                                     TRUE       FALSE      FALSE      archival destination #10 text string
log_archive_dest_2                                                      TRUE       FALSE      FALSE      archival destination #2 text string
log_archive_dest_3                                                      TRUE       FALSE      FALSE      archival destination #3 text string
log_archive_dest_4                                                      TRUE       FALSE      FALSE      archival destination #4 text string
log_archive_dest_5                                                      TRUE       FALSE      FALSE      archival destination #5 text string
log_archive_dest_6                                                      TRUE       FALSE      FALSE      archival destination #6 text string
log_archive_dest_7                                                      TRUE       FALSE      FALSE      archival destination #7 text string
log_archive_dest_8                                                      TRUE       FALSE      FALSE      archival destination #8 text string
log_archive_dest_9                                                      TRUE       FALSE      FALSE      archival destination #9 text string
log_archive_duplex_dest                                                 TRUE       FALSE      FALSE      duplex archival destination text string
log_archive_format             ARC%S_%R.%T                              TRUE       FALSE      FALSE      archival destination format
log_archive_local_first        TRUE                                     TRUE       FALSE      FALSE      Establish EXPEDITE attribute default value
log_archive_max_processes      2                                        TRUE       FALSE      FALSE      maximum number of active ARCH processes
log_archive_min_succeed_dest   1                                        TRUE       FALSE      FALSE      minimum number of archive destinations that must succeed
log_archive_start              FALSE                                    TRUE       FALSE      FALSE      start archival process on SGA initialization
log_archive_trace              0                                        TRUE       FALSE      FALSE      Establish archivelog operation tracing level
log_buffer                     7024640                                  TRUE       FALSE      FALSE      redo circular buffer size
log_checkpoint_interval        0                                        TRUE       FALSE      FALSE      # redo blocks checkpoint threshold
log_checkpoints_to_alert       FALSE                                    TRUE       FALSE      FALSE      log checkpoint begin/end to alert file
log_checkpoint_timeout         1800                                     TRUE       FALSE      FALSE      Maximum time interval between checkpoints in seconds
log_file_name_convert                                                   TRUE       FALSE      FALSE      logfile name convert patterns and strings for standby/clone db
logmnr_max_persistent_sessions 1                                        TRUE       FALSE      FALSE      maximum number of threads to mine
max_commit_propagation_delay   0                                        TRUE       FALSE      FALSE      Max age of new snapshot in .01 seconds
max_dispatchers                                                         TRUE       FALSE      FALSE      max number of dispatchers
max_dump_file_size             UNLIMITED                                TRUE       FALSE      FALSE      Maximum size (blocks) of dump file
max_enabled_roles              150                                      TRUE       FALSE      FALSE      max number of roles a user can have enabled
max_shared_servers                                                      TRUE       FALSE      FALSE      max number of shared servers
nls_calendar                                                            TRUE       FALSE      FALSE      NLS calendar system name
nls_comp                                                                TRUE       FALSE      FALSE      NLS comparison
nls_currency                                                            TRUE       FALSE      FALSE      NLS local currency symbol
nls_date_format                                                         TRUE       FALSE      FALSE      NLS Oracle date format
nls_date_language                                                       TRUE       FALSE      FALSE      NLS date language name
nls_dual_currency                                                       TRUE       FALSE      FALSE      Dual currency symbol
nls_iso_currency                                                        TRUE       FALSE      FALSE      NLS ISO currency territory name
nls_language                   AMERICAN                                 TRUE       FALSE      FALSE      NLS language name
nls_length_semantics           BYTE                                     TRUE       FALSE      FALSE      create columns using byte or char semantics by default
nls_nchar_conv_excp            FALSE                                    TRUE       FALSE      FALSE      NLS raise an exception instead of allowing implicit conversion
nls_numeric_characters                                                  TRUE       FALSE      FALSE      NLS numeric characters
nls_sort                                                                TRUE       FALSE      FALSE      NLS linguistic definition name
nls_territory                  AMERICA                                  TRUE       FALSE      FALSE      NLS territory name
nls_time_format                                                         TRUE       FALSE      FALSE      time format
nls_timestamp_format                                                    TRUE       FALSE      FALSE      time stamp format
nls_timestamp_tz_format                                                 TRUE       FALSE      FALSE      timestampe with timezone format
nls_time_tz_format                                                      TRUE       FALSE      FALSE      time with timezone format
object_cache_max_size_percent  10                                       TRUE       FALSE      FALSE      percentage of maximum size over optimal of the user session's object cache
object_cache_optimal_size      102400                                   TRUE       FALSE      FALSE      optimal size of the user session's object cache in bytes
olap_page_pool_size            0                                        TRUE       FALSE      FALSE      size of the olap page pool in bytes
open_cursors                   300                                      FALSE      FALSE      FALSE      max # cursors per session
open_links                     4                                        TRUE       FALSE      FALSE      max # open links per session
open_links_per_instance        4                                        TRUE       FALSE      FALSE      max # open links per instance
optimizer_dynamic_sampling     2                                        TRUE       FALSE      FALSE      optimizer dynamic sampling
optimizer_features_enable      10.2.0.1                                 TRUE       FALSE      FALSE      optimizer plan compatibility parameter
optimizer_index_caching        0                                        TRUE       FALSE      FALSE      optimizer percent index caching
optimizer_index_cost_adj       100                                      TRUE       FALSE      FALSE      optimizer index cost adjustment
optimizer_mode                 ALL_ROWS                                 TRUE       FALSE      FALSE      optimizer mode
optimizer_secure_view_merging  TRUE                                     TRUE       FALSE      FALSE      optimizer secure view merging and predicate pushdown/movearound
os_authent_prefix              OPS$                                     TRUE       FALSE      FALSE      prefix for auto-logon accounts
os_roles                       FALSE                                    TRUE       FALSE      FALSE      retrieve roles from the operating system
O7_DICTIONARY_ACCESSIBILITY    FALSE                                    TRUE       FALSE      FALSE      Version 7 Dictionary Accessibility Support
parallel_adaptive_multi_user   TRUE                                     TRUE       FALSE      FALSE      enable adaptive setting of degree for multiple user streams
parallel_automatic_tuning      FALSE                                    TRUE       FALSE      FALSE      enable intelligent defaults for parallel execution parameters
parallel_execution_message_siz 2148                                     TRUE       FALSE      FALSE      message buffer size for parallel execution
e

parallel_instance_group                                                 TRUE       FALSE      FALSE      instance group to use for all parallel operations
parallel_max_servers           40                                       TRUE       FALSE      FALSE      maximum parallel query servers per instance
parallel_min_percent           0                                        TRUE       FALSE      FALSE      minimum percent of threads required for parallel query
parallel_min_servers           0                                        TRUE       FALSE      FALSE      minimum parallel query servers per instance
parallel_server                FALSE                                    TRUE       FALSE      FALSE      if TRUE startup in parallel server mode
parallel_server_instances      1                                        TRUE       FALSE      FALSE      number of instances to use for sizing OPS SGA structures
parallel_threads_per_cpu       2                                        TRUE       FALSE      FALSE      number of parallel execution threads per CPU
pga_aggregate_target           243269632                                FALSE      FALSE      FALSE      Target size for the aggregate PGA memory consumed by the instance
plsql_ccflags                                                           TRUE       FALSE      FALSE      PL/SQL ccflags
plsql_code_type                INTERPRETED                              TRUE       FALSE      FALSE      PL/SQL code-type
plsql_compiler_flags           INTERPRETED, NON_DEBUG                   TRUE       FALSE      FALSE      PL/SQL compiler flags
plsql_debug                    FALSE                                    TRUE       FALSE      FALSE      PL/SQL debug
plsql_native_library_dir                                                TRUE       FALSE      FALSE      plsql native library dir
plsql_native_library_subdir_co 0                                        TRUE       FALSE      FALSE      plsql native library number of subdirectories
unt

plsql_optimize_level           2                                        TRUE       FALSE      FALSE      PL/SQL optimize level
plsql_v2_compatibility         FALSE                                    TRUE       FALSE      FALSE      PL/SQL version 2.x compatibility flag
plsql_warnings                 DISABLE:ALL                              TRUE       FALSE      FALSE      PL/SQL compiler warnings settings
pre_page_sga                   FALSE                                    TRUE       FALSE      FALSE      pre-page sga for process
processes                      150                                      FALSE      FALSE      FALSE      user processes
query_rewrite_enabled          TRUE                                     TRUE       FALSE      FALSE      allow rewrite of queries using materialized views if enabled
query_rewrite_integrity        enforced                                 TRUE       FALSE      FALSE      perform rewrite using materialized views with desired integrity
rdbms_server_dn                                                         TRUE       FALSE      FALSE      RDBMS's Distinguished Name
read_only_open_delayed         FALSE                                    TRUE       FALSE      FALSE      if TRUE delay opening of read only files until first access
recovery_parallelism           0                                        TRUE       FALSE      FALSE      number of server processes to use for parallel recovery
recyclebin                     on                                       TRUE       FALSE      FALSE      recyclebin processing
remote_archive_enable          true                                     TRUE       FALSE      FALSE      remote archival enable setting
remote_dependencies_mode       TIMESTAMP                                TRUE       FALSE      FALSE      remote-procedure-call dependencies mode parameter
remote_listener                                                         TRUE       FALSE      FALSE      remote listener
remote_login_passwordfile      EXCLUSIVE                                FALSE      FALSE      FALSE      password file usage parameter
remote_os_authent              FALSE                                    TRUE       FALSE      FALSE      allow non-secure remote clients to use auto-logon accounts
remote_os_roles                FALSE                                    TRUE       FALSE      FALSE      allow non-secure remote clients to use os roles
replication_dependency_trackin TRUE                                     TRUE       FALSE      FALSE      tracking dependency for Replication parallel propagation
g

resource_limit                 FALSE                                    TRUE       FALSE      FALSE      master switch for resource limit
resource_manager_plan                                                   TRUE       FALSE      FALSE      resource mgr top plan
resumable_timeout              0                                        TRUE       FALSE      FALSE      set resumable_timeout
rollback_segments                                                       TRUE       FALSE      FALSE      undo segment list
serial_reuse                   disable                                  TRUE       FALSE      FALSE      reuse the frame segments
service_names                  ODS                                      TRUE       FALSE      FALSE      service names supported by the instance
session_cached_cursors         20                                       TRUE       FALSE      FALSE      Number of cursors to cache in a session.
session_max_open_files         10                                       TRUE       FALSE      FALSE      maximum number of open files allowed per session
sessions                       170                                      TRUE       FALSE      FALSE      user and system sessions
sga_max_size                   603979776                                FALSE      FALSE      FALSE      max total SGA size
sga_target                     603979776                                FALSE      FALSE      FALSE      Target size of SGA
shadow_core_dump               partial                                  TRUE       FALSE      FALSE      Core Size for Shadow Processes
shared_memory_address          0                                        TRUE       FALSE      FALSE      SGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_size      4823449                                  TRUE       FALSE      FALSE      size in bytes of reserved area of shared pool
shared_pool_size               0                                        TRUE       FALSE      FALSE      size in bytes of shared pool
shared_servers                 1                                        TRUE       FALSE      FALSE      number of shared servers to start up
shared_server_sessions                                                  TRUE       FALSE      FALSE      max number of shared server sessions
skip_unusable_indexes          TRUE                                     TRUE       FALSE      FALSE      skip unusable indexes if set to TRUE
smtp_out_server                                                         TRUE       FALSE      FALSE      utl_smtp server and port configuration parameter
sort_area_retained_size        0                                        TRUE       FALSE      FALSE      size of in-memory sort work area retained between fetch calls
sort_area_size                 65536                                    TRUE       FALSE      FALSE      size of in-memory sort work area
spfile                         D:\ORACLE\PRODUCT\10.2.0\DBS\SPFILEODS.O FALSE      FALSE      FALSE      server parameter file
                               RA

sql_trace                      FALSE                                    TRUE       FALSE      FALSE      enable SQL trace
sqltune_category               DEFAULT                                  TRUE       FALSE      FALSE      Category qualifier for applying hintsets
sql_version                    NATIVE                                   TRUE       FALSE      FALSE      sql language version parameter for compatibility issues
sql92_security                 FALSE                                    TRUE       FALSE      FALSE      require select privilege for searched update/delete
standby_archive_dest           %ORACLE_HOME%\RDBMS                      TRUE       FALSE      FALSE      standby database archivelog destination text string
standby_file_management        MANUAL                                   TRUE       FALSE      FALSE      if auto then files are created/dropped automatically on standby
star_transformation_enabled    FALSE                                    TRUE       FALSE      FALSE      enable the use of star transformation
statistics_level               TYPICAL                                  TRUE       FALSE      FALSE      statistics level
streams_pool_size              0                                        TRUE       FALSE      FALSE      size in bytes of the streams pool
tape_asynch_io                 TRUE                                     TRUE       FALSE      FALSE      Use asynch I/O requests for tape devices
thread                         0                                        TRUE       FALSE      FALSE      Redo thread to mount
timed_os_statistics            0                                        TRUE       FALSE      FALSE      internal os statistic gathering interval in seconds
timed_statistics               TRUE                                     TRUE       FALSE      FALSE      maintain internal timing statistics
trace_enabled                  TRUE                                     TRUE       FALSE      FALSE      enable KST tracing
tracefile_identifier                                                    TRUE       FALSE      FALSE      trace file custom identifier
transactions                   187                                      TRUE       FALSE      FALSE      max. number of concurrent active transactions
transactions_per_rollback_segm 5                                        TRUE       FALSE      FALSE      number of active transactions per rollback segment
ent

undo_management                AUTO                                     FALSE      FALSE      FALSE      instance runs in SMU mode if TRUE, else in RBU mode
undo_retention                 900                                      TRUE       FALSE      FALSE      undo retention in seconds
undo_tablespace                UNDOTBS1                                 FALSE      FALSE      FALSE      use/switch undo tablespace
use_indirect_data_buffers      FALSE                                    TRUE       FALSE      FALSE      Enable indirect data buffers (very large SGA on 32-bit platforms)
user_dump_dest                 D:\ORACLE\PRODUCT\ADMIN\ODS\UDUMP        FALSE      FALSE      FALSE      User process dump directory
utl_file_dir                                                            TRUE       FALSE      FALSE      utl_file accessible directories list
workarea_size_policy           AUTO                                     TRUE       FALSE      FALSE      policy used to size SQL working areas (MANUAL/AUTO)

257 Zeilen ausgewählt.

***
*** tablespaces
***

TABLESPACE_NAME                TOTAL_FREE_SPACE_MB LARGEST_FREE_EXTENT_MB
------------------------------ ------------------- ----------------------
ABIT                                        515,81                 510,94
EXAMPLE                                      22,63                  19,81
SHDB                                        490,44                 487,94
SYSAUX                                          19                   2,94
SYSTEM                                        2,88                   1,94
UNDOTBS1                                    2589,5                2571,94
USERS                                       656,19                   56,5

7 Zeilen ausgewählt.

***
*** version of the owa_toolkit, must be >= 10.1.2.0.6
***

OWA_VERSION
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10.1.2.0.0

***
*** NLS database parameters
***

PARAMETER                                          VALUE
-------------------------------------------------- ----------------------------------------
NLS_LANGUAGE                                       AMERICAN
NLS_TERRITORY                                      AMERICA
NLS_CURRENCY                                       $
NLS_ISO_CURRENCY                                   AMERICA
NLS_NUMERIC_CHARACTERS                             .,
NLS_CHARACTERSET                                   WE8MSWIN1252
NLS_CALENDAR                                       GREGORIAN
NLS_DATE_FORMAT                                    DD-MON-RR
NLS_DATE_LANGUAGE                                  AMERICAN
NLS_SORT                                           BINARY
NLS_TIME_FORMAT                                    HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                               DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                 HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT                            DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                                  $
NLS_COMP                                           BINARY
NLS_LENGTH_SEMANTICS                               BYTE
NLS_NCHAR_CONV_EXCP                                FALSE
NLS_NCHAR_CHARACTERSET                             AL16UTF16
NLS_RDBMS_VERSION                                  10.2.0.1.0

20 Zeilen ausgewählt.

***
*** NLS session parameters
***

PARAMETER                                          VALUE
-------------------------------------------------- ----------------------------------------
NLS_LANGUAGE                                       GERMAN
NLS_TERRITORY                                      GERMANY
NLS_CURRENCY                                       €
NLS_ISO_CURRENCY                                   GERMANY
NLS_NUMERIC_CHARACTERS                             ,.
NLS_CALENDAR                                       GREGORIAN
NLS_DATE_FORMAT                                    DD.MM.RR
NLS_DATE_LANGUAGE                                  GERMAN
NLS_SORT                                           GERMAN
NLS_TIME_FORMAT                                    HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT                               DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT                                 HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT                            DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY                                  €
NLS_COMP                                           BINARY
NLS_LENGTH_SEMANTICS                               BYTE
NLS_NCHAR_CONV_EXCP                                FALSE

17 Zeilen ausgewählt.

***
***
***

PARAM                VALUE
-------------------- ------------------------------------------------------------
SESSION_USER         SYSTEM
CURRENT_SCHEMA       SYSTEM
DB_DOMAIN
DB_NAME              ODS
DB_UNIQUE_NAME       ODS
SERVICE_NAME         SYS$USERS
SERVER_HOST          daust3
SERVER_HOST_NAME     DAUST3
SERVER_ADDRESS       192.168.0.2

9 Zeilen ausgewählt.

Hope that helps,
~Dietmar.

Mod_plsql for Apache2

Thanks to Patrick for finding this really interesting post by Joel Kallman.

Finally, mod_plsql has been ported to Apache2. Up until now it was only available and supported for the Oracle Http Server based on Apache (1.3.x).

Using this configuration on a *nix (Linux / Unix) based machine would start a new database session even if the request would only serve a static image. Thus the connection pool of mod_plsql wasn't used at all. This is the first time where I have seen an advantage of the Windows architecture over Linux, bummer.

Thus on Linux you had to be careful planning for your environment if you expected a heavy load, here are some of the typical things to do optimize the performance.

Using Apache 2.0 and the new mod_plsql this should be improved now.

Greetinx,
~Dietmar.

Apex Meetup last Tuesday

Last week, we had the first Apex meetup in the Cologne area in Germany. We started off slow with a small group of five people :) . From left to right you see Uwe Mahlmann, Denes Kubicek, Jens Gauger and Erich Heinemann.


We hope to establish this exchange of ideas on a monthly basis. Let's see, how it works out. On the next picture you can see me (Dietmar Aust) on the right, too.

We were talking about the different projects and the different ways, in which we use Apex in our projects.

Jens also mentioned that there definitely is a need to show off more customer references on how Apex is used in the *real world*. If somebody researches different tools for their company, customer references and actual samples / screenshots / screencasts build credibility. David Peake recently blogged about large applications built with Apex. This will be definitely a valuable addition to the already existing resources on OTN, especially the community and partners page.

Another bigger topic was the generation of Excel and PDF reports, this area is still not perfectly solved using Apex out of the box. BI-publisher is very expensive and the other solutions are just too rudimentary.

It was a really nice place in Siegburg. I guess I will going there more frequently. Nice atmosphere and good food and drinks.












Hope to see you on the next Apex meetup. I will post the anncouncement here and on my website.

Regards,
~Dietmar.

Apex Stammtisch am 15.1.2008

Am kommenden Dienstag, dem 15.01.2008, findet in Siegburg (in der Nähe von Köln) der erste Apex Stammtisch statt!

Denes Kubicek und Dietmar Aust sind auf jeden Fall dabei. Wir freuen uns auf ein lockeres Kennenlernen bei einem Bier und evtl. leckerem Flammkuchen.

Vielleicht bis nächste Woche!
~Dietmar.