... can click a checkbox , hold the ... ... All of the checkboxes between them will ... Database Activities ... of the physical database and to keep ... Run a Shrink in Enterprise Manager to reduce the size of the database . ... Database Backup ... Backup process should place the backup files into a folder other than where the live project database files are located To setup the backup path for the admin database , see KB70320 Then, the backup copy of the database files should be copied to tape Note: Don’t forget to backup your admin database along with all your projects.
Back up the database later on Select the At option and specify the time and date for the backup. To schedule regular backups, select the Repeat every check box and specify a frequency.
The assets can be updated individually or as a group. To change all the assets in a single group, look at the assets from the search results and make sure none of the assets are currently checked out. Click the check box at the top of the search results screen to select all the assets at once. Click the Check Out icon in the toolbar to check them all out.
buffer hit ratio, (must be over 75%): select 'buffer hit ratio',(1 - (select value from V$SYSSTAT where name = 'physical reads') / ( (select value from V$SYSSTAT where name = ' db block gets') + (select value from V$SYSSTAT where name = 'consistent gets') )) from dual ;
