Performance on Pl/SQL table

[Bimalaggarwal]

I have a pl/sql table defined on a global level (in a package definition) as :

type table1 is table of pls_integer index by binary_integer;
g_table table1;

where many users go over this table, through the following code in a procedure:

<package_name>.g_table.delete;

.. call to populate this table

.. call to process this populated table

My problem is that when several users start the task at the same time, there is a
very low performance. I do not understand the cause of this.

I need help.

 

[sem]

Each user has its OWN PRIVATE copy of this table, so I do not think they may affect each other (besides utilizing limited system resources). BTW, how many records (approximately) are &quot;inserted&quot; into this table? Regards, Dima

 

[Bimalaggarwal]

The number of records is not to many. It may range from 1 to 50 per user.
Does the <table_name>.delete has any kind of locking effect
on the resources?

 

[sem]

No locks, and the number of records is quite small. Try to look in another place, I'm sure it's not due to using pl/sql tables as it's just a kind of array, not database-wide objects. Regards, Dima