tag:blogger.com,1999:blog-5124641802818980374.post8002339261546161845..comments2023-09-06T11:58:30.752+02:00Comments on Oracle related stuff: Free WebinarUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5124641802818980374.post-69311712458570387802013-05-02T10:26:07.305+02:002013-05-02T10:26:07.305+02:00Hi Amos,
in the upcoming webinar I'll focus o...Hi Amos,<br /><br />in the upcoming webinar I'll focus on different topics - I won't go into the details of Parallel Processing related parameters and further configuration considerations like Auto DOP and Resource Manager, though I know it is a topic of great interest.<br /><br />If you haven't done so, I recommend reading the blog posts published on the official Oracle Data warehousing blog, which provide a wealth of information around that topic area.<br /><br />Here's a (possibly incomplete) list of recommended blog posts:<br /><br /><a href="https://blogs.oracle.com/datawarehousing/entry/calculating_parameter_values_f" rel="nofollow">Calculating Parameter Values for Parallelism</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/auto_dop_and_concurrency" rel="nofollow">Auto DOP and Concurrency</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/auto_dop_and_queuing_parameter" rel="nofollow">Auto DOP and Queuing Parameter Settings</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/auto_dop_and_parallel_statemen" rel="nofollow">Auto DOP and Parallel Statement Queuing</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/workload_management_statement" rel="nofollow">Workload Management – Statement Queuing</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/workload_management_a_simple_b" rel="nofollow">Workload Management – A Simple (but real) Example</a> <br /><a href="https://blogs.oracle.com/datawarehousing/entry/parallel_degree_limit_hierarch" rel="nofollow">Parallel_degree_limit hierarchy – CPU, IO, Auto or Integer</a> <br /><a href="https://blogs.oracle.com/datawarehousing/entry/explaining_explain_plan_notes" rel="nofollow">Explaining Explain Plan Notes for Auto DOP</a><br /><a href="https://blogs.oracle.com/datawarehousing/entry/serial_plans_threshold_paralle" rel="nofollow">Serial plans: Threshold / Parallel_degree_limit = 1</a> <br /><br />Regarding the online training: From time to time Oracle University will schedule courses with me, some of them are also online.<br /><br />At present, though, there are none scheduled.<br /><br />An alternative would be in-house consulting / workshops, if your company is interested just get in touch with me.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-87369335226770371142013-05-02T05:26:20.703+02:002013-05-02T05:26:20.703+02:00Hi Randolh, I look forward to next week's webi...Hi Randolh, I look forward to next week's webinar. In this webinar, can you address following questions: <br />1 How instance caging in Auto DOP and DBRM env(over-provisioning vs hard partitioning) affects parallel processing?<br />2 With the above env, how to calculate the optimal parallel related parameters? Using 11.2 doc formulas: (?)<br />parallel_max_servers=cpu_count * parallel_threads_per_cpu * concurrent_session * 5 ?<br />parallel_server_target=cpu_count * parallel_threads_per_cpu * concurrent_session * 2 ?<br /><br />3 Do you offer any online training? I have been a big fan of your blogs and webinars. It'd be great to learn from a master like you. <br />Thanks,<br />Amos<br />linyihttps://www.blogger.com/profile/02435276039005662144noreply@blogger.com