find / -size +1G -mtime +180 -type f -print

getent passwd | grep oracle getent passwd | grep dba

prompt ====================================== prompt ANALYZE – DATE – REGULAR TABLES prompt ====================================== col owner format a20 prompt select [...]

Script for check all the enabled auditing on Database –Check the parameter is enabled or disable for Audit select name || ‘=’ || value PARAMETER from sys.v_$parameter where name [...]

SELECT b.request_id, a.user_concurrent_program_name, b.phase_code AS completed, b.status_code AS error, u.user_name requestor, TO_CHAR (b.actual_start_date, ‘MM/DD/YY HH24:MI:SS’) [...]

Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v   Go to reports path Then type: – string -a APXAPRVL.rdf|grep Header Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java [...]

— — Displays Last Analyzed Details for a given Schema. (All schema owners if ‘ALL’ specified). —   SET PAUSE ON SET PAUSE ‘Press Return to Continue’ [...]

Simply installing Java 1.5 from Sun is the easiest way to get the newest Java and Java Web Start. Windows: To get 1.5, go to the Java 1.5 website. Just go through the install process and tell it [...]

After cloning EBS R12 successfully, when I am going to login EBS clone it did not show anything on the page. Login page is totally blank. I have restarted all the services of application and [...]

DECLARE v_session_id INTEGER := userenv(‘sessionid’); v_user_name VARCHAR2(30) := upper(‘&Enter_User_Name’); BEGIN fnd_user_pkg.createuser(x_user_name => [...]