Q
Problem solve Get help with specific problems with your technologies, process and projects.

Parallel query support

I need to upgrade Oracle 7.3.4. I would like to buy the new Oracle license called "Edition One"; this version does not support the parallel query. How can I know if the actual DB rel. 7.3.4 is using parallel query?
I don't have a version 7.3.4 database around to look at, but I'd expect that this would apply to 7.3.4 as well. I'd check v$parameter for any parameter that starts with 'parallel%' and see what they're set to. Also check the ISDEFAULT column in v$parameter to see if they've been changed from the defaults. If parallel_max_servers is 0, then you're clean -- no parallel query is in use.

The next thing I'd check is in v$sysstat and see what you find for any statistics named like 'PX%' or 'parallel%' and hopefully you'll find numbers to indicate that parallel operations are not occurring (at least not since the last instance restart).

You can also check v$option and see if the parallel query option is installed.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close