2 Şubat 2011 Çarşamba

Solaris: How To Disable/Enable Desktop GUI

To disable the GUI on startup, run the following command:
/usr/dt/bin/dtconfig -d

Restart the system using init 6 and you will see that GUI will no longer start automatically.

To enable it again, use the following command:
/usr/dt/bin/dtconfig -e

You may just want to start desktop manager without enabling it. Use the following command to start desktop manager, without restarting Solaris:
/etc/init.d/dtlogin start

8 Ocak 2011 Cumartesi

When is my table last analyzed?

Following query shows the latest analysis time of tables in Oracle:

SELECT distinct stattype_locked, table_name, last_analyzed
FROM dba_tab_statistics 
WHERE owner = 'HR' order by last_analyzed desc;