1)Check if Machine is configured in console against Node where Managed Server is running. 2) Check Node Manager IP and port number configured for that Machine. 3)Check firewall and antivirus …
Read More1)Verify java installed. 2) find the required process of PID sing below command can take thread dumb. jstack -l <pid> >> threaddumps.log
Read MoreUsing HPROF: You can use HPROF: Heap and CPU Profiling Agent. A complete dump of the current live objects in the heap can be obtained with: -java -agentlib:hprof=heap=dump,format=b -jar application…
Read MoreHere is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
Read MoreOracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****AhAhpassword-changed*** -d /export/home/oracle/scripts -l /export/home/oracle/scripts/logs -b give-write_ps give-write_ps.sql -u username/password…
Read MoreHere is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_modifications where table_owner<>’SYS’ and EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, ‘DD-MON-RR’)) > 2010 order by 6;…
Read MoreCREATE TABLE AUDIT_DDL ( DDL_DATE date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), IP_ADDRESS VARCHAR2(100), module varchar2(100), owner varchar2(30), type varchar2(30), name varchar2(30), sysevent varchar2(30), sql_txt varchar2(4000) ) tablespace…
Read More