I have the following problem. I am developing an application using Oracle Lite. One of queries have a strange behavior.
If my computer is just switched on, the query runs 10 seconds (which is unacceptably slow). Next time I run the query it runs 1 second. All other queries run normally.
The query is very simple. something like this:
from gg_price_items pi
where pi.CANV_CODE = 'ROTT'
and pi.CANV_EDITION = 2006
and pi.SECTION_CODE = '01';
The table has approximately 2000000 records. All necessary indexes exist. Query returns approximately 5000 records.
I use Oracle Lite 10.2.0.2. (This problem also exists for the version 10.2.0.1)
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…