- Primary task of smart flash cache is to hold frequently accessed data in flash cache so next time if same data required than physical read can be avoided by reading the data from flash cache.
- Exadata caching mechanism focuses on caching frequently accessed data and index block with performance critical information like control file and file headers.
- Also we can influence caching priorities by using CELL_FLASH_CACHE storage attribute for specific database objects
What will be cached ?
- Frequently accessed data
- Index Block
- File header reads and writes
- Control file reads and writes
- DBA can set the caching priority
What will be not cached?
- Backup related I/O
- Database pump I/O
- Data file formatting
- I/O to mirror copies
- Table scan don't control the cache
- What is cell disk ?
- What is grid disk ?
- What is IORM ?
- What are the ways to migrate on Exadata ?
- Procedure to drop cell disk on Exadata.
- What is cellsrv and how it works ?
- Use of cellsrv service on Exadata storage cell.
- What is iDB protocol ?
- What is the purpose to use Exacheck tool ?
- What is the oswatcher and how it works ?
- What is RS services and how it works ?
- How to enable HCC on database table ?
- How many networks are available on Exadata ?
- How we can integrate OEM12c with Exadata ?
- What are the ways to install OEM12c agent on Exadata ?
- Which cell services are running on Exadata storage cell ?
- Purpose of MS(management service) on storage cell.
- How cell storage software backup happens ?
- Which OS supports by Exadata ?
- How to power off Exadata Machine ?
- How to do maintainance on Cell Storage and DB server?
- What is writet-through caching mode ?
- What is Write-back caching mode ?
- Explain the procedure to drop the Cell storage ?
- How to replace physical storage disk on cell storage ?
Get Questions and Answers HERE.....
You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.
