Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...: Continuing with the 12.1.0.2 non-RAC MultiTenant environment and two services demonstrated earlier , I have restarted the environment to...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Hemant's Oracle DBA Blog: Services -- 4 : Using the SERVICE_NAMES parame...

Hemant's Oracle DBA Blog: Services -- 4 : Using the SERVICE_NAMES parame...: In my previous blog post, I have demonstrated using DBMS_SERVICE to create and start services. But there is another way.  Using the SERV...

Hemant's Oracle DBA Blog: Services -- 3 : Monitoring Usage of Custom Ser...

Hemant's Oracle DBA Blog: Services -- 3 : Monitoring Usage of Custom Ser...: In my previous blog post, I had demonstrated a few custom services created and started with DBMS_SERVICE. Let's look at a couple of ...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...: Continuing with the 12.1.0.2 non-RAC MultiTenant environment and two services demonstrated earlier , I have restarted the environment to...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Jaffar's (Mr RAC) Oracle blog: Wanna become an OCM? Go on read out Kamran's new O...

Jaffar's (Mr RAC) Oracle blog: Wanna become an OCM? Go on read out Kamran's new O...: When I first heard about Kamran's new book, OCM practical guide, I said wow, because I was thinking on the same line a few years back, ...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...: Ok, this is my third post in a series of predictive analytics for Essbase/Planning.  In the first one, “ Essbase Meets R ”, I described...

Hemant's Oracle DBA Blog: TRUNCATEing a Table makes an UNUSABLE Index VALID ...

Hemant's Oracle DBA Blog: TRUNCATEing a Table makes an UNUSABLE Index VALID ...: Here's something I learned from Jonathan Lewis sometime ago. If you set an Index to be UNUSABLE but later issue a TRUNCATE TABLE, the...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...: This is never a fun topic, is it? With the caveat that IANAL nor am I the guy that actually signs the contract nor do I work for Oracle,...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...: This is never a fun topic, is it? With the caveat that IANAL nor am I the guy that actually signs the contract nor do I work for Oracle,...

Hemant's Oracle DBA Blog: SQL*Net Message Waits

Hemant's Oracle DBA Blog: SQL*Net Message Waits: Here are some extracts from an 11.2.0.4 AWR Report  I ran a simulated workload on this server for about 40minutes and generated this report...

Hemant's Oracle DBA Blog: Undo and Redo

Hemant's Oracle DBA Blog: Undo and Redo: Quick and Rough Notes : Undo and Redo Undo is where Oracle logs how to reverse a transaction (one or more DMLs in a transaction) Red...

Hemant's Oracle DBA Blog: Obj# and DataObj# in 12c AWR

Hemant's Oracle DBA Blog: Obj# and DataObj# in 12c AWR: The 12c AWR Report section on Segment Statistics now reports both Obj# (OBJECT_ID) and DataObj# (DATA_OBJECT_ID).  This is useful informati...