Oracle Point, Oracle Life.

Oracle Application Server 10g offers 4 types of installation as following: 

 1. Infrastructure
 2. Portal and Wireless
 3. Business Intelligence
 4. J2EE and Webcache 

Prior to OAS 10gr1, oracle 10g 904 offers separate component installation, such as “Forms and Reports”. In order to install OAS components, the infrastructure installation is basically essential. That installation help to setup and configure Oracle Internet Directory (OID), which is important to establish integrative application environment. 

If OAS will be installed in the same physical machine where the database is installed, please make some changes on database setting. Please be noted that, after the installation of database, the default listen port 1521 should be freed for OAS installation use. If not, OAS setting up wil not be performed successfully because OAS installer will take port 1521 to install the OAS repository database. One way to free port 1521 is changing listener.ora and tnsnames.ora. And, restarting listener take it effective. Another installation tip is changing the host name from global name to localhost host name in OAS listener file if the OID component can not be configured successfully. For instance, change xxxxx.test.com to xxxxx. 

It’s definitely possible to install OAS and production database in same physical machine. But, it’s strongly not suggestted. 

Popularity: 2% [?]

High Water Mark

1. Dropping user/schema would cause any system priveleges user has to disappear and the import would not restore them. The import will import data structure, data, constraints,trigger,procedure and so on.

2. How to move table from one tablespace to another one?
Refer to here

Also in local Oracle Articles.

3. How to Calculate the value of High Water Mark?

SELECT BLOCKS
FROM DBA_SEGMENTS
WHERE OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table);

ANALYZE TABLE owner.table ESTIMATE STATISTICS;

SELECT EMPTY_BLOCKS
FROM DBA_TABLES
WHERE OWNER=UPPER(owner) AND TABLE_NAME = UPPER(table);

Thus, the tables’ HWM = (query result 1) - (query result 2) - 1
NOTE: You can also use the DBMS_SPACE package and calculate the
HWM =TOTAL_BLOCKS - UNUSED_BLOCKS - 1.

4. Truncate table
A truncate moves the High Water Mark of the table back to zero. No row-level locks are taken, no redo or rollback is generated. All extents bar the initial are de-allocated from the table

Popularity: 8% [?]