CRITICAL SKILL 9.9
Use SQL Aggregate and Analysis Functions
Once your database has been loaded with data, your users or applications will, of course, want to use that data to run queries, perform analysis, produce reports, extract data, and so forth. Oracle Database 10g provides many sophisticated aggregation and analysis functions that can help ease the pain sometimes associated with analyzing data in large databases.
Progress Check Answers
1. The Global Cache Service (or Cache Fusion) connects the nodes to the shared storage.
2. The existing data is automatically redistributed among all disks in the disk group.
3. False. The database instance communicates with the ASM instance to determine which ASM files to access directly. Only the ASM instance ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
