Managing Storage Space and Table Space

Managing Storage Space and Table Space

Instruction for Managing Storage Space and Tablespace Project must be done in Microsoft Imagine and Microsoft Visio software, oracle 11g, read all instructions very carefully. Make sure you follow the scoring guide very carefully. Make sur the writer follow instructions very carefully.
Assessment Instructions

Managing Storage Space and Tablespace
Create scripts, a conceptual data model, and a paper focused around storage space, tablespace management, and compression.
Assessment Instructions
Base this assessment on your own database model for a business purpose at an organization of your choice. You may use the database model you created in another assessment, or you may choose to create a new database to work with. Optimal performance has been a growing concern for the organization as the database has not been tuned in some time.
Preparation
Research the following in preparation for this assessment:
• How to modify the system global area and program global area.
• How to create, modify, and drop tablespaces.
• How to use compression within Oracle.
• Segment Advisor and Shrink Segment Options.
You may use the suggested resources or other scholarly and professional resources from your independent research to learn more about these topics.
Directions
For this assessment, complete the following:
• Modify the system global area and program global area to be increased.
• Purge the recycle bin.
• Create a script to replicate a table using compression.
• Create a script to create, modify, and drop the tablespaces explaining each statement.
• Devise a strategy to compact data and deal with fragmented space using Segment Advisor and Shrink Segment Options.
• Create a conceptual data model of the database using Visio to create a visualization for how it should be organized within the database within its tablespace in relation to the other schemas within the database.
Once you have completed your script, conceptual model, and analysis, create a walkthrough document for the admin and developers in which you will address the following:
• Modify the system global area and program global area.
• Purge objects from the database.
• Construct functional SQL to create and load table data with compressed content.
• Explain the statements that are used to create, modify, and drop tablespaces.
• Explain the usage of Segment Advisor and Shrink Segment Options.
• Create a conceptual data model with the visualization of the tablespace within its environment.
• Communicate in writing that is clear and free from errors that detract from the overall message.
Provide screenshots of your steps modifying the SGA, PGA, purging the recycle bin, replicating the table, and creating, modifying, and dropping the tablespaces.

Managing Storage Space and Tablespace Scoring Guide
Managing Storage Space and Tablespace Scoring Guide
CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED
Explain the statements that are used to create, modify, and drop tablespaces. Does not explain the statements that are used to create, drop, and modify tablespaces. Explains the statements that are used to create, drop, and modify tablespaces, but the explanation lacks details or options. Explains the statements that are used to create, modify, and drop tablespaces. Explains the statements that are used to create, modify, and drop tablespaces, providing detailed examples and documentation.
Explain the usage of Segment Advisor and Shrink Segment Options. Does not define the usage of Segment Advisor and Shrink Segment Options Defines the usage of the Segment Advisor and Shrink Segment Options, but the definition is missing detail and/or steps. Explains the usage of Segment Advisor and Shrink Segment Options. Explains the usage of Segment Advisor and Shrink Segment Options and describes industry best practices.
Create a conceptual data model with the visualization of the tablespace within its environment. Does not create a conceptual data model with the visualization of the tablespace within its environment. Creates a conceptual data model with the visualization of the tablespace within its environment, but the model lacks detail. Creates a conceptual data model with the visualization of the tablespace within its environment. Creates a conceptual data model with the visualization of the tablespace within its environment, providing detailed information related to the organizational business rules.
Modify the system global area and program global area. Does not modify the system global area and program global area. Modifies system global area and program global area, but there are still errors unresolved. Modifies the system global area and program global area. Modifies the system global area and program global area using best practices and providing examples and documentation of each step.
Purge objects from the database. Does not purge objects from the database. Purges objects from the database but incorrect steps are completed. Purges objects from the database. Purges objects from the database, providing examples and documentation of each step performed optimally.
Construct functional SQL to create and load table data with compressed content. Does not construct functional SQL to create and load table data with compressed content. Constructs functional SQL to create and load table data with compressed content, but some settings are incorrect. Constructs functional SQL to create and load table data with compressed content. Constructs functional SQL to create and load table data with compressed content and provides examples and documentation of each step performed optimally.
Communicate in writing that is clear and free from errors that detract from the overall message.Communicates in writing that is neither clear nor free from errors that detract from the overall message. Communicates in writing that is vague or includes errors that detract from the overall message. Communicates in writing that is clear and free from errors that detract from the overall message. Communicates in writing that is clear, well-organized, and free of grammatical errors.

find the cost of your paper