Search for existing answers to your product and support questions.
Familiarize yourself with our support site and learn best practices in working with our team.
Manage Service Requests, View and update service requests submitted by you and others in your organization.
Submit a new issue to our technical support team.
Oracle B2C Service insights from our Technical Support team subject matter experts
Browse resources to assist you in launching your implementation and ensure a successful go-live.
Access your OCI account.
Find product documentation for supported versions of B2C and documentation libraries for related service solutions.
You will have the tools to improve your customers' experience when you learn about all the things our products can do.
Find links for API documentation, Custom Processes, Customer Portal, and Agent Browser UI Extensibility Framework.
Explore how accelerators are designed to demonstrate how an integration scenario could be built using the public integration and extension capabilities of the Oracle B2C Service.
Prepare for a successful transition by reviewing upcoming release changes and enhancements.
Explore webinars, events, and feature kits to learn about B2C Service features, functionality, and best practices from the technical experts.
Oracle MyLearn offers a portfolio of free and paid subscription-based learning resources to help you gain valuable skills, accelerate cloud adoption, increase productivity, and transform your business.
Empower your team with the skills to implement, configure, manage, and use your applications with Customer Experience Cloud Training.
Our goal is to facilitate a friendly, supportive environment where members can easily collaborate with each other on solutions and best practices.
Ask and answer questions specific to B2C.
This is an exciting resource intended to help with your Oracle Service Cloud Analytics.
Share product improvement ideas and enhancement requests with Oracle Development, while collaborating with other Oracle customers and partners.
Update your phone number, email notification preferences, and severity 1 and severity 2 contact preferences.
View the contact managers within your organization.
Find contact information of the Technical Account Manager (TAM) and Client Success Manager (CSM) for your organization.
Environment:
Connect Web Services for SOAP (CWS) API, REST API, Connect for PHP API, ROQL, All product versions
Resolution:
When ROQL query is run from one of the Oracle B2C Service public APIs runs an estimate of database table rows scanned by the query is performed. This estimate is in place as a safety check to protect your database and ensure consistent and reliable response time from the database. This estimate is an estimate of the number of rows it must scan, not the number of rows returned. If the pre-scan is determined to be too large then you will receive an exception indicating 'Poor performing query - too many rows examined'. There are different thresholds (also known in more technical terms as the max join size) for different databases. The amount that is allowed by the pre-scan when a query is run from one of the public APIs is as follows: Operational database - 2,000,000 Replication server - 5,000,000 Note: These are mandatory settings and cannot be changed.
Requests using ROQL can be configured to go to either the Operational database or replication server. The replication server is an exact copy of your operational database but it is designed to handle queries (including those used by reports) that are too large to run off the operational database. Because of this there are times when it may fall behind.
If you encounter such an error when executing your ROQL queries we suggest you optimize your query before running the query again. Adding a WHERE clause can help or add additional filters to the WHERE clause. Including LIMIT to the query does not affect the pre-scan as it will only constrain the number of rows returned in the output.
Answer ID 12091: Can't perform a select statement even with small limit in ROQL
Database indexes can help also. Custom field indexes can be added from the console and indexes on standard fields can be analyzed and implemented with an SR to Technical Support used to engage Cloud Engineering resources.
For further information on the process used to add indexes to standard fields refer to Answer ID 8702: Working with Technical Support to analyze for and implement database indexes.
For further information refer to Answer ID 5169: Technical Documentation and Sample Code.