Posts by Marimuthu Pandu

How to generate heap dump in weblogic using hprof

Using 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 More

How to find PID using port on windows.

netstat -a -n -o | find “port number”

Read More

How to change Oracle Database NLS DATE FORMAT

Here is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile

Read More

How to Run sql statements in all PDBS

Oracle 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 More

How to find last modified table in oracle.

Here 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 More

How to catch DDL statements oracle database.

CREATE 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