I have 2 different users, both tied to 2 different tablespaces.
Both of these users have the same exact privileges.
I also have a public database link to our ERP (mssql)
USER A = No Performance issues locally or over dblink
USER B = a query that i perform with user A and excutes in 0.281 seconds, hangs here. I created a table, and importing a CSV via SQL Developer also hangs, query to dblink also hangs.
i've done the general administration and performance tuning. I have trc turn on at the DB gateway but the issue is beyond that.
Here are the permisions for both
select * from session_privs;
CREATE MATERIALIZED VIEW
SELECT ANY DICTIONARY