You can optimize query performance of large document sources by storing the crawler index in partitions distributed across several independent disks. Oracle SES then executes parallel subqueries automatically against the partitions. Both I/O and CPU resources are used in parallel.
These administrative objects support parallel query:
Note:To support parallel query, you must create the partitions immediately after installing Oracle SES. You cannot create them after crawling a document source.
To support parallel query:
Open a SQL session as the administrative user:
Execute two PL/SQL procedures to enable the partitioning feature of the Oracle SES instance:
exec eq_adm.use_instance(1) exec eq_par.enable_partition
Define one or more
storageArea objects with a usage of
PARTITION on each physical storage device available to this instance.
partitionConfig object to have a rule type of
HASH and to use the new
Create document sources and schedule them for crawling.
See Also:"Parallel Query Indexing" in the Oracle Secure Enterprise Search Administrator's Guide.
This example creates two partitions, using the default OES storage area and a newly created OES1 storage area:
searchadmin, export the XML description of the default OES storage area to a file named oes.xml:
export storageArea --NAME=oes --OUTPUT_FILE=oes.xml
Export the XML description of the partition configuration to a file named part.xml:
export partitionConfig --OUTPUT_FILE=part.xml
Open oes.xml in a text editor and edit it as follows:
<search:config productVersion="220.127.116.11.0" xmlns:search="http://xmlns.oracle.com/search"> <search:storageAreas> <search:storageArea> <search:name>OES1</search:name> <search:description> Default storage area extension </search:description> <search:usage>PARTITION</search:usage> <search:locations> <search:location> <search:path>/ses_storage/</search:path> <search:device>default</search:device> <search:preAllocatedSpace>20</search:preAllocatedSpace> <search:quota>400</search:quota> </search:location> </search:locations> </search:storageArea> </search:storageAreas> </search:config>
Open part.xml in a text editor and edit it as follows:
<search:config productVersion="18.104.22.168.0" xmlns:search="http://xmlns.oracle.com/search"> <search:partitionConfig> <search:partitionRules> <search:partitionRule> <search:partitionValue>EQ_DEFAULT</search:partitionValue> <search:valueType>META</search:valueType> <search:ruleType>HASH</search:ruleType> <search:storageArea>oes, oes1</search:storageArea> </search:partitionRule> </search:partitionRules> </search:partitionConfig> </search:config>
Create the new storage area:
create storageArea --NAME=oes1 --INPUT_FILE=oes.xml
Update the partition configuration:
update partitionConfig --INPUT_FILE=part.xml --UPDATE_METHOD=overwrite