Search results for query: *

I've searched on multiple sites, documentation, metalink, google... But have not come up with anything to resolve an issue with a production database. We use a third party application, which was written such that it uses dblinks to access tables between schemas. They say it was written...

I am interested in your real world experiences in the analyzing of sys schema in 9i. Some documents state it should be done. What have you found to be the real world case? Also, I was wondering what your real world experience is for analyzing other schemas? Do you do it on a scheduled basis...

I have a situation where we are still supporting Oracle Apps 10.7 on 7.3.4 (Yeah, I know!) The application currently uses a dblink with gateway vers. 4 to MSSQL sqlserver 6.5. We have to move the sqlserver to version 2000 by the end of the year. Knowing that 7.3.4 cannot use any gateway...

Metalink indicates: When HASH_MULTIBLOCK_IO_COUNT it set to 0, it means that Oracle computes the value for each query. Sometimes ORA-3232 may be encountered when a query uses HASH JOIN. But, they don't really say what to do when the block size for TEMP tablespace is per their Bulletin. Any...

In our organization, we must now back up our datafiles to a network attached storage device. In order to save space, we have to compress the datafiles. Does anyone know of a faster method than compress? I looked at bzip2, pack, gzip, but they don't seem any better. Is there any other methods...