Oracle Tips
Par flo|va-nu-pied le lundi, 5 janvier 2009, 14:25 - oracle - Lien permanent
Afficher la version de la base oracle
SQL> SELECT * FROM v$version WHERE banner LIKE 'Oracle%'; BANNER ---------------------------------------------------------------- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
Afficher le temps d'uptime d'une base oracle
SQL> SELECT instance_name,host_name,TO_CHAR(startup_time,'DD-MON-YYY HH:MM:SS AM') FROM v$instance; INSTANCE_NAME ---------------- HOST_NAME ---------------------------------------------------------------- TO_CHAR(STARTUP_TIME,'DD-MON ---------------------------- NOVA as11 05-JAN-009 05:01:42 AM
Derniers commentaires