How to speed up Information schema queries on Oracle?

Question

Oracle

An Information schema request or just a request for ALL_COLUMNS, ALL_CONSTRAINTS, etc. lasts 6-7 seconds.
It only helped to put /*+RULE*/ into the request, then it returns in 0.5-0.8sec. The provider is OraOLEDB, the base is 12g, the server itself is not for production, but for development, i.e. in it every day hundreds of bases are created / crashed, there is not enough data.
Tried updating stats, improved to 5.2sec from 6.7sec.
I will be glad to any advice

Answer 1

How were the statistics collected? Ideally, after each "creation of the base" to collect over the entire base,
or at least for your problem
. Are there any specific init-parameters set on the base?

Answer 2

Yes, did the same. The result was a 1 second improvement.
Bases are in fact tablespaces for the user, like this I create:
CREATE TABLESPACE %DBName% DATAFILE %PathDBName% SIZE 8M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED;
CREATE USER %DBName% IDENTIFIED BY %Pass% DEFAULT TABLESPACE %DBName%
TEMPORARY TABLESPACE "TEMP"';
GRANT "CONNECT" TO %DBName%;
GRANT CREATE TRIGGER TO %DBName%;
GRANT CREATE TABLE TO %DBName%;
GRANT CREATE PROCEDURE TO %DBName%;
GRANT CREATE VIEW TO %DBName%;
GRANT UNLIMITED TABLESPACE TO %DBName%;
GRANT CREATE INDEXTYPE TO %DBName%;