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:
Analyzing a Segment, Adding Segment Filters Oracle B2C Service, Outreach and Feedback, Audiences
Resolution:
When you create an audience for a Outreach mailing you can break that audience into segments, you can then analyze the segment. After you create or edit a segment, we recommend that you run the segment analyzer to check the segment’s database queries. This allows you to fine-tune your segments to ensure they run as quickly and efficiently as possible. The segment analyzer examines your segment and provides suggestions as to how you can improve the segment by removing database tables, adding filters, and making other changes. The analyzer also shows you the estimated number of rows the segment’s query may need to access so you know if the segment can run without encountering row limits. To analyze a segment
The segment analyzer lists the segment’s filters, tables, output levels, and the estimated number of rows the segment’s query will examine when it runs. If the analyzer finds potential issues with the segment’s query, it lists the issues in the Notes column next to the applicable segment component. The following describes the four segment components included on the Segment Analyzer window and lists the messages you may see in the Notes column when potential issues are found. Filters - This section lists the expressions used for each segment and level filter and identifies whether the filters’ fields are indexed in the database and whether the index is used. Custom fields can be indexed for faster queries, though too many indexes can slow down queries. Only the following message can be returned in this section. The filter contains a custom field that does not have an index. To improve the performance of this query, consider adding an index on the custom field. Tables - This section lists the tables that are used in the segment, along with the types of joins used to link the data in the tables. Four messages can be returned in this section. • This table is in an outer join but there are one or more filters on fields in this table. Make sure this is by design. If not, consider changing the join type to inner or changing these filters to join filters to prevent an implicit inner join. • This table is not used in the report. Consider removing the table from the data set. If you need to filter out rows in the parent table that do not have rows in this table, consider adding a not null filter on the join field in the parent table. Levels - This section does not apply to segments even though it displays in the report. Rows This section lists the estimated number of rows that will be examined by the query. Messages are displayed if the number of rows exceeds the threshold values for the operational database and replication server. Three messages can be returned in this section. The messages vary depending on whether your site has a replication server in addition to the operational database. • The estimated number of analyzed rows for this query is X. This value exceeds the threshold of 2,000,000 for the operational database. Consider using the report database for this report. Otherwise, it is likely this will occur automatically. • The estimated number of analyzed rows for this query is X. This value exceeds the threshold of 2,000,000 for the operational database. Since you have specified the operational database for this report, it is unlikely the report will execute. Consider using the replication server for this report. • The estimated number of analyzed rows for this query is X. This value exceeds the threshold of 5,000,000 for the replication server. Consider adding or refining filters to reduce the number of analyzed rows to below this threshold. Otherwise, it is unlikely the report will execute.
For additional information, refer to the 'Analyze a Segment' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.