pavani

• Jun 13th, 2006

 

When U load the data into a table in Utility mode,all the constraints are disabled and then data is loaded which leads to faster access.

During API Mode constraints will be enables so that the access will be slow.

tsrkrishna

 Profile 

• Jul 6th, 2006

 

These are the Database interfaces

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 7th, 2006

 

API and UTILITY are the two possible interfaces to connect to the databases to perform certain user specific tasks. These interfaces allows the user to access or use certain functions (provided by the database vendor) to perform operation on the databases.The functionality of each of these interfaces depends on the databases.

API has more flexibility but often considered as a slower process as compared to UTILITY mode. Well the trade off is their performance and usage.

dontbuckme

 Profile Answers by dontbuckme 

• Sep 22nd, 2006

 

I think you've the misunderstanding.  Using utility mode does not need to disable constraints nor indexes, if you use the conventional path load (say Oracle).

For direct path, you might need to.

Basically, api mode is using oci calls, so it is much slower.

utility mode is calling the database client utility, e.g. Oracle sqlldr. 

subhajitpalit

 Profile Answers by subhajitpalit 

• Dec 11th, 2009

 

In API mode the data processing(load/update/insert/delete) is slow, however other process can access the database tables during the update.

Compared to above, Utility mode processing(load/update/insert/delete) goes faster, as it handles data records in large chunks, however during that time no other process can access the database table, i.e., the process running in Utility mode locks the table/owns exclusive ownership of that database instance.

In cross functional & largely distributed organizations, API mode is recommended considering the performance aspect, over Utility mode.

However for one time loads/initialization of huge volume data in tables, Utility mode can be used.

abmaahi

 Profile Answers by abmaahi Questions by abmaahi

• Jun 12th, 2010

 

API mode is for more diagnostic purpose for retriving the data from db means like selecting perticular fields, like retriving the data relatively according to the constraints.  Whenever we select API we will get the option of ablocal expression (ab_exp) everytime where ever record is passing it will look for the query we write in that ablocal expr block then it will send.  That is why its slow. Where as utility is like retriving the data fields without any consraints or any conditions, that is why it is fast.