Loading...

Follow Durham Oracle on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Daily / Hourly archive log generation scripts - very handy. Daily Archive Log Generation : select trunc(COMPLETION_TIME,'DD') Day, ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Column output in SQL Plus Adding for reference. Link to http://www.adp-gmbh.ch/ora/sqlplus/column.html column [SQL*Plus ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Strange error on starting one of our databases today - why oracle can't just say the recovery file destination is 100% full I have no idea ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The Linux ss command has proved very useful, it is used to dump socket statistics. Something I have only come across very recently.Shows ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Currently being asked to look after more and more SQL Server boxes so with a couple of hours spare thought I would build SQL Server on ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Good old Microsoft - somebody has finally seen the light. I have thought this for a very long time.Password-expiration-is-dead-long-live- ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Quick tip - thanks to Russell Willcox for this one :)See also : http://www.dba-oracle.com/t_connecting_hung_instance_using_prelim_option ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Very simple example to check sqlbind variable (will update as I go on - work in progress).SQL > variable TABLSPC varchar2(50);SQL> ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Built a response file for a two node rac database; amend as appropriate.This is mainly for my reference.  dbca -silent \-responseFile ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
This is very useful :Snapper and this  SQLd360, SQL diagnostics collection made fasterGreat site on how to use the tuning advisor :https ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview