The work conducted by advanced workload is to collect the database statistics and then this data is maintained for certain amount of time and then purged. One is allowed to run the reports against the statistics in order to tune the database for better performance. Other features like database advisors and ADDM applies the statistics to analyse and monitor the database to attend to the performance issues.

The statistics collection through the software is automatic and the data is then stored into database. In order to collect the statistics one needs to set the parameter. The software is able to retain the data for eight days. The upgraded database will follow the AWR retention value that had been set previously set for them.

The AWR is also used for detecting the problems and analysing them for the purpose of self-tuning. There are number of other statistics that are collected with the help of AWR, which includes time model statistics, wait events, various session and system level statistics, active session history statistics, object usage statistics and also the information on the resource intensive SQL statements.

Due to increasing needs to analyses and risk of privacy and data losses AWR is becoming a popular feature that is being used by Oracle as a part of their software system.

At LAISAI technologies we understand the importance of analyse for the organisation and how it can impact the working of the business. Thus, we offer services that can support our clients to assure maximum results.

  • We support installation and management of the system to avoid failures during the working period.

  • Training and consultancy services in regards to the system at also offered at our end.

  • We help the management in analysing the input of the data thus increase the output of the business.

  • The statistical analyse done by the management to introduce changes are also supported at our end.

  • Our services are scattered into different fields including manufacturing, retailing, logistics, distribution, banking and financial services, insurance and health care, public sector, media, entertainment etc.

  • In this technological advanced world we make sure that you are the part of the changes.

  • We also conduct the usage analytics for the clients.

  • Support in setting up storage and file unit level synchronization.