I have a query that I\'m executing on a database that returns an array of records, I read in the Oracle OCCI documentation you have to use the ResultSet::setDataBuffer() function to fetch array\'s of
I have a requirement to drop partition from an interval partitioned table, if the partition is older than three months.开发者_高级运维
We have a merge statements shown below, instead of index range scan it is making full table scan. It ran successfully till last until after the table was altered added 3-4 new columns when it started
I am a newbie to Oracle and I know that oracle uses two AWR snapshots to create an AWR report. What are three basic requirements that dete开发者_StackOverflow社区rmine whether an AWR snapshot is usabl
I am trying to Install Oracle 11G on Windows Xp 64 bit. The installer shows the progress bar for checking prerequisites and then crashes.
At 10PM each Tuesday all of a sudden oracle is generating huge REDO logs until the disk runs out of space.My application is not running any huge queries or anything during this time according to the l
Try to be more clear, I\'m in lack of ideas in this problem, even it sounds like a classic. My application is running on weblogic 10.3.3开发者_高级运维 application server, and for database I am using
I would know if it could works like this: Database 11G R2 on Windows 2008 R2 x64 Oracle Client 9i (what version?) for OCI connection on 11g ?
I have created a BPEL process and added a DB adapter for polling a table change of new row added.. and my polling interval is 60 seconds,
I have hundre开发者_C百科ds of stored procedures and i want to find out the name of the procedure which uses the particular column name in queryThis will do it, but might produce false positives for g
加载中,请稍侯......