If you plan to upgrade from one version of Oracle Database to another, uninstall QSA first. After the new Oracle database is installed, reinstall the server and the QSA agent.
When upgrading Oracle
The Space Manager Repository is used to store object and tablespace lists and statistics. This information is used in reports, in reorg need calculations, and to display in the Explorer. Space Manager updates the Repository daily, by default. However, you can modify the schedule at which the Repository Update job runs.
Tip: The Repository Update job is listed in the Script/Job Monitor. You can access the script execution log from the Job Monitor window.
To Set or Modify Repository Update Schedule
In the Schedule Task dialog, select the frequency with which you want to update the Repository: daily, weekly or monthly. Click Next.
Note: The default is Daily.
Tips:
Demonstration data consists of objects and tablespaces that suffer from the space-use problems found in a typical database. You can use the data to learn how Space Manager detects and resolves these problems.
After you resolve problems, you can refresh demonstration data. This restores its original condition.
Note Demonstration data functions are only enabled for DBAs. They are disabled for users who do not have the DBA role.
You can install or refresh demonstration data at any time. The data requires 20 MB or 24 MB of disk space, depending on the database block size. The demonstration user is created when you install demonstration data. This user is the owner of all demonstration objects.
CAUTION: When demonstration data is uninstalled or refreshed, all objects owned by the demonstration user are dropped. To avoid losing objects, do not create objects under the demonstration user’s name.
Note: When you install server components, you have the option to install demonstration data at the time.
To install or refresh demonstration data
Uninstalling demo data removes demonstration tablespaces and objects, and the demonstration user. Datafiles for the two demonstration tablespaces must be removed manually from the database server.
CAUTION: When demonstration data is uninstalled or refreshed, all objects owned by the demonstration user are dropped. To avoid losing objects, do not create objects under the demonstration user’s name.
If demonstration tablespaces contain objects that are not owned by the demonstration user, relocate these objects before uninstalling demonstration data. Demonstration tablespaces and objects are not removed if demo tablespaces contain objects that are owned by a user other than the demo user.
Note When you unintall server components, demonstration data is automatically uninstalled along with the components.
To uninstall demo data
The Install Analysis Option function can be used to install analysis packages if they were not installed along with server components. When analysis packages are missing, you are prompted to install them by statistics-collection functions.
To install analysis packages
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center