Archives
OPAQUE_TRANSFOR comes as undocumented hint you can usually see in a data warehouse environment. Oracle rewrite query INSERT INTO..SELECT or CREATE TABLE..AS every time you refer to a remote instance using DBLink. OPAQUE_TRANSFORM appears every time query is distributed and involves the SELECT part from remote database. SQL> insert into t1 select * from t1@lab11r2 [...]
I was looking online for this issue: are you able to know when a parameter was changed in your database or also track all parameters changes in your database? Kerry Osborne has the solution. Even if you’re able to check in your alert log file for changes (Oracle logs every changes to parameters) you can [...]
Do you know that there are more than thirty not documented and hidden parameters for tracing? You can find them with this query: select ksppinm "Parameter Name", ksppstvl "Value", ksppstdf "Default", from x$ksppi x, x$ksppcv y where x.indx = y.indx and ksppinm like ‘/_%trace%’ escape ‘/’ ; Note that Oracle 9i has about 26 parameters [...]
Recent Comments