Unix Addiction

1.-Set proxy with user and password if you have proxy with authentication or without it #export https_proxy=https://sun:sun@192.168.100.100:8080 #export http_proxy=http://sun:sun@192.168.2.100.100:8080 2.- Set publisher in order to use the Oracle Support Repository #pkg set-publisher -k  /var/pkg/ssl/pkg.oracle.com.key.pem -c /var/pkg/ssl/pkg.oracle.com.certificate.pem -g https://pkg.oracle.com/solaris/support/  solaris 3.-You can search the packages availables in my case I need to install JAVA 8 #pkg search -p java PACKAGE                                                                 PUBLISHER pkg:/SUNWj6cfg@1.6.0.999.99                                             solaris pkg:/SUNWj6dev@1.6.0.999.99                                             solaris pkg:/SUNWj6dmo@1.6.0.999.99                                             solaris pkg:/SUNWj6dmx@1.6.0.999.99                                             solaris pkg:/SUNWj6dvx@1.6.0.999.99         

WITH sql_app_waits AS     (SELECT sql_id, SUBSTR(sql_text, 1, 80) sql_text,             application_wait_time/1000 app_time_ms,             elapsed_time,             ROUND(application_wait_time * 100 /                 elapsed_time, 2) app_time_pct,             ROUND(application_wait_time * 100 /                 SUM(application_wait_time) OVER (), 2) pct_of_app_time,             RANK() OVER (ORDER BY application_wait_Time DESC) ranking        FROM v$sql       WHERE elapsed_time > 0         AND application_wait_time>0 ) SELECT sql_text, app_time_ms, app_time_pct,        pct_of_app_time, ranking FROM sql_app_waits WHERE ranking <= 20 ORDER BY ranking asc ; SQL_TEXT APP_TIME_MS APP_TIME_PCT PCT_OF_APP_TIME RANKING SELECT * FROM "NRIV" WHERE "CLIENT"=:A0 AND "OBJECT"=:A1 AND "SUBOBJECT"=:A2 AND 1.059.603 95 58 1 SELECT * FROM "TBTCO" WHERE "JOBNAME&q