I have a database that is exhibiting odd behavior, even after a RELOAD. I'm getting lots of Waiting For Required Resource messages, even when I'm the only one in the databse (in multi mode).
I did notice that, when I reload the table, there is a very large number of rows for SYS_PASSWORDS (this database uses grant/revoke security). When I do LIST ACCESS I see lots of junk entries in the access control lists. I tried PACK PASSWORD and that cleaned up the bad LIST ACCESS entries. However, still see the odd conflicts, sometimes have trouble connecting, and am seeing bad access entries beginning to accumulate in LIST ACCESS. Anyone have any experience with this? What can I do to stop the accrual of those records in the password system? -- Larry
