Oracle Cloud Total Cost of ownership Calculator – rather confusing

I was interested enough to try out the Oracle  TCO calculator that I was sent an email about. I can honestly say it has rather confused me in what it is comparing and how the results are calculated.

I will share a few screen shots and I will take you through my thoughts

I put a dummy company name in and my country – bizarrely it does not auto select the currency.

I then hit (more...)

12C Grid – GENO process causes high CPU usage

This is an interesting bug which has affected a number of our databases  – perhaps because we are not patched to the latest levels in every case.
The MoS note is this one – Patch 20373598: GEN0 TIMEOUT ACTION ALWAYS TRY TO INITIALIZE OCR CONTENT    p20373598_121022_Linux-x86-64
OR
fixed in Bug 22291127  12.1.0.2.160419 (Apr 2016) Database Patch Set Update (DB PSU)
Here is view of top showing how a server looks (more...)

Creating a database link using a tnsnames entry

I have had this in my draft posts for a couple of weeks and I refrained from publishing because it was too simple.

However the main purpose of this post is to help others save time by providing useful information. The secondary purpose of to remind myself how I overcame whatever problem is being covered.

A user did not have permissions to edit the tnsnames.ora file on a server so I created the database (more...)

ORA-01450: maximum key length (3800) exceeded

This is an oddity as essentially I have an index on a table but I cannot rebuild it because it suggests the block size should be bigger than 8K – however both the database and tablespace block size are 16K already.

The maximum allowed index key length depends on your block size. So the minimum allowed size reported in ORA-01450 varies, depending on which block size your index is using:

ORA-01450 maximum key length (758) (more...)

How to add a metric extension and use a ‘control’ table to test results

I have previously blogged about creating a User Defined Metric (UDM) before  (7 years ago!)  but the method I am using today demonstrates how you can test out the alert using specific data.

The aim was to see if integration data is flowing through a table.  If there is a backlog we want to know about it.

Simon Ryan, a colleague did all the preparatory work and created all the 18 !! screen shots (more...)

DBA vacancy Bradford, West Yorkshire

I have a vacancy in my team and the details are in the link below

https://apply.morrisons.jobs/vacancies/2137/technology-specialist–database.html

Lots of interesting work going including 85Tb Data Warehouse on Exadata and developing Cloud capability using AWS and Google.

 


Baselines – session creating privs v session running privs

A colleague Richard Wilkinson was telling me about an issue he had come across with baselines and I asked him to write it up as it was an interesting experience.

The following MERGE SQL runs once a day. It always uses the same plan and roughly takes between 30 and 80 minutes:

SQL_ID/ PHV 6zs5dk6t6pkfs / 3064471754

 MERGE INTO DWB_X_PLNGRM_ATTR_DAY t
 USING (
 SELECT ilv.bsns_unit_cd,
 ilv.sku_item_nbr,
 ilv.cntnt_cd ,
 ilv.sel_units_cntnt_status,
 ilv.plngrm_item_grp_cd,
  (more...)

Managing the WINDOW_ID in Goldengate V11.2.1.0.33

When we import data into the landing schema on a Dat Warehouse via Goldengate, we add 3 fields to each record detailing when and how the record got loaded. This can be found in the *.inc files under $GG_HOME/dirinc on the target GG installation. An example of this is:
map xxx.DBA_GGCUTOVER_TEST, TARGET YYY.DBA_GGCUTOVER_TEST,  INSERTALLRECORDS, IGNOREDELETES
COLMAP (
USEDEFAULTS,
WINDOW_ID = @STRCAT(@GETENV(“RECORD”, “FILESEQNO”), @STRNUM(@GETENV(“RECORD”, “FILERBA”), RIGHTZERO, 10)),
OPER_TYPE = @GETENV (“GGHEADER”, “OPTYPE”),
CDC_LOAD_TIMESTAMP= (more...)

HP Systems Management vacancy

I know I do not have the right readership on this blog for a Systems Management vacancy but if any readers have colleagues who have experience using any of HP Openview, OpsBridge, HP Service Management and HP UCMDB then I have a vacancy at our Head Office in Bradford for a permanent position

Details below

https://apply.morrisons.jobs/vacancies/491/technology-specialist–system-management.html


Using DataGuard broker to show apply lag and throughput

To determine how much lag there is I normally run a script similar to this

select sequence#, applied, to_date(to_char(first_time,’DD-MON-YY:HH24:MI:SS’),
‘DD-MON-YY:HH24:MI:SS’) “First Time” ,
to_char(next_time,’DD-MON-YY:HH24:MI:SS’) “Next Time”
from v$archived_log
UNION
select NULL,database_role,NULL, db_unique_name from v$database
order by “First Time”;

However there is another way which I sometime use which actually gives a lot more information. This uses the dataguard broker command line. Use the show configuration parameter to determine database name if you are not sure

 (more...)