Popular Posts

Tuesday, March 11, 2008

How To Check Oracle Database Uptime

How To Check Oracle Database Uptime.

To check Oracle Database uptime execute the following:

SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
FROM sys.v_$instance;

Or for better format:

SELECT to_char(logon_time,'Dy dd Mon HH24:MI:SS') "DB Startup Time"
FROM sys.v_$session
WHERE sid=1 /* this is pmon */

How to View/Extract Oracle view definition in Oracle Database

How to View/Extract Oracle view definition in Oracle Database. Oracle Database 9i 10g 11g

SQL> set long 10000

SQL>select text from dba_views where view_name like "YOUR_VIEW_NAME"

dba_views holds the definition of the view.

Alternative (and better) way is to use GET_DDL() function of metadata package DBMS_METADATA.

select DBMS_METADATA.GET_DDL('Object_Type','Object_name ','owner') for example:

SQL>set long 10000

Apple iphone 1.1.4 update error ""Slide for Emergency"

Apple iphone 1.1.4 update error ""Slide for Emergency".

Updating your iphone to Release 1.1.4 may lock your phone in "recovery" mode. My iphone was updated with Rel. 1.1.4, finished updating rebooted and stuck with the message "Slide for Emergency" in several languages. There is nothing you can do at this point since everything is disabled. Calling to Apple support revealed that they have no idea on how to help you in this situation, rebooting your phone is pointless at this time.

Here are the proven remedies that I compiled:

1. Switch your USB ports
2. Unistall iTunes and clean Windows registry using regedit.exe of all Apple and iTunes enties
3. Connect your iphone to a different PC (or MAC) with iTunes that will resynch and restart you iphone.

If everything fails

4. Download ZIPphone utilities from for your Release. DO NOT select to "unlock" your phone, simply go to "Advanced Features" tab and click on "Normal Mode" button. That action will exit your phone from the "recovery mode".

Good luck and remember just like with the database upgrades – always have backup.

Friday, March 07, 2008

How to Calculate Oracle Table Size

How to Calculate/Compute Oracle Table Size:

segment_name table_name,
sum(bytes)/(1024*1024) table_size
segment_name = 'YOUR_TABLE_NAME'
group by segment_name