Oracle Database Administration
Learn Oracle Database Administration Online
21 February 2018
Tablespace details with Autoextend
›
select t1.tablespace_name, (nvl(t1.Total_size_mb1,0)+nvl(t1.Total_size_mb2,0)+nvl(t1.Total_size_mb3,0)) as tot_size_mb, (nvl(t1.free_spa...
09 December 2016
Shell script to send multiple SQL queries output in HTML format
›
Shell script to send multiple SQL queries output in HTML format shell script content *********************** #!/usr/bin/ksh export ORA...
08 December 2016
Shell script to send SQL query output in HTML format
›
#!/usr/bin/ksh export ORACLE_BASE=/optware/oracle ORACLE_HOME=/optware/oracle/11.2.0.4/db_1 export ORACLE_HOME ORACLE_SID=PROD3 export...
25 August 2016
Identifying Your Oracle Database Software Release
›
Identifying Your Oracle Database Software Release Because Oracle Database continues to evolve and can require maintenance, Oracle period...
28 April 2016
Check, how many times a database has been restarted
›
Can you find out how many times a database has been restarted since its creation? Well, the answer is YES! Oracle has this view dba_hist...
›
Home
View web version
