Database Administration (MOSC)

MOSC Banner

setting a default degree of parallelism on oracle

edited Jul 4, 2016 6:04AM in Database Administration (MOSC) 12 commentsAnswered ✓

dear all,

is there any way to set a default of parallelism on a database, or how to enable the automatic parallelism ... I've set parallel_degree_policy to AUTO but even though parallelism is not tunned well for long running queries!

Machine has 8 Cores * 2 Threads, OS Linux x86_64, Total Memory 1 TB.

Oracle Database Version 11.2.0.4.

sga_target = 700G

pga_aggregate_target = 160G

_pga_max_size          = 32G

workarea_size_policy = AUTO

_smm_max_size          = 16777216

the DB is physical standby, how to fix a degree of parallelism on it without fix it on the primary.

is there is better way than creating a view with parallel hint on the primary database for each table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center