Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

Parallelizing Table Functions

Moving functions into the paradigm of SELECT statements allows them to take advantage of another powerful facet of Oracle—parallel query processing.

Oracle has long provided parallelism as a way to conquer large queries by splitting processing among multiple Parallel Query (PQ) servers, using each to calculate a portion of the results, then assembling a final result set at the end. Behind the scenes, Oracle decides how to distribute the work across the available PQ servers to get the best results. The DBA can influence Oracle’s decision somewhat by setting degrees of parallelism for tables or implementing specific partitioning schemes, but, in the end, the database decides how best to execute the query.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page