Consultes Oracle

Recursos

select * from v$resource_limit;

alter system set processes=1200 scope=spfile;
alter system set sessions=1224 scope=spfile;

Establir permisos a tot un esquema a un usuari

DECLARE vSQL VARCHAR2 ( 200 );
BEGIN
	FOR x IN ( SELECT OWNER, table_name FROM all_tables WHERE OWNER = 'QUALITAT' )
	LOOP
		vSQL := 'GRANT SELECT ON "' || x.OWNER || '"."' || x.table_name || '" TO CURTITS';
	  EXECUTE IMMEDIATE vSQL;	
  END LOOP;
END;

Consulta per creació de DDL per creació de sinonim

select 'create or replace synonym "' || synonym_name ||
'" for "' || table_owner || '"."' || table_name || '";' as "DDL"
from dba_synonyms
where owner = 'CURTITS'