Delphix Engines expose all features via a stable WEB API built on top of HTTP and JSON.
Clients choose an HTTP client to interact with Delphix and integrate within their environment.
Delphix Engines are bundled with a command line interface which guides users for automation and integration with third party tools.
Delphix CLI example
Adding a SQL Server Source Environment:
Enter these commands through the command line interface:
Oracle have given birth to VirtualBox 4.3.14. Mother and baby are doing well, with the downloads and changelog in the usual places.
was first posted on July 16, 2014 at 2:23 pm.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
In case you are planning to perform any upgrades with DBUA, double-check that the init.ora parameters after the upgrade. In a production upgrade at a client site, dbua silently changed init.ora parameter NLS_TERRITORY from GERMANY to AMERICA. It was only noticed when after the upgrade, decimal and grouping number characters were swapped, leading to application problem.
Support had to admit that it is unpublished bug 16538186 and that there is NO documentation of (more...)
The July Oracle Critical Patch has been released. This includes patches for Database Product Suite, Fusion Middleware Product Suite, Exalogic, and Enterprise Manager Suite Critical Patch Updates and Patch Set Updates. It includes 113 new security , 5 Oracle Database and a host of other bug fixes. More about the July 2014 Critical Patch Update […]
The post Oracle Critical Patch Update Advisory – July 2014 appeared first on VitalSoftTech.
July 15, 2014 Extensively Researched with Detailed Analysis Covering a Broad Range of Oracle Database Performance Topics, Providing Insight that is Not Available from Other Sources http://www.amazon.com/Troubleshooting-Oracle-Performance-Christian-Antognini/dp/143025758X/ I pre-ordered this book in December 2013, having previously read the first edition of this book twice. Once the printed copy of the second edition book arrived, I ordered […]
In my Configuring Highly Available BI Publisher in EM 22.214.171.124 post, I covered how you configured BI Publisher in a highly available environment. When BI Publisher is configured, by default only the super-administrator accounts you have defined in your EM12c environment have access to the tool. That means that none of your normal administrator level […]
How does Delphix benefit a SAP project?
- Speed up time to delivery for ASAP implementation methodology
- Enable adoption of “Continuous Application Delivery” methodology
- Reduce infrastructure overhead
- Deliver higher quality projects
ASAP methodology is a framework for delivering large IT projects. SAP professionals are familiar with this, however given the size and complexity of SAP projects, many fail to fully adopt it. Delphix helps customers adopt and use ASAP methodology.
SAP Projects today are big, hairy beasts. They (more...)
Exadata is a powerful system, able to provide exceptional performance. Much of this peformance is due to Smart Scans, Exadata’s mechanism for shifting the workload to the storage cells and having them filter and reduce the amount of data the database servers must process. Not every Smart Scan that starts ends up completing, though. Oracle may decide that a different path, one that doesn’t include a Smart Scan, may be more efficient. Certain conditions must (more...)
Oracle DBA Training Options Are Changing
Training options for Oracle Database DBAs are changing. Generally, I don't think they are for the better. Companies don't value Oracle Database Administrators like they used to. And, it shows in the lack of their professional development investment.
When I travel a long way from home, I tend to get very reflective about life, death and beyond. On my way home from teaching an onsite two-day Oracle performance tuning (more...)
The below article useful to know about asm spfile and How asm instance started if spfile in diskgroup without mount.
This article he explained for normal redundancy . If you want to find the spfile on external redundancy level, you can use below command
[oracle@asmoracle ~]$ asmcmd lsdsk -G DATA
[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK1 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 1450 ; (more...)
What a cracking Oracle Midlands event!
The evening started with a session on “Designing Efficient SQL” by Jonathan Lewis. The first few slides prompted this tweet.
When someone asks me a question about SQL tuning my heart sinks. It’s part of my job and I can do it, but I find it really hard to communicate what I’m doing. Jonathan’s explanation during this session was probably the best one I’ve ever heard. Rather than trying (more...)
I was recently reading a blog entry by Dominic Brooks regarding auditing and I was intrigued by the line referring to the audit_trail parameter being set to DB, EXTENDED
Behaves the same as AUDIT_TRAIL=DB, but also populates the SQL bind and SQL text CLOB-type columns of the SYS.AUD$ table, when available.
Nothing wrong with that and straight from the manual but I was surprised that they were CLOBS. However on looking at them they (more...)
I’ve been lucky enough to present at various conferences, seminars and user group events over the years in some 20 odd countries. But somewhere I’ve never quite managed to present at before is the place of my birth, the UK. Well this year, I’ve decided end my drought and submitted a number of papers for the UKOUG Tech14 Conference and […]
Normally, when I create physical standby database, the configuration has the same directory structures and name values as production with the exception of db_unique_name.
But this time was not the case as shown below.
ANGEL:(SYS@xmenstby):PHYSICAL STANDBY> show parameter name
NAME TYPE VALUE
------------------------- ----------- ----------------------------------------
db_file_name_convert string /oradata/xmenprod, /oradata/xmenstby
db_name string xmenprod
db_unique_name string angel_xmenstby
global_names boolean FALSE
instance_name string xmenstby
log_file_name_convert string /oradata/xmenprod, /oradata/xmenstby
service_names string xmenstby
I’ve been asked the same question by multiple people, around what books by what authors are good to have, so let me answer it once here. :) The answer is easy – it depends! Are you interested in database administration? Application development against an Oracle database? Technical apps? Functional apps? High Availability? Enterprise Manager? No […]
I use fio for all my I/O testing. Why not Orion from Oracle since almost all of my I/O testing and benchmarking has been geared toward Oracle? Several reasons
- super flexible – able to configure it for almost all types of test
- active community – updates almost every week, many by Jens Axobe (who wrote much of the Linux I/O layer)
- reliable – if there are problems, it’s open source and one can (more...)
A common criticism of PLSQL is that the "original" array datatype, now called associative arrays are perfect for passing stuff back and forth to 3GL environments (for example .Net), but canno be used within SQL natively, for example:
SQL> create or replace
2 package BLAH is
3 type num_list is table of number index by pls_integer;
4 type str_list is table of varchar2(30) index by pls_integer;
6 procedure ODP_PROC(n out num_list, s out str_list);
A rather odd performance issue happened at work a few days ago. All of a sudden, one of the databases started to work very slowly, and a quick look in ASH data showed that it was spending over 70% of its time waiting on “row cache lock” (not to be confused with “latch: row cache lock”).
It was a test database (126.96.36.199) on an overloaded server with non-standard configuratioin, so my initial reaction (more...)
A few weeks ago we upgraded one of our production server, adding another CPU tray. This brought the number of CPU cores from 80 to 160, and took us from 2Tb of RAM to 4Tb (just in time for Oracle to announce the in-memory database in 188.8.131.52!).
However when I went to start things up, ASM wasn't starting up, giving me these errors:ORA-04031: unable to allocate 32 bytes of shared (more...)