I am facing performance problem with a new company. It is very very slow. We found this issue over the whole process of creation, using of this company and while deleting this company also.

This 900 company data is old. We need to put back for reference purpose.

So, thought of creating a new tablespaces (both data and index) temporarily and may remove tablespace after few months. So I created a tablespace "datspacetest" and "idxspacetest". And modified ora_storage as below.

------------------------------------------------------------------------------------
*:900:T:group:0214:5:TABLESPACE datspacetest PCTFREE 5 INITRANS 3
*:900:I:group:0214:5:TABLESPACE idxspacetest PCTFREE 5 INITRANS 3
*:*:T:group:0214:5:TABLESPACE datspace PCTFREE 5 INITRANS 3
*:*:I:group:0214:5:TABLESPACE idxspace PCTFREE 5 INITRANS 3
-----------------------------------------------------------------------------------

Can you please suggest me where I am doing mistake.

From the first, we haven't thought of tablespecific data storage.

Thanks in advance
Subbu
:cool: