Search

Top 60 Oracle Blogs

Recent comments

Growth

Industry Experts and Pro Bloggers Come Together to Inspire, Teach, and Help You (and Your Site) Succeed

At the Official WordPress.com Growth Summit, the two-day virtual conference running twice from August 11-13, you’ll have access to about 50 speakers and presenters across 90+ breakout sessions and keynote conversations. The varied lineup will appeal to new and established bloggers; professionals in tech, media, and marketing; and anyone ready to build or expand their presence on the web.

Quick history on database growth

AWR collects segment statistics, and this can be used to quickly understand an abnormal database growth. Here is a script I use to get, from the AWR history, the segments that have grown by more than 1% of the database size, in one hour.

First I must mention that this uses only the part of AWR which is not subject to additional option. This even works in Standard Edition:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access string NONE