Oracle: monitor import session

Importing data from one database to another is a useful feature in oracle. But this takes time so its a good thing to know you progress.Here is a cool script that you can use to monitor your import session:

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_minute
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;

I know that i have not yet written about how to use the export and import in oracle(i will be explaining it very soon). But for guys who already using the import method this might be helpful .=ELK=

iPhone, Gphone....NOPHONE

After Apple introduce the iPhone every one started to speculate that google is going to introduce its own version of mobile phone the Gphone. well to tell you the truth i was also excite about the Gphone, but for every ones disappointment Google announced that its not the Gphone this time, its the Android. The first truly open and comprehensive platform for mobile devices....[Link]

Microsoft Visual Studio 2008

Microsoft announces it is committed to releasing Visual Studio 2008 by the end of this month. With it you can await the new .Net Framework 3.5 technology, mean time you can download the beta version from this website....[Link]

iPhone firmware 1.1.2

iPhone firmware 1.1.2 reviewed by T3...[Link]

Open Social Application Hacked

Every one was excited about the google open social application. But within 45 Minutes it was hacked...[Link]

Fedora 8 a.k.a Werewolf (PICS)

In less the two weeks another great OS will be out. Take a sneak peak at the final release of Fedora 8 GNOME desktop, and also the KDE version of Fedora 8....[Link]

Google OpenSocial API

Check this out guys. Google announces the OpenSocial API, which will allow developers to create Facebook like apps on any social network site....[Link]