Which three are true about Smart Flash log?
A.
I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for
different databases.
B.
LGWR will not wait for writes to Smart Flash log if the write to a disk based logfile completes
first.
C.
Smart Flash Log is enabled by default, using 1024 MB of Rash storage on each storage server.
D.
You can remove Smart Flash Log from a single storage server with the drop flashing command.
E.
I/O Manager category plans can be used to enable or disable Smart Flash LogFor different I/O
categories.
Explanation:
A:the Exadata I/O Resource Manager (IORM) has been enhanced to enable or
disable Smart Flash Logging for the different databases running on the Database Machine.
B: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do
parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash
hardware. When either of these writes has successfully completed the database will beimmediately notified of completion. If the disk drives hosting the logs experience slow response
times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times
(e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better
database performance.
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one
category plan can be enabled at a time
Incorrect:
Not C:By default, 512 MB of the Exadata flash is allocated to Smart Flash Logging
ABD
A. is right. IORM DB plan can be used to enable/disable flash cache and flash log for individual database
B. is right. LGWR will continue which ever one done first. usually is flash log. but not necessary
C. is wrong. flash log is NOT enabled by default. 512MB size by default if created
D. is right. flash log can be created or not created by cell
E. is wrong. IORM DB plah, not category plan enable/disable flash log
so A.B.D. are correct
I agree, but the command to remove the flash log on a single cell is:
“drop flash log” not “drop flashing”…
“You can use the “Drop flash log” cell command to turn this feature off.”
ABD … if mat and L. Zhu both … then there is a 99% probability that it’s true