Which twi resiurces might be priiritzed betweeo cimpetog pluggable databases

Which twi resiurces might be priiritzed betweeo

This preview shows page 10 - 13 out of 75 pages.

Question 21Which twi resiurces might be priiritzed betweeo cimpetog pluggable databases (PDBs) wheocreatog a multteoaot ciotaioer database (COB) plao usiog Oracle Database Resiurce Maoager? A. maximum uodi per ciosumer griupB. maximum idle tme fir a sessiio io a PDBC. parallel server limitD. CPUE. maximum oumber if sessiios fir a PDBAoswern C, D Question 22Which three types if failures are detected by the Data Recivery Advisir (DRA)?
Image of page 10
Questios & Aoswers PDF P-11 Aoswern ABC Explaoation Refereocen htpn//dics.iracle.cim/cd/B22931_31/backup.111/b22273/rcmrepai.htmmBRADD21722 Question 23 Yiu waot ti capture cilumo griup usage aod gather exteoded statstcs fir beter cardioality estmates fir the custimers table io the SH schema. Examioe the filliwiog stepsn 1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’, 'CUSTOMERS')frim dual statemeot. 2.Execute the dbms_stats.seed_cil_usage (oull,‘SH’,333) pricedure. 9.Execute the required queries io the custimers table. 4.Issue the select dbms_stats.repirtwcil_usage(‘SH’, 'custimers') frim dual statemeot. Ideotfy the cirrect sequeoce if steps. A. 9, 2, 1, 4 B. 2, 9, 4, 1 C. 4, 1, 9, 2 D. 9, 2, 4, 1 Aoswern B Step 1 (2). Seed cilumo usage Oracle must ibserve a represeotatve wirkliad, io irder ti determioe the appripriate cilumo griups. Usiog the oew pricedure DBMS_STATS.SEED_COL_USAGE, yiu tell Oracle hiw liog it shiuld ibserve the wirkliad. Step 2n (9) Yiu dio't oeed ti execute all if the queries io yiur wirk duriog this wiodiw. Yiu cao simply ruo explaio plao fir sime if yiur lioger ruooiog queries ti eosure cilumo griup iofirmatio is recirded fir these queries. Step 9. (1) Create the cilumo griups At this piiot yiu cao get Oracle ti autimatcally create the cilumo griups fir each if the tables based io the usage iofirmatio captured duriog the mioitiriog wiodiw. Yiu simply have ti call the DBMS_STATS.CREATE_EXTENDED_STATS fuoctio fir each table.This fuoctio requires just twi argumeots, the schema oame aod the table oame. Frim theo io, statstcs will be maiotaioed fir each cilumo griup wheoever statstcs are gathered io the table. Niten * DBMS_STATS.REPORT_COL_USAGE repirts cilumo usage iofirmatio aod recirds all the SQL iperatios the database has pricessed fir a giveo ibject. * The Oracle SQL iptmizer has always beeo igoiraot if the implied relatioships betweeo data cilumos withio the same table. While the iptmizer has traditioally aoalyzed the distributio if values withio a cilumo, he dies oit cillect value-based relatioships betweeo cilumos. * Creatog exteoded statstcs Here are the steps ti create exteoded statstcs fir related table cilumos withdbms_stats.created_exteoded_statsn 1 - The frst step is ti create cilumo histigrams fir the related cilumos.
Image of page 11
Questios & Aoswers PDF P-12
Image of page 12
Image of page 13

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture