In 11gR2 Oracle integrated time synchronization with the Grid Infra software itself, with the Cluster Time Synchronization Service (ctssd). Previously you used ntp or another form of time synch, and I had installed 11gR2 GI…

  • oracle ctss ntp cluster

I started working with Oracle database in late 2006. It's 2014 now, which is roughly 7 and a half years later, and I am still finding things about Oracle that have totally demolished any pre-conceived…

  • oracle , scn

Well they wouldn't really be 'hidden parameters' if they were out in plain sight right? Right? (crickets). Anyway, hidden parameters won't be available through a show parameter or from v$parameter, but can be selected…

  • oracle , hidden parameters

I recently came upon Arup Nanda's series on performance tuning, and it contains some really good info especially for someone like me who hasn't really done any tuning for day-to-day performance issues. The first article…

  • oracle , blocking , database , v$session