Saturday, January 08, 2011

CPU utilization on linux



To find out processes, which have exceeded CPU utilization threshold on the server.

In the example,

a) CPU utilization of java processes are checked. You may replace it for any other process.

b) Also, input the threshold value

Wednesday, January 05, 2011

Query on Dynamic View is slow ( v$ views)

 QUERY PERFORMANCE SLOW FOR V$ VIEWS


PROBLEM:
--------
Query performance containing v$ views (v$sql, v$session) are slow as compared
to same query using RULE hints.

Monday, January 03, 2011

ADR_BASE_LISTENER for listener log adn trace files



ADR_BASE_LISTENER directory

To Change the adr directory for listener from default
Make Changes in listener.ora file
 e.g. ADR_BASE_LISTENER = /oralog/oracle

example:
/oralog/oracle/oradiag_oracle/diag/clients/user_oracle/

Hope this helps. Regards Rupam

Tuesday, December 21, 2010

Flashback table

The table could be restored to using flashback table option. Before attempting it, find out how far to flash the table.

Steps :-

1. sql> select count(*) from scott.emp;

2.  export of the table 

3. flashback table

sql> alter table scott.emp enable row movement;
sql> flashback table scott.emp to timestamp
       to_timestamp('2010-12-18 12:00:00','YYYY-MM-DD HH24:MI:SS');
      
Flashback complete.

4. sql> select count(*) from scott.emp;

  COUNT(*)
----------
    784871

5. confirm with apps team

Hope this helps! Regards Rupam


Saturday, December 18, 2010

Windows - Find space usage by windows folders using diruse

Directory Disk Usage, known as diruse is a free command line tool found on Microsoft's Help . Using diruse is easy. After you have downloaded the tool, install by clicking on diruse_setup.exe.
After installing the program, open a command prompt and run:
cd "\Program Files\Resource Kit"
diruse /M /* c:\
where:
/M – reports in Magabytes
/*  – Uses the top-level directories residing in the specified directory (In the above example C:\ is the specifed directory)
Below is the results of the output: