CHG0000094
| Summary | |||
|---|---|---|---|
| Number: | CHG0000094 | Approval: | Requested |
| Type: | Normal | State: | Authorize |
| Category: | Network | Configuration item: | SAP ORA01 |
| Impact: | 2 - Medium | Phase: | |
| Urgency: | 3 - Low | Risk: | High |
| Priority: | 2 - High | Closed at: | |
| Short description: | Increase db_block_buffers from 5000 to 7500 | ||
| Reason: | |||
| Parties & Schedule | |||
| Assigned to: | David Loo | ||
| Start date: | 2020-02-17 12:30:00 | ||
| End date: | 2020-02-17 13:00:00 | ||
Description
The database size has increased and the cache hit rate is at the low end of an acceptable rate. The Database team needss to increase the amount of memory allocated to the Oracle SGA to increase the cache hit rate.
Change Plans
Backout Plan
rollback to existing db_block_buffer setting
Test Plan
Implementation Plan
vi initSAPORA01.ora
yank and put existing db_block_buffers line
Comment out existing db_block_buffers setting
Set new db_block_buffers line to 7500
Restart SAPORA01 database instance
- parent
- reason
- watch_list
- upon_reject
- cancel
- sys_updated_on
- 2019-11-23 08:54:03
- type
- normal
- approval_history
- number
- CHG0000094
- test_plan
- cab_delegate
- requested_by_date
- state
- -3
- sys_created_by
- admin
- knowledge
- false
- order
- phase
- cmdb_ci
- SAP ORA01
- my_cmdb_ci
- SAP ORA01
- my_cmdb_ci_link
- Cmdb.3a72d947c0a8ce0100a7a64397fdcd53
- delivery_plan
- contract
- impact
- 2
- active
- true
- work_notes_list
- priority
- 2
- sys_domain_path
- /
- cab_recommendation
- production_system
- false
- review_date
- business_duration
- group_list
- requested_by
- System Administrator
- my_requested_by
- System Administrator
- my_requested_by_link
- SysUser.6816f79cc0a8016401c5a33be04be441
- change_plan
- approval_set
- implementation_plan
- vi initSAPORA01.ora\nyank and put existing db_block_buffers line\nComment out existing db_block_buffers setting\nSet new db_block_buffers line to 7500\nRestart SAPORA01 database instance
- end_date
- 2020-02-17 13:00:00
- short_description
- Increase db_block_buffers from 5000 to 7500
- correlation_display
- delivery_task
- work_start
- 2019-11-22 09:48:27
- additional_assignee_list
- outside_maintenance_schedule
- false
- std_change_producer_version
- service_offering
- sys_class_name
- change_request
- closed_by
- follow_up
- reassignment_count
- 0
- review_status
- assigned_to
- David Loo
- my_assigned_to
- David Loo
- my_assigned_to_link
- SysUser.5137153cc611227c000bbd1bd8cd2007
- start_date
- 2020-02-17 12:30:00
- sla_due
- comments_and_work_notes
- escalation
- 0
- upon_approval
- proceed
- correlation_id
- made_sla
- true
- backout_plan
- rollback to existing db_block_buffer setting
- conflict_status
- Conflict
- sys_updated_by
- admin
- opened_by
- System Administrator
- my_opened_by
- System Administrator
- my_opened_by_link
- SysUser.6816f79cc0a8016401c5a33be04be441
- user_input
- sys_created_on
- 2019-11-20 08:21:37
- on_hold_task
- closed_at
- review_comments
- business_service
- time_worked
- expected_start
- opened_at
- 2019-11-20 08:21:37
- work_end
- phase_state
- open
- cab_date
- work_notes
- close_code
- assignment_group
- Hardware
- my_assignment_group
- Hardware
- my_assignment_group_link
- SysUserGroup.8a5055c9c61122780043563ef53438e3
- description
- The database size has increased and the cache hit rate is at the low end of an acceptable rate. The Database team needss to increase the amount of memory allocated to the Oracle SGA to increase the cache hit rate.
- on_hold_reason
- calendar_duration
- close_notes
- sys_id
- 66cdf552db252200a6a2b31be0b8f559
- contact_type
- cab_required
- false
- urgency
- 3
- scope
- 3
- company
- justification
- activity_due
- comments
- approval
- requested
- due_date
- sys_mod_count
- 23
- on_hold
- false
- sys_tags
- conflict_last_run
- 2019-11-23 08:54:03
- unauthorized
- false
- location
- risk
- 2
- category
- Network
- risk_impact_analysis
- my_sys_class_name_link
- ChangeRequest.66cdf552db252200a6a2b31be0b8f559