111 reputation
2
bio website
location New Mexico
age
visits member for 2 years, 9 months
seen Aug 25 at 1:37

Aug
25
comment oracle<sid> (LOCAL=NO)
This is a guess - you had processes connect from apps like backup software( Tivoli, CommVault, RMAN). The apps had problems and bailed leaving disconnected processes.
Jun
5
comment Are there tips for writing Oracle DDL Triggers for auditing? Or should I just use AUDIT?
Generally this is not really doable because ddl does not always generate events. - but here is along discussion on Ask Tom about ddl triggers. Please read on to the bottom to get modern db information: asktom.oracle.com/pls/asktom/…
May
24
comment Is shrink a safe online operation?
Nice answer +1 @David Aldridge
Jul
25
awarded  Teacher
Apr
25
answered Changing TimeZone of an Oracle Database
Apr
25
comment Changing TimeZone of an Oracle Database
What do you mean - go to daylight time, or move from something like GMT to something remote like US Mountain. Dates in Oracle are stored as seconds since Jan 1 4712 BCE, and are subsequently translated into whatever TZ you want. Usually oracle uses the servers' TZ.
Dec
28
awarded  Supporter