ADDM reports - Automatic Database Diagnostic Monitor (ADDM)

 ADDM reports:

Every database is scheduled with running ADDM report automatically every 3 hours. this can be changed. We will see that in details from other post.

Now on  a PeopleSoft database I am tuning those SQL's reported in ADDM report. 

then view the recommendations and implement after through review.

oracle user creation and other tables to check roles.

 

   create user <USERNAME> identified by  <PASSWORD>  default tablespace USERS temporary tablespace TEMP profile DEFAULT;

grant CONNECT to <USERNAME>;

grant PSOFT_RO to <USERNAME>;

grant CREATE SESSION to <USERNAME>;

create user <USERNAME> identified by <PASSWORD>;

grant connect , resource, psoft to <USERNAME>;

Misc tables

---------------

select * from dba_role_privs where granted_role ='PSOFT_RO' 

select * from dba_tab_privs where grantee in ('PSOFT_RO','PSOFT_RW');

select * from dba_tab_privs where table_name like '%<TABLE_NAME>';

select * from DBA_SYS_PRIVS  where PRIVILEGE like '%SELECT ANY DICTIONARY%'

select * from dba_role_privs where grantee ='<USERNAME>' 

Curl Useful commands

 Curl is the command line tool that is available in windows command prompt and Linux terminal by default to test connectivity between client and destination.

options to use:

curl -u "username:password" "https://<URL>/PSIGW/RESTListeningConnector/NODE_NAME/Service operation"

Also to find public ip of linux machine , try below command:

curl https://ipinfo.io/ip