Data Management for Oracle BPEL PM

If you are searching for documentation to manage the Oracle BPEL schema, you will find the following:

FIRST: Official links:
Tables Impacted By Instance Data Growth
Best Practice Guide: Dehydration Store Management: 10-25
which leads to this link.
and last but no least:
Clemens Utschigs Best Practices: unzip the file and look at BestPractices/BPEL/BPEL_Purging_DehydrationStore.
SECOND: Unofficial blogs:
Delete BPEL instances and if you use some search engine you will find some more blogs with similar content...
THIRD: Metalink:
Note:341102.1
Subject: How to purge BPEL audit tables to avoid growing tablespace issues ?

Ok. For BPEL installations with few workflows per day this is enough but what is with high rate systems, where no downtime is allowed?
Oracle provides very nice features like transportable tablespaces and partitioning (see my blog entry here) . Why are these features are not included in the Oracle BPEL installation?
But this is not really a problem, because at this point Oracle Partners like GIP can provide additional features in their products....

Posting at Xyna blog

Today a my posting about performance and BPEL was added on the Xyna Service Factory blog.
Here the link to the posting.
It is in german...

Partitioning & Transportable Tablespaces

Here an example how to use in an Oracle database partitioning together with transportable tablespaces:

Create Tablespaces

To create tablespaces, put the following lines into a file createTablespace.sql

CREATE SMALLFILE TABLESPACE "&1" DATAFILE '/opt/oracle/oradata/XYNADB/datafile/&1.dbf'
SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
exit;

and start the script via sqlplus with sqlplus system/pwd @ createTablespace.sql TTS01.
It will create a tablespace named TTS01. Repeat this step with TTS00 and TTS02.

Create Table

To create a partitioned table enter the follwing lines:

create table parttest (
id number, name varchar2(40), payload varchar2(40))
partition by range (id)
(partition part00 values less than (100) tablespace tts00,
partition part01 values less than (1000) tablespace tts01,
partition part02 values less than (10000) tablespace tts02);
exit;

Insert Data

Now put into the table parttest any data you want (the id has to be lower than 10000).
Just to verify, that the partitioning is working, use the following command:

select * from parttest partition (part01);

Adding new Partitions

To add new partitions, you have to create a new tablespace (s. abouve) and then enter the following command:

alter table parttest add partition part03 values less than (20000) tablespace tts03;

Drop an old partition

To drop an old partition, use the follwing command:

alter table parttest drop partition part00;

But with issueing this command your data in this partition is gone and there is no rollback!

Anything new?

Now we have a table partitioned over several tablespaces. We can add partitions and drop them.
The advantage is, that performance is better than with one unpartitioned table because the optimizer uses the partitioning to get faster access to the data.
But if you could move the partitions without dropping them, that would be a real enhancement.
Here the commands how you can:

Moving the data

First you have to create a table with the same structure as your paritioned table (but without the partitions) on the same tablespace where your data resides, which you want to move.
After that you can exchange the data of your partitioned table with the data of the new table.

alter table parttest exchange partition part01 with table parttestnew;

After that you can drop the partition on the original table parttest without loosing your data, which is still there in the table parttestnew. And if you want to can move the partition with the transportable tablespace feature from Oracle to another instance…

At GIP these features are used in the Xyna Service Warehouse (take a look at my guest post there!).

2XK is over...

The second xyna conference (2XK) is over. On the gip web pages you can take a look at the
official press release and get an impression.
There were keynotes given from SUN (a very humourous lecture about Wonderland Inc. from M. Jeske about second life for business), CISCO, Fokus and Oracle. AND of course the keynote from the director of the GIP research institute B. Reifenhäuser.

Here a short summary from the official agenda:

Xyna Service Factory: The fractal Telco-factory as the answer to the challenging defiances within Telco industrialization

Network abstraction as integral building block for fractal factories: Cisco next generation device and network management

Project Wonderland Inc. (Sun Laboratories): Web 2.0 for Enterprise Environments

From MetaSolv to Oracle Communication Service Fulfillment Suite: Driving Service Delivery Innovation in Communications

New FOKUS Open SOA Telco Playground: Evolution of Telco Service Platforms in Face of Network Convergence and SOA Principles

There are the first photos (including the party) available...

A long time ago (part 3)

6/2005: One of the big television stations in Germany (ZDF) published a note about using Xyna Experimentierplattform for Webmining.
If you follow the link, you can download the pdf.
You can read there some numbers about the data amount:

In november 2004 59 of 86 million page impressions were analyzed. Not bad...

Xyna Service Factory Blog

There is a Xyna Service Factory Blog available.
Nice to read, but only in german.

Click on the link...

Oracle Magazine: Xyna, GIP & Oracle...

Take a look at www.oracle.com. Oracle magazine lists my company as one out of three Oracle Certified Partners, which has announced a product based on 11g:


GIP will use Oracle Database 11g in Xyna Service Factory, GIP's integrated platform for the development, production, and lifecycle management of IP-based telecommunication services. Specifically, Oracle Database 11g is the basis for two elements of the Xyna Service Factory platform: Xyna Service Warehouse, a subscriber-centric active warehouse, and Xyna Intelligence, a subscriber touchpoint management system. GIP serves leading German and international companies in the telecommunications, information, media, and entertainment sectors.

Update: Xyna Conference

The official press release is out!
Take a look at !
There will be keynotes from ORACLE, Sun Microsystems, Cisco Systems and the Berliner Fraunhofer FOKUS-Institut.

One Month to go ;-)

2. Xyna Konferenz

The second Xyna conference is announced.
Take a look at www.gip.com.

It is sponsored by Oracle and its title is telecommunication 3.0....
cu on 22nd november....

If you are interested in the first xyna conference take a look here.

Lecture given in Kaiserslautern

Hi,

this is a link to a lecture given at the university of Kaiserslautern about Xyna Service Factory.
If you want to find out more about Xyna, take a look at GIP .
Here the link to the press release:
http://www.gip.com/html/news.html#0702