Oracle 12c Upgrade: 16 – Resource Manager and Other Performance Enhancements

Card Set Information

Author:
Tralala
ID:
297943
Filename:
Oracle 12c Upgrade: 16 – Resource Manager and Other Performance Enhancements
Updated:
2015-03-09 04:00:42
Tags:
Resource Manager Other Performance Enhancements
Folders:
Oracle 12c Upgrade
Description:
Oracle 12c Upgrade: 16 – Resource Manager and Other Performance Enhancements
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. In a CDB, what does Resource Manager user to control system resource to PDBs?
    • SHARES
    • UTILIZATION LIMITS
  2. What's the difference between a CDB and PDB Resource Plans?
    • CDB resource plan used to allocate a portion of the system’s resources to a
    • specific PDB.
    • PDB resource plan to specify how PDB allocates the resources are allocated within the PDB, this is much like a non-CDB
  3. What procedure is used to specify share values to a PDB?
    DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE
  4. What is the maximum number of PDBs a Resource Plan directive can be applied to?
    One
  5. What resources are controlled in a CDB Resource Plan directive?
    • CPU usage
    • Number of parallel execution servers
  6. If a PDB is plugged into a CDB and there is no Resource Plan directive defined for it, what happens?
    The default directive is used
  7. Three PDBs have one share each and a new PDB is added, how much CPU are each PDB guaranteed before and after the new PDB is added?
    • 33% before (100%/3)
    • 25% after (100%/4)
  8. PDBs 1 and 2 have 3 shares each, PDBs 3, 4 5, 6 1 share each. What is the system resource distribution?
    • 1 and 2 30% (3/10 * 100)
    • 3 4 5 and 6 10% (1/10 * 100)
  9. Which CDB resource plan do PDBs without a resource plan use?
    • The default PDB directive.
    • 1 share
    • No Utilization limit (100%)
    • No Parallel Server Utilization limit (100%)
  10. If for PDB1, the Utilization Limit was 30 and Parallel Server Limit 50, what would this mean?
    • CPU and Parallel server are throttled to 30% and 50% of the maximum respectively
    • What is the SQL to create a CDB Plan Directive?
    • BEGIN
    • DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE(
    • plan => 'newcdb_plan',
    • pluggable_database => 'operpdb',
    • shares => 1,
    • utilization_limit => 20,
    • parallel_server_limit => 30);
    • END;
  11. What are the steps to create a CDB resource plan?
    • Create a pending area
    • Create a CDB resource plan
    • Create the CDB resource plan directives
    • Validate the pending area
    • Submit the pending area
    • Enable the plan
  12. How is a CDB resource plan pending area created?
    exec dbms_resource_manager.create_pending_area();
  13. How is a resource plan pending area validated?
    exec dbms_resource_manager.validate_pending_area();
  14. How is a resource plan pending area submitted?
    exec dbms_resource_manager.submit_pending_area();
  15. How is a CDB resource manage plan enabled?
    ALTER SYSTEM set RESOURCE_MANAGER_PLAN='daytime_plan';
  16. How is a CDB resource manage plan disabled?
    ALTER SYSTEM set RESOURCE_MANAGER_PLAN='';
  17. What are limitations to a PDB plan compared to a non-CDB database?
    • Cannot have a multilevel resource plan
    • Can only have 8 consumer groups (32 for non-CDB)
    • Can't have sub-plans
  18. Which view can be used to review both CDB and PDB resource plans?
    V$RSRC_PLAN
  19. What is the default CDB plan called?
    DEFAULT_CDB_PLAN
  20. To enabling a PDB resource plan, what must happen first?
    Connect to the PDB in question
  21. If a non-CDB with a resource plan is plugged into a CDB, what happens?
    • The plan will work fine so long as meet the requirements for a PDB resource plan ie
    • Cannot have a multilevel resource plan
    • Can only have 8 consumer groups (32 for non-CDB)
    • Can't have sub-plans
  22. What two new parameter does DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE have?
    • SWITCH_TO_LOGICAL
    • SWITCH_ELAPSED_TIME
  23. In DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE what does the new parameter SWITCH_TO_LOGICAL do?
    Sets the number of logical I/Os that will trigger the action specified by the switch_groupparameter
  24. In DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE what does the new parameter SWITCH_ELAPSED_TIME do?
    • The elapsed time that triggers the actions
    • specified by switch_group
  25. Which new meta-consumer group for Resource Manager allows for an argument for switch_group which allows for monitoring but no action to be taken?
    LOG_ONLY
  26. Which new Oracle 12c feature reduces memory usage?
    Multiprocess Multithreaded Unix/Linux Architecture
  27. Which process manages thread creation in Oracle multiprocess multhreaded architecture?
    SCMN
  28. How is Multiprocess Multithreaded Architecture implemented?
    • ALTER SYSTEM SET threaded_execution=TRUE
    • Default is FALSE
    • Requires an instance restart
  29. When Multiprocess Multithreaded Architecture is implemented how must you connect to the database?
    Not using OS authentication, you MUST use a password
  30. In Multiprocess Multithreaded Architecture which processes continue to run as dedicated OS processes?
    • PMON
    • DBWn
    • VKTM - Virtual Keeper of Time
    • PSPn - Process Spawner
  31. Which memory area do Multiprocess Multithreaded Architecture processes use?
    • Same as before
    • PGA for private memory
    • SGA for interprocess communications.
  32. What are the advantages of Multiprocess Multithreaded Architecture?
    • reduce memory
    • reduce cpu usage
    • increase performance for parallel executions
  33. How can one check which processes are threaded or dedicated in Multiprocess Multithreaded Architecture
    • SELECT SPID, STID, PROGRAM FROM V$PROCESS;
    • If only a single STID, the process is dedicated
  34. On which OS does Database Smart Flash Cache run?
    • Solaris
    • OEL
  35. What does the Smart Flash Cache do?
    • A second tier of buffer cache on flash disks to improve performance.
    • When items are aged out of the buffer cache they are loaded into the Smart Flash Cache for quicker reloading
  36. In 12c how many Smart Flash Cache devices are allowed?
    • 16
    • In 11g it was 1
  37. How is Multiple Flash Cache enabled?
    • Define the devices and the size of each device
    • db_flash_cache_file = /dev/raw/sda, /dev/raw/sdb
    • db_flash_cache_size = 32G, 64G
    • Restart the system
  38. How can Multiple Flash Cache be disabled while the system is running?
    • alter system set db_flash_cache_size =0, 0 scope=both;
    • This is done for as many Multiple Flash Cache disks as on system
  39. How is the size of Database Smart Flash Cache changed while the system is running?
    • The size cannot be change dynamically
    • Can only be set to
    • On: The original size from then the instance was started
    • Off: 0
  40. What is DB_FLASH_CACHE_SIZE?
    The size of each file, NOT the total size of the Multiple Flash Cache.

What would you like to do?

Home > Flashcards > Print Preview