Questions? We have some common questions and answers below.

If you don't see what you're looking for, be sure to contact one of our expert support staff.

How will I control my Oracle service plan from an account management and billing standpoint?

Managing and administering your Oracle10g database is done through the Oracle Control Panel.

Will I be notified of events affecting my billing or system limits?

Yes. If account limits are reached or any other problems occur, a notification e-mail is automatically sent to you with details or instructions on how to resolve the problem.

What kind of support is offered?

Verio is selling the hosting of Oracle10g, and cannot support Oracle functionality. Hosting support from Verio includes ensuring the database is up and running, the listener is listening, and all servers are functional.

While Verio is planning to offer Support Plans (from Oracle Corporation) in the future, if you wish to purchase additional support today, we recommend using a remote DBA (Database Administrator) service of any of a number of professional service providers. A great source for this information is the International Oracle Users Group.

What is the Cancellation Policy on this service?

Oracle10g Shared Hosting is a month-to-month service offering. You may cancel any time, but you will be billed for the remainder of the month in which you cancel.

What if I want to change my payment method?

Call Customer Service at (800)-905-7675.

What if I want to change my billing address?

Call Customer Service at (800)-905-7675.

Can I move my Oracle10g database to my own Oracle server and run it from my own machine if I choose to in the future?

Yes. You can export your data and transfer it to another Oracle server.

What's the difference between Oracle Enterprise [corporate?] and Oracle Standard?

Oracle Standard is designed for single machine databases. Oracle Enterprise is designed for databases that span multiple machines, requires off-site replication, or requires the 10 percent performance increase that 64-bit software can provide over the 32-bit Standard Edition. For more information on Oracle Standard and Oracle Enterprise, visit the Oracle Corporation Database Web Site.

If I have a problem with my database and lose data, how can I restore it?

Call one of our Customer Service Representatives at (800)-905-7675. Restores are charged on an hourly basis.

How often do you backup my data?

Your entire database is backed up once a week. Archive logs are backed up every 15 minutes.

How secure is my data? For example, can I confidently store credit card information?

Hosted Oracle10g Databases uses standard Oracle database security. You can confidently store credit card or customer information without concern.

Why is there a limit on the number of concurrent connections for Hosted Oracle Databases? Other databases don't have these limits.

Providing Oracle in a shared hosting environment requires control of concurrent connections in order to optimize server performance. Limiting connections also ensures that no single account ties up all database resources. For more information on concurrent connections, and the reasons for limits in Hosted Oracle10g Databases see more information on concurrent connections.

Is there a limit on my connection idle time?

Yes. Your connection can be idle for 10 minutes before it is disconnected. This is a precaution to avoid performance degradation caused by many idle connections.

Is there a limit on CPU time?

For performance purposes, we have limited the amount of CPU time per session to 10 minutes. This will prevent any runaway calls that can occupy the CPU and reduce performance.

I just dropped a very important table. Can I get it back?

Yes. Contact customer support for help.

Why can't I insert any rows into my table?

Ensure you're supplying data for all columns marked NOT NULL.

Make sure your format is correct, and that you are using single or double quotation marks where required. For example:

• The correct date format is: "01/04/00"
• The correct text format is: "31 Archer Street"
• The correct number format is: 31.9

Refer to a good Oracle SL guide. Suggestions include Oracle10g: The Complete Reference by Kevin Loney, George Koch. Hardcover (May 23, 2000)

What does defragment tablespace do? Specifically, does it defragment all tables associated with a user?

The "defrag tablespace" function is only available to the Oracle account owner. It removes all empty rows within tables and indexes to free up disk space. This is because defrag tablespace defragments the entire account. With Oracle, when a row within a table is deleted, that space is not recovered. The space can be reused by new rows within that table, but cannot be used by other tables. Therefore, the only way to recover space within Oracle is to defrag the entire tablespace. This recovers space from all tables and indexes of all users within that account.

Are there any schema managers Hosted Oracle10g Databases does not support?

Hosted Oracle Databases does not currently support ER Studio. We are working to resolve this problem.

If I plan on ordering a Solaris VPS with my Oracle database, which data center should I get the server in?

You should get your server in the San Jose data center. This will ensure the fastest possible connection to your Oracle database. If you have already received your Solaris VPS in a different data center, you can change the location of the server in the backroom free of charge.

Oracle is a registered trademark, and Oracle10g is a trademark or registered trademark of Oracle Corporation.