Oracle AWR Retention period #database #retention #policy, #awr #retention #period


#

AWR Retention period sizing guidelines


Oracle Database Tips by Donald Burleson

For complete details on managing AWR retention and flushing, see Oracle Tuning: The Definitive Reference.

Out of the box, the AWR automatically captures performance metrics every hour. Some internal database operations, such as the Undo Advisor, use AWR data. The Diagnostics Pack does not have to be licensed to collect the metrics or use this advisor. The Diagnostics Pack will have to be licensed to run reports against the AWR, query any dba_hist_* views, use ASH, leverage ADDM, or use the Performance page in Oracle Enterprise Manager, which will be discussed in the next chapter. Using the Diagnostics Pack in Enterprise Manager is often the biggest time saver.

The Automated Workload Repository contains performance metrics gathered once per hour by default and stores the results in the sysaux tablespace. With Oracle RAC databases, the only difference is that the number of instances will linearly scale the AWR data volume. By default, AWR will keep eight days data in the repository. Oracle includes a nice script, $ORACLE_HOME/rdbms/admin/awrinfo.sql, which can help you keep track of the AWR repository sizing.

The output of a sample awrinfo.sql script will be discussed in this section. The first portion of the script output shows some introductory information. Notice the snapshot interval and retention. Oddly, this script is warning that there is a non-default AWR setting but this database is out-of-the-box with no custom AWR configuration.

AWR INFO Report

Report generated at 11:44:21 on Sep 16, 2015 ( Tuesday ) in Timezone -06:00

DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME
———— ——- ————————– —– —————–
* 2793090278 ORCL host01 – Linux x86 64-bit 1 10:12:20 (08/28)

Setting an appropriate retention interval for your AWR is critical for proper data retention, especially for predictive modeling. You can adjust the AWR retention period according to your analysis needs.

Beware that you may want to selectively truncate AWR tables while leaving the major statistics for long-term trend analysis.

In this example the retention period is specified as 3 years (1,576,800 minutes) and the interval between each snapshot is 60 minutes.

retention = 1576800);

Oracle has published suggested storage requirements for AWR based on the activity and complexity of your 10g database:

Here, we choose out approximate database size and see estimated space for the AWR dba_hist tables. Oracle provides the SYSAUX sizing utility called utlsyxsz.sql (in $ORACLE_HOME/rdbms/admin ) for estimating your AWR retention based on disk space consumption.

AWR also supports the creation of AWR baselines , which are a named series of AWR snapshots that are immune from being purged by the AWR retention mechanism. the create_baseline procedure allows you to specify a start_snapshot and end_snapshot and name the baseline:

DBMS_WORKLOAD_REPOSITORY.create_baseline
(1900, 2000, ‘EOY_PEAK_LOADS’);

Note:You must purchase the extra cost Oracle performance pack and Oracle diagnostic packs to use AWR. Else, you can use the free STATSPACK tables which provide almost the same functionality.

The dbms_workload_repository package can be used by Oracle DBAs to configure AWR settings such as snapshot interval, flushing and data retention.

The dbms_workload_repository .modify_snapshot_settings procedure is used to configure AWR data retention in the database. The retention interval determines the length of time that data will be preserved in the AWR. The default setting for retention is 10,080 minutes (one week).

PROCEDURE MODIFY_SNAPSHOT_SETTINGS
Argument Name Type In/Out Default?
—————————— ———– —— ——– RETENTION NUMBER IN DEFAULT INTERVAL NUMBER IN DEFAULT DBID NUMBER IN DEFAULT

The range of valid values for this parameter ranges from ten minutes to 52,560,000 minutes or 100 years.

The dbms_workload_repository package contains the global variables of min_retention and max_retention. These variables set the lower and upper limits for the retention parameter.

If a zero value is specified for retention, snapshots will be stored for an unlimited amount of time. The following awr_settings.sql script can be used to check the current settings for the AWR interval and retention settings:

select
extract( day from snap_interval) *24*60+
extract( hour from snap_interval) *60+
extract( minute from snap_interval ) Snapshot Interval ,
extract( day from retention) *24*60+
extract( hour from retention) *60+
extract( minute from retention ) Retention Interval
from dba_hist_wr_control;

The script returns the current AWR interval values in minutes:

Snapshot Interval Retention Interval
—————– ——————
60 10080

AWR flushing and the MMON background process

The MMON Oracle background process is responsible for periodically flushing the oldest AWR tables, using a LIFO queue method. Here, we see the flush_level for an AWR installation:

SQL desc dbms_workload_repository

PROCEDURE CREATE_SNAPSHOT
Argument Name Type In/Out Default?
—————————— ———————– —— ——–
FLUSH_LEVEL VARCHAR2 IN DEFAULT

FUNCTION CREATE_SNAPSHOT RETURNS NUMBER
Argument Name Type In/Out Default?
—————————— ———————– —— ——–
FLUSH_LEVEL VARCHAR2 IN DEFAULT

The only parameter listed in the procedures is the flush_level. which can have either the default value of TYPICAL or a value of ALL. When the statistics level is set to ALL, the AWR gathers the maximum amount of performance data.

The MMON background process is responsible for removing old historical data from the AWR. The amount of retention time after which data will be removed from database is determined by the retention setting. However, data can be cleared from the AWR tables by using the dbms_workload_repository.drop_snapshot_range procedure. The starting and ending snapshots for the history to be removed from the AWR will need to be set to run the following script:

PROCEDURE DROP_SNAPSHOT_RANGE
Argument Name Type In/Out Default?
—————————— ——————– —— ——–
LOW_SNAP_ID NUMBER IN
HIGH_SNAP_ID NUMBER IN
DBID NUMBER IN DEFAULT

Disabling and enabling automatic AWR flushing

You can disable the AWR automatic data flushing mechanism at either the system level or disable flushing for individual tables.

For system-wide disable of AWR table flushing you can use these commands but beware that the AWR tablespace will continue to grow ad-infinitum:

alter session set events ‘immediate trace name awr_flush_table_off level 99
alter session set events ‘immediate trace name awr_flush_table_off level 106 ;

To return to the default of weekly flushing you can issue these commands:

alter session set events ‘immediate trace name awr_flush_table_on level 99 ;
alter session set events ‘immediate trace name awr_flush_table_on level 106 ;

If you need to disable flushing the run time statistics for an AWR workload table, you can get the underlying WRH tables with this query:

select
table_id_kewrtb,
table_name_kewrtb
from
x$kewrtb
order by
table_id_kewrtb;

Once you identify a specific table to disable flushing, you can use an ALTER SYSTEM command:

alter system set “_awr_disabled_flush_tables”=’ WRH$_IC_CLIENT_STATS’;

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum .

Verifyexperience!Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications .

Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.


The Oracle of Database Support

Copyright 1996 – 2016

All rights reserved by Burleson

Oracle is the registered trademark of Oracle Corporation.


Mortgage Payoff Calculator: Extra Monthly Payments to Pay Off in a Specified Period – Mortgage


#prepayment mortgage calculator

#

Mortgage Payoff Calculator (2c) Extra Monthly Payments to Pay Off in Specified Period Who This Calculator is For: Borrowers who want to know how much extra they must pay, above their required monthly payment, to pay off their loan within a specified period. What This Calculator Does: This calculator shows the additional amount that must be paid on fixed-rate mortgages, above the required monthly payment, to pay off a loan within a specified period. It also displays the amortization schedule and the interest savings

Guiding borrowers to the right decisions
Protecting borrowers from mortgage predators

Want to Shop For a Mortgage on a Level Playing Field?

Then Shop With the Professor and Get His 5 Levels of Protection

  1. Receive His Help in Finding the Type of Mortgage That Best Meets Your Needs
  2. Shop Prices Posted Directly by His Certified Lenders
  3. Shop Prices Fully Adjusted to Your Deal
  4. Shop Prices That Are Always Current AND
  5. Get Him as Your Ombudsman Just in Case

Copyright 2016 The Mortgage Professor


Medicare Eligibility and Enrollment #medicare, #medicare #eligibility, #medicare #enrollment, #eligible #for #medicare, #enroll #in #medicare,


#

Medicare Eligibility and Enrollment

Who can get Medicare. Basically, three gr oups are eligible:

  1. Most people 65 and older.
  2. People younger than 65 who have certain disabilities and illnesses.
  3. People of any age with kidney failure that requires dialysis or a kidney transplant .

You might assume that signing up for a big government program like Medicare would be confusing. But it’s usually easy. Most people are signed up automatically for Original Medicare (Parts A and B).

For People 65 and Older

If you’ re already getting Social Security checks, you will be automatically enrolled in traditional Medicare. You’ll get your Medicare card three months before your 65th birthday. The benefits kick in on the first day of the month of your 65th birthday. Traditional Medicare, which is also called original Medicare, includes Medicare Parts A and B. Part A is hospital coverage. Part B covers doctor visits, lab tests, and other outpatient services.

If you’re not getting Social Security payments already, you have to enroll in Medicare. The Social Security Administration (SSA) handles the enrollment process for Medicare. Call SSA at (800) 772-1213, visit the web site (www.ssa.gov), or apply at your local Social Security office. Apply three months before your 65th birthday. That way, you can be sure that your benefits will start on time.

If you live in Puerto Rico and want Medicare, you need to sign up for Medicare Part B.

Continued

For People With Disabilities and Illnesses

No matter how old you are, if you have Lou Gehrig’s disease. kidney failure, or certain other disabilities, you are eligible for Medicare. But you might have a waiting period before you can get Medicare benefits. Here are the details.

Lou Gehrig’s disease (ALS). As soon as you get Social Security Disability benefits for ALS, you should be automatically enrolled in Medicare. There is no waiting period.

Kidney failure. To qualify, you must have end-stage renal disease and need dialysis or a kidney transplant. Usually, you can’t get Medicare until three months after you start dialysis. Once you’ve been diagnosed with kidney failure, call the Social Security administration at (800) 772-1213 to enroll in Medicare.

Other disabilities for which you get Social Security Disability benefits. You can’t get Medicare until two years after you qualify for Social Security Disability. At that point, the Social Security Administration should sign you up automatically.

If you are not getting Medicare coverage and feel that you should, call the Social Security Administration at (800) 772-1213.

Medicare Enrollment Periods

Medicare limits your ability to add or drop coverage after official enrollment periods. So pay close att ention to Medicare enrollment deadlines. Here are some details:

Initial Enrollment Period. If you are not automatically enrolled, you must sign up during your “initial enrollment period” for Part A with or without Part B. This initial sign-up lasts 7 months, starting 3 months before the month of your 65th birthday and ending 3 months after. During this time, you can sign up for any Medicare coverage you would like. However, if you wait to sign up the month of your birthday or the 3 months that follow, you will have to wait 1 to 3 months for coverage to begin.

Other enrollment periods. If you did not enroll in Parts A and B during the initial enrollment period, you may do so between Jan. 1 and March 31, with coverage beginning in July of that year. You may have to pay a higher monthly premium for covera ge. There are some exceptions. If you are covered under a group health insurance plan through you r job or your spo use’ s job, or if your employment ends after the initial enrollment period, you may enroll in Medicare during a Special Enrollment Period with out having to pay a late-enrollm ent penalty.

Continued

Medicare Advantage Plan (Part C). You may join an advantage plan during the 7-month period when you first become eligible for Medicare. These plans may have more benefits and more coverage. You may join, switch, or drop a Part C plan between Oct. 15 and Dec. 7. You may switch to Original Medicare (Parts A and B) and sign up for a Medicare Prescription Drug Plan between Jan. 1 and Feb. 14.

Medicare Prescription Drug Plans (Part D). You may join, switch, or drop a drug plan between Oct. 15 and Dec. 7. There is an exception: You may join a 5-star Medicare Prescription Drug Plan, as rated by Medicare, any time. But you can only do this once. Go to www.medicare.gov/find-a-plan to see ratings.

What to know about Medicare penalties. If you don’t sign up during your initial enrollment period for some programs — like Medicare Parts A and B and Medicare Prescription Drug Coverage (Part D) — you might pay a higher monthly fee when you sign up later.

There are some exceptions. If you or your spouse have drug coverage now through an employer-based health plan that is as good as Medicare’s or better, you shouldn’t be charged a late penalty as long as you sign up within the deadlines. After insurance from an employer ends, you must sign up for Part B within 8 months and for Part D within 63 days. Keep in mind that an insurance policy from an employer with fewer than 20 employees works differently with Medicare. If you work for a company of that size, you should sign up for Medicare when you are first eligible. You will not incur penalties if you don’t, but without Medicare Part B coverage, you could be without coverage for outpatient services.

Sign up for Medigap early. Medigap is private insurance you buy to help pay for additional Medicare costs. If you need a Medigap plan, you should buy it within 6 months of getting Medicare Part B. During that period, you’re guaranteed to get any Medigap plan you want. But if you try to buy it after those 6 months, the insurance company can charge you a higher price or turn you down altogether.

WebMD Medical Reference Reviewed by Lisa Zamosky on July 23, 2015

Sources

Medicare.gov: ”Medicare You” handbook.


Mortgage Amortization period #30 #mortgage #rates


#amortization mortgage

#

Mortgage Term vs. Amortization

The mortgage payments under scenario B are smaller each month, but the home owner will make monthly payments for 5 additional years. The total interest saved by going with a shorter amortization period exceeds $100,000.

For the savvy investor, these savings should be compared to the opportunity cost of other investments. Using the example above, the monthly savings of $142 under scenario B, could be invested elsewhere, and, depending on the rate of return, could come out ahead after 35 years.

Prepayment privileges set out by your lender will determine whether you can shorten your amortization period, by either increasing your regular monthly payments and/or putting lump sum payments towards the principal, without penalty. However, beyond these privileges, you will often incur costly penalties for making additional payments. According to the Canadian Association of Mortgage Professionals, 24% of Canadians took advantage of prepayment options in 2009.

Popularity of mortgage term and amortization periods

A 5-year mortgage term, at 66% of all mortgages, is by far the most common duration. A further breakdown shows that an additional 8% of mortgages have terms exceeding five years, while 26% of mortgages have shorter terms, including 6% with one year or less and 20% with terms from one year to less than four years.

Type of purchase 2 .

The most common mortgage amortization period, on the other hand, is 25 years. However, 42% of new mortgages had amortization periods exceeding 25 years. This is an interesting observation considering amortization periods were only extended to 35 years in 2006.1 As of July 9th 2012, the maximum amortization period on all CMHC insured homes will be reduced from 30 to 25 years.

References and Notes

  1. Source: Canadian Association of Accredited Mortgage Professionals (CAAMP) Fall 2010 Consumer Report
  2. Source: Canadian Association of Accredited Mortgage Professionals (CAAMP) Fall 2010 Consumer Report

500,000
Canadians a month

Save money and make better financial decisions using RateHub.ca

Join our weekly newsletter for tips, news and deals!

By submitting your email address, you are agreeing to RateHub.ca’s Privacy Policy and Terms and Conditions


Mortgage Amortization period #best #mortgage #rate


#amortization mortgage

#

Mortgage Term vs. Amortization

The mortgage payments under scenario B are smaller each month, but the home owner will make monthly payments for 5 additional years. The total interest saved by going with a shorter amortization period exceeds $100,000.

For the savvy investor, these savings should be compared to the opportunity cost of other investments. Using the example above, the monthly savings of $142 under scenario B, could be invested elsewhere, and, depending on the rate of return, could come out ahead after 35 years.

Prepayment privileges set out by your lender will determine whether you can shorten your amortization period, by either increasing your regular monthly payments and/or putting lump sum payments towards the principal, without penalty. However, beyond these privileges, you will often incur costly penalties for making additional payments. According to the Canadian Association of Mortgage Professionals, 24% of Canadians took advantage of prepayment options in 2009.

Popularity of mortgage term and amortization periods

A 5-year mortgage term, at 66% of all mortgages, is by far the most common duration. A further breakdown shows that an additional 8% of mortgages have terms exceeding five years, while 26% of mortgages have shorter terms, including 6% with one year or less and 20% with terms from one year to less than four years.

Type of purchase 2 .

The most common mortgage amortization period, on the other hand, is 25 years. However, 42% of new mortgages had amortization periods exceeding 25 years. This is an interesting observation considering amortization periods were only extended to 35 years in 2006.1 As of July 9th 2012, the maximum amortization period on all CMHC insured homes will be reduced from 30 to 25 years.

References and Notes

  1. Source: Canadian Association of Accredited Mortgage Professionals (CAAMP) Fall 2010 Consumer Report
  2. Source: Canadian Association of Accredited Mortgage Professionals (CAAMP) Fall 2010 Consumer Report

500,000
Canadians a month

Save money and make better financial decisions using RateHub.ca

Join our weekly newsletter for tips, news and deals!

By submitting your email address, you are agreeing to RateHub.ca’s Privacy Policy and Terms and Conditions


Types of Structured Settlement Payments #structured #settlement #payment, #types #of #structured #settlement #payments, #tfss, #treasury


Designing Your Structured Settlement: What Benefit Streams are Possible?

What are the options for structured settlement benefit payments?

Structured settlement payment options are many and can address the unique and particular financial needs of any Plaintiff or Payee. The table below shows the types of customizable cash flows can be paid directly to a Plaintiff or Payee, to a trust (such as a settlement preservation trust, special needs trust, pour over trust, Medicare Set Aside trust, memorial fund, scholarship fund, or other recovery management trust). A structured settlement can be designed to incorporate one or more of these types of cash flows in a single contract. If desired, Payments can be made by ACH or electronic funds transfer, directly to the bank account of the Plaintiff, Payee, law firm or attorney ( if attorney fees are being structured).

Income for Life Annuities

that provide lifetime guaranteed structured settlement income and maintain the Plaintiff or Payee’s current standard of living. Depending on the annuity issuer, structured settlement payments may be made weekly, bi-weekly, monthly, quarterly, semi-annually, annually, every other year, temporary life or other payment modes. A death benefit (also known as a certain period or guarantee period) can be associated with the payments so that benefits will be paid for the certain period whether or not the Payee survives the entire payment schedule. For example a quote of $4,000 per month for life with 30 years certain means that payments will continue for 30 years (360 months) or the life of the Payee, whichever is longer.

Deferred Lump-Sum Payments

that can be made at pre-determined time periods for special funding needs such as college education, future medical costs, retirement planning, reinvestment and as a hedge against inflation. Lump sums can be guaranteed (most common) or life contingent.

provide structured settlement income that incorporates graduated increases over the initial payment amount for a fixed period and/or lifetime.

Percentage Increase Annuities

like Step Annuities, provide graduated increases over the initial payment amount by using a fixed percentage to provide annually increasing income as a protection against inflation.

Index Linked Structured Settlements

Future periodic payments will increase annually based on positive changes in the Standard & Poors 500 (S ?>

Health care in Canada #insurance #waiting #period, #health; #health #care #in #canada


#

Health care in Canada

Canada s universal health-care system

All Canadian citizens and permanent residents may apply for public health insurance. When you have it, you do not pay for most health-care services as health care is paid for through taxes. When you use public health-care services, you must show your health insurance card to the hospital or medical clinic.

Each province and territory has their own health insurance plan. Make sure you know what your plan covers.

All provinces and territories will provide free emergency medical services, even if you do not have a government health card. Restrictions may apply depending on your immigration status. If you have an emergency, go to the nearest hospital. If you go to a walk-in clinic in a province or territory where you are not a resident, you might be charged a fee.

Waiting period to get public health insurance

Residents in some provinces must wait a certain period (up to three months) before receiving government health insurance (contact your provincial or territorial ministry of health to know how long you will need to wait). Make sure you have private health insurance to cover your health-care needs during this waiting period.

Getting a health card

To get health care in Canada, you will need a health insurance card from the province or territory where you live. You must show this card each time you get medical services. Learn more about how to get a health card .

Provincial and territorial ministries of health

Extra health insurance

Government health insurance plans give you access to basic medical services. You may also need private insurance to pay for things that government plans do not fully cover.

The most common types of plans are extended health plans. These cover costs for:

  • prescription medications
  • dental care
  • physiotherapy
  • ambulance services
  • prescription eyeglasses

If you work, you may get extra coverage from the company or organization you work for.

Health coverage for protected persons or refugee claimants

In some cases, the Interim Federal Health Program (IFHP) provides temporary health insurance to refugees, protected persons, refugee claimants and their dependents until they become eligible for provincial or territorial, or private health plan coverage.

Also in this topic


Mortgage Payoff Calculator: Extra Monthly Payments to Pay Off in a Specified Period – Mortgage


#prepayment mortgage calculator

#

Mortgage Payoff Calculator (2c) Extra Monthly Payments to Pay Off in Specified Period Who This Calculator is For: Borrowers who want to know how much extra they must pay, above their required monthly payment, to pay off their loan within a specified period. What This Calculator Does: This calculator shows the additional amount that must be paid on fixed-rate mortgages, above the required monthly payment, to pay off a loan within a specified period. It also displays the amortization schedule and the interest savings

Guiding borrowers to the right decisions
Protecting borrowers from mortgage predators

Want to Shop For a Mortgage on a Level Playing Field?

Then Shop With the Professor and Get His 5 Levels of Protection

  1. Receive His Help in Finding the Type of Mortgage That Best Meets Your Needs
  2. Shop Prices Posted Directly by His Certified Lenders
  3. Shop Prices Fully Adjusted to Your Deal
  4. Shop Prices That Are Always Current AND
  5. Get Him as Your Ombudsman Just in Case

Copyright 2016 The Mortgage Professor


Mortgage Payoff Calculator: Extra Monthly Payments to Pay Off in a Specified Period – Mortgage


#prepayment mortgage calculator

#

Mortgage Payoff Calculator (2c) Extra Monthly Payments to Pay Off in Specified Period Who This Calculator is For: Borrowers who want to know how much extra they must pay, above their required monthly payment, to pay off their loan within a specified period. What This Calculator Does: This calculator shows the additional amount that must be paid on fixed-rate mortgages, above the required monthly payment, to pay off a loan within a specified period. It also displays the amortization schedule and the interest savings

Guiding borrowers to the right decisions
Protecting borrowers from mortgage predators

Want to Shop For a Mortgage on a Level Playing Field?

Then Shop With the Professor and Get His 5 Levels of Protection

  1. Receive His Help in Finding the Type of Mortgage That Best Meets Your Needs
  2. Shop Prices Posted Directly by His Certified Lenders
  3. Shop Prices Fully Adjusted to Your Deal
  4. Shop Prices That Are Always Current AND
  5. Get Him as Your Ombudsman Just in Case

Copyright 2016 The Mortgage Professor


Mortgage Payoff Calculator: Extra Monthly Payments to Pay Off in a Specified Period – Mortgage


#prepayment mortgage calculator

#

Mortgage Payoff Calculator (2c) Extra Monthly Payments to Pay Off in Specified Period Who This Calculator is For: Borrowers who want to know how much extra they must pay, above their required monthly payment, to pay off their loan within a specified period. What This Calculator Does: This calculator shows the additional amount that must be paid on fixed-rate mortgages, above the required monthly payment, to pay off a loan within a specified period. It also displays the amortization schedule and the interest savings

Guiding borrowers to the right decisions
Protecting borrowers from mortgage predators

Want to Shop For a Mortgage on a Level Playing Field?

Then Shop With the Professor and Get His 5 Levels of Protection

  1. Receive His Help in Finding the Type of Mortgage That Best Meets Your Needs
  2. Shop Prices Posted Directly by His Certified Lenders
  3. Shop Prices Fully Adjusted to Your Deal
  4. Shop Prices That Are Always Current AND
  5. Get Him as Your Ombudsman Just in Case

Copyright 2016 The Mortgage Professor