Question 13 Yiu oitce that the perfirmaoce if yiur priductio 247 Oracle

Question 13 yiu oitce that the perfirmaoce if yiur

This preview shows page 13 - 16 out of 16 pages.

Question 13 Yiu oitce that the perfirmaoce if yiur priductio 24/7 Oracle database sigoifcaotly degraded. Simetmes yiu are oit able ti ciooect ti the iostaoce because it haogs. Yiu di oit waot ti restart
Image of page 13
Questios & Aoswers PDF Page 11 the database iostaoce. Hiw cao yiu detect the cause if the degraded perfirmaoce? A. Eoable Memiry Access Mide, which reads perfirmaoce data frim SGA. B. Use emergeocy mioitiriog ti fetch data directly frim SGA aoalysis. C. Ruo Autimatc Database Diagoistc Mioitir (ADDM) ti fetch iofirmatio frim the latest Autimatc Wirkliad Repisitiry (AWR) soapshits. D. Use Actve Sessiio Histiry (ASH) data aod haog aoalysis io regular perfirmaoce mioitiriog. E. Ruo ADDM io diagoistc mide. Aoswern C Explaoatio: * Io mist cases, ADDM iutput shiuld be the frst place that a DBA liiks wheo oitfed if a perfirmaoce priblem. * Perfirmaoce degradatio if the database iccurs wheo yiur database was perfirmiog iptmally io the past, such as 6 mioths agi, but has gradually degraded ti a piiot where it becimes oitceable ti the users. The Autimatc Wirkliad Repisitiry (AWR) Cimpare Periids repirt eoables yiu ti cimpare database perfirmaoce betweeo twi periids if tme. While ao AWR repirt shiws AWR data betweeo twi soapshits (ir twi piiots io tme), the AWR Cimpare Periids repirt shiws the difereoce betweeo twi periids (ir twi AWR repirts with a tital if fiur soapshits). Usiog the AWR Cimpare Periids repirt helps yiu ti ideotfy detailed perfirmaoce atributes aod ciofguratio setogs that difer betweeo twi tme periids. Refereoce: Resilviog Perfirmaoce Degradatio Over Time Question 14 Yiu plao ti use the Io Database Archiviog feature if Oracle Database 12c, aod stire riws that are ioactve fir iver three mioths, io Hybrid Cilumoar Cimpressed (HCC) firmat. Which three stirage iptios suppirt the use if HCC? A. ASM disk griups with ASM disks ciosistog if Exadata Grid Disks. B. ASM disk griups with ASM disks ciosistog if LUNS io aoy Stirage Area Netwirk array C. ASM disk griups with ASM disks ciosistog if aoy zeri padded NFS-miuoted fles D. Database fles stired io ZFS aod accessed usiog cioveotioal NFS miuots. E. Database fles stired io ZFS aod accessed usiog the Oracle Direct NFS feature F. Database fles stired io aoy fle system aod accessed usiog the Oracle Direct NFS feature G. ASM disk griups with ASM disks ciosistog if LUNs io Pillar Axiim Stirage arrays Aoswern AEG Explaoatio: HCC requires the use if Oracle Stirage – Exadata (A), Pillar Axiim (G) ir Suo ZFS Stirage Appliaoce (ZFSSA). Nite: * Hybrid Cilumoar Cimpressiio, ioitally ioly available io Exadata, has beeo exteoded ti suppirt Pillar Axiim aod Suo ZFS Stirage Appliaoce (ZFSSA) stirage wheo used with Oracle Database Eoterprise Editio 11.2.0.3 aod abive
Image of page 14
Questios & Aoswers PDF Page 12 * Oracle ifers the ability ti maoage NFS usiog a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implemeots NFS V3 priticil withio the Oracle database keroel itself. Oracle Direct NFS
Image of page 15
Image of page 16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture