Skip to content
Vinod Surendran

Vinod Surendran

Programmer, Photographer, Human

Menu
  • About
Menu
  • About

Month: May 2009

Immediate Shutdown in Windows

Immediate Shutdown in Windows

Posted on May 31, 2009 by Vinod Surendran

Usually windows will take 30 to  2 mins to shutdown the system .. Here is a tip that will give us the power to shutdown immediate a windows system . “Just like switching off a bulb” To do this , open the task mananger by pressing CTRL+ALT+DEL . Then Click on the shutdown menu .. […]

Posted in Tips and Tricks, WindowsTagged Tips and Tricks, Windows1 Comment on Immediate Shutdown in Windows
Personas For Firefox

Personas For Firefox

Posted on May 17, 2009May 17, 2009 by Vinod Surendran

The new face of application theming , personas . You can change the style what ever you like at any time . no need to restart the firefox. And the best news is “NO NEED To RESTART .. 🙂 ” You can get personas from here http://getpersonas.com

Posted in Tips and TricksTagged firefoxLeave a Comment on Personas For Firefox
How to export sequences  using sql

How to export sequences using sql

Posted on May 14, 2009May 14, 2009 by Vinod Surendran

Normally sequences are not exported if we give partial export. For such cases we can use sql to generate quries for sequence droping and creating select ‘drop sequence ‘||sequence_name||’;’ from user_sequences where sequence_name like’SEQ_DB%’; select ‘create sequence ‘||sequence_name|| ‘ minvalue ‘|| MIN_VALUE || ‘ maxvalue ‘|| MAX_VALUE || ‘ start with ‘||last_number|| ‘ increment by […]

Posted in OracleTagged Oracle2 Comments on How to export sequences using sql
How to track queries in oracle ..

How to track queries in oracle ..

Posted on May 14, 2009May 14, 2009 by Vinod Surendran

In Oracle there is a easy way to track the current queries processed by the database. Suppose you want to track the Insert queries in your DB . then for that use this query select substr(sql_text,instr(sql_text,’INTO “‘),30) table_name, rows_processed, round((sysdate-to_date(first_load_time,’yyyy-mm-dd hh24:mi:ss’))*24*60,1) minutes, trunc(rows_processed/((sysdate-to_date(first_load_time,’yyyy-mm-dd hh24:mi:ss’))*24*60)) rows_per_min from   sys.v_$sqlarea where  sql_text like ‘INSERT %INTO “%‘ and  command_type […]

Posted in OracleTagged Oracle1 Comment on How to track queries in oracle ..
How to Get the Locked Tables List In Oracle

How to Get the Locked Tables List In Oracle

Posted on May 14, 2009May 14, 2009 by Vinod Surendran

Here is the query to get the locked tables in oracle SELECT l.inst_id,SUBSTR(L.ORACLE_USERNAME,1,8) ORA_USER, SUBSTR(L.SESSION_ID,1,3) SID, S.serial#, SUBSTR(O.OWNER||’.’||O.OBJECT_NAME,1,40) OBJECT, P.SPID OS_PID, DECODE(L.LOCKED_MODE, 0,’NONE’, 1,’NULL’, 2,’ROW SHARE’, 3,’ROW EXCLUSIVE’, 4,’SHARE’, 5,’SHARE ROW EXCLUSIVE’, 6,’EXCLUSIVE’, NULL) LOCK_MODE FROM sys.GV_$LOCKED_OBJECT L, DBA_OBJECTS O, sys.GV_$SESSION S, sys.GV_$PROCESS P WHERE L.OBJECT_ID = O.OBJECT_ID and l.inst_id = s.inst_id AND L.SESSION_ID = […]

Posted in OracleTagged Oracle3 Comments on How to Get the Locked Tables List In Oracle
How to get the TableSpace usage in Oracle

How to get the TableSpace usage in Oracle

Posted on May 14, 2009May 14, 2009 by Vinod Surendran

Table Space Usage in Oracle

Posted in OracleTagged Oracle3 Comments on How to get the TableSpace usage in Oracle

Recent Posts

  • Windows Terminal April 24, 2020
  • Eureka and AWS ECS May 2, 2019
  • Build your nodeJS Application in a modular way October 26, 2017
  • JWT – Security with Simplicity March 31, 2017

Recent Comments

  • Vinod Surendran on Build your nodeJS Application in a modular way
  • Bruce on Build your nodeJS Application in a modular way
  • Sujesh on My experiments with IoT – “Meeting with Pi”
  • Hostgator 1 cent coupon on How to get the TableSpace usage in Oracle
  • hostgator vps coupon code on How to get the TableSpace usage in Oracle

Tags

android android applications applications Arduino asianet dataline butteryfly chrome evdo Experiments firefox General google Hello World HTC Htc legend Ideas industry IOT Legend Linux linux ubuntu login microservice Mobile modem movie player Netflix node nodeJS NPM one click Oracle personal photo Raspberry Pi rooting script Scripts story Tips and Tricks tweaks ubuntu unix Update Windows

Archives

Categories

  • Android (4)
  • General (24)
    • Status Updates (8)
  • IoT (1)
  • Linux (4)
  • Microservice (1)
  • Mobile (5)
  • nodeJS (1)
  • Oracle (4)
  • Photography (1)
  • Tips and Tricks (3)
  • Windows (2)

Tags

android android applications applications Arduino asianet dataline butteryfly chrome evdo Experiments firefox General google Hello World HTC Htc legend Ideas industry IOT Legend Linux linux ubuntu login microservice Mobile modem movie player Netflix node nodeJS NPM one click Oracle personal photo Raspberry Pi rooting script Scripts story Tips and Tricks tweaks ubuntu unix Update Windows

History

  • April 2020 (1)
  • May 2019 (1)
  • October 2017 (1)
  • March 2017 (2)
  • February 2017 (2)
  • January 2017 (2)
  • July 2015 (1)
  • July 2014 (3)
  • January 2013 (4)
  • October 2011 (1)
  • September 2011 (1)
  • May 2011 (2)
  • December 2010 (4)
  • August 2010 (2)
  • July 2010 (1)
  • June 2010 (2)
  • May 2010 (2)
  • April 2010 (4)
  • December 2009 (2)
  • July 2009 (1)
  • May 2009 (6)

Categories

  • Android (4)
  • General (24)
    • Status Updates (8)
  • IoT (1)
  • Linux (4)
  • Microservice (1)
  • Mobile (5)
  • nodeJS (1)
  • Oracle (4)
  • Photography (1)
  • Tips and Tricks (3)
  • Windows (2)
Theme Design & Developed By OpenSumo
  • About