Top FAQs for Managing Oracle BI Cloud Service

The top FAQs for managing Oracle BI Cloud Service are identified in this topic.

How do I upgrade my Oracle BI Cloud Service?

Everyone who subscribes to Oracle BI Cloud Service receives automatic upgrades as soon as new versions become available. You don't need to request an upgrade or take any actions yourself. To find out about recent new features and enhancements, see What's New?

Can I track how many users sign in to Oracle BI Cloud Service?

Yes. Administrators can monitor how many users sign in to the service. Click Business Intelligence or Database from the Platform Services tab in the Oracle Cloud My Services page. See Viewing Service Details in Managing and Monitoring Oracle Cloud.

Can I see how many users are currently signed in?

Yes. Display the Home page , click Console, and then click Sessions and Query Cache. See Monitoring Users Who Are Signed In.

Where can I find the public key for my service?

Display the Home page, click Console, Connections, and then click Get Public Key.

Can I see the SQL generated by an analysis and analyze the log?

Yes. Display the Home page, click Console, and then click Sessions and Query Cache. See Analyzing SQL Queries and Logs.

What happens to my content if I terminate my subscription to Oracle BI Cloud Service?

When you terminate your subscription, Oracle takes a snapshot of the latest data model, catalog content, and application roles. The snapshot is sent to you in a password-protected Oracle Business Intelligence archive (.bar) file. If you subscribe to Oracle BI Cloud Service in the future, you can import content from this archive file. The password that you need to upload the archive file to another service is IdentityDomainName_ServiceName.

See Uploading Snapshots and Restoring from a Snapshot.

In my Database Service I see some tables called S_NQ_DSS_CREDENTIALS, S_NQ_DSS_FS_FILES, S_NQ_DSS_SERVICE_INFO. I'm not sure what they’re for. Is it OK to delete them?

Data Visualization uses these tables. Do not modify, update, or drop these tables:

  • S_NQ_DSS_CREDENTIALS

  • S_NQ_DSS_FS_FILES

  • S_NQ_DSS_SERVICE_INFO