.

Performance Hub active report enables to view all performance data available for a specified time period. Different tabs are available in the Performance Hub, depending on whether real-time or historical data is selected for the time period. When real-time data is selected, more granular data is presented, because real-time data for the last hour is displayed. When historical data is selected, more detailed data is presented, but the data points are averaged out to the Automatic Workload Repository (AWR) interval for the selected time period. To generate a Performance Hub active report 1.         At the SQL prompt, enter: Sql> @$ORACLE_HOME/rdbms/admin/perfhubrpt.sql 2.         Specify the desired report type:         Please enter report type: typical 3.         Enter the value for the database identifier of the database you wan...

To extract AWR data: 1.     At the SQL prompt, enter:         SQL> @$ORACLE_HOME/rdbms/admin/awrextr.sql 2.     Specify the database from which AWR data will be extracted:         Enter value for db_id: 1377863381 3.     Specify the number of days for which you want to list snapshot IDs.         Enter value for num_days: 2 4.     Define the range of snapshots for which AWR data will be extracted by specifying a beginning and ending snapshot ID:         Enter value for begin_snap: 30         Enter value for end_snap: 40 5.     Specify the directory object pointing to the directory where the export dump file will be stored:         Enter value for directory_...

LSNRCTL> command [listener_name] lsnrctl @file_name  #to execute in batch mode. REM or # to identify comments in the batch script Listener.ora file parameters: ·          PASSWORDS_listener_name  #an unencrypted password ·          LSNRCTL> change_password #to establish an encrypted password ·          LSNRCTL> SAVE_CONFIG  #Any changes are stored in listener.ora ·          LSNRCTL> SET PASSWORD  #If a password is set, then issue SET PASSWORD command before changing the password. Use the command SET PASSWORD prior to privileged Listener Control utility commands ·          Reload : the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subseque...