All is said in the post title, Oracle has launched a wiki.
This official public oracle wiki will permit to share content, information dealing with oracle technologies, with a very collaboratively tool, just try it [Oracle's WiKi]
If you’d like to log the result from a sql script, just prepare your sql script like that:spool result.log
SET SERVEROUTPUT ON
select * from dual;
spool off
exit
Then from a command line or a script shell execute the following command:
# sqlplus user/pwd@db_name @script.sql
You’d like to have a post or a tutorial about linux (redhat, fedora) Oracle (database, 10g, RAC or OAS – oracle application suite), Nagios, Cacti,…
Feel free to ask and i’ll try to answer to your question.
Leave a comment with your question.
Because i didn’t find it quickly, i’d just want to publish this very useful link to publish this access to the Certify – Oracle’s Certification Matrices:
http://www.oracle.com/technology/support/metalink/index.html
—°°°—
Une petite info pratique que je souhaite publié parce que je ne l’ai pas trouvé rapidemment. Voici le lien pour acceder aux matrices de compatibilté Oracle:
http://www.oracle.com/technology/support/metalink/index.html
If you’d like to know how big your DB is:
select FILE_NAME, d.TABLESPACE_NAME, d.BYTES datafile_size, nvl(sum(e.BYTES),0) bytes_used, round(nvl(sum(e.BYTES),0) / (d.BYTES), 4) * 100 percent_used, d.BYTES - nvl(sum(e.BYTES),0) bytes_free from DBA_EXTENTS e, DBA_DATA_FILES d where d.FILE_ID = e.FILE_ID (+) group by FILE_NAME,d.TABLESPACE_NAME, d.FILE_ID, d.BYTES, STATUS order by d.TABLESPACE_NAME,d.FILE_ID