What is SQL Tuning Health Check? The SQL Tuning Health Check is provided by Oracle (Doc ID 1366133.1) in order to check the environment where the problematic SQL query runs. It checks the statistics, the metadata, initialization parameters and other elements that may influence the performance of the SQL being analyzed. The script generates an [...]
Before we begin, take a look at my previous two blog posts, SaltStack for Remote Parallel Execution of Commands and Using SaltStack for Configuration Management.
This blog post is the second in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. Today’s post will be about creating certificates.
At this step, we will create and upload a certificate. This certificate will be used to authenticate the VPN clients and are performed in few steps:
A cool wintery day in late 1989. This kid’s working for the Office of the Auditor General of Canada. I’d been working with Oracle and in my fourth year. I had cut my teeth on 220.127.116.11.4 after first seeing V3 some four years prior. I stumbled across a well-placed ad for a show happening in Anaheim USA in September 1990. I’ve got the bug. I apply to go to the show and was told by my employer ,”Just a sec, David and I were thinking of going to that show – let us get back to you.” Some three weeks I am told it’s a go.
You want a checkbox item on a page which is a preference, you want it to be remembered for the user across login sessions, but you don’t want the overhead of storing it in a database table. You might choose to store the value in a cookie instead. It may be lost (e.g. when the user clears their cookies or changes to a different browser or another computer), but we don’t mind – it’s just a preference.
People ask me to justify use of Delphix. I can understand. Delphix is pretty new and often, most of my friends who are DBAs respond with “I can copy a database, so what, I can do it a little faster with Delphix.” Well that’s missing the whole boat. The question won’t be why you should use Delphix but “can you justify working without Delphix?”
I see Delphix as amazingly positioned at nexus of data concerns right now – the right place at the right time :
We have recently underwent the Oracle Exalogic Virtual ECHO Release 18.104.22.168.1 from 22.214.171.124.2. There are many new features that are available.I have a few favorites:OVM and OVS --> upgraded from 3.0.3 to 3.2.1Distribution Groups --> 8 member to 30 member and viewability (to be expanded on)IAAS API/CLI changes --> enhanced view and pull capabilities into the backend emoc applicationEMOC BUI --> the responsiveness of pages and menus load faster than its predecessor
What is the best/recommended/proven way to generate integer surrogate keys for App development with Oracle as back-end in multi node RAC environment. There may be relatively frequent node switch-over.
Q. IS CACHED, non-ordered sequence is best preferred way in above environment?
data maintenance and quality,
Data ETL/Refreshing between environments,
Now more than ever, database administration services are providing their clients with the expertise and software required to support big data endeavors.
They haven't necessarily had much of a choice. Businesses need environments such as Hadoop to store the large amount of unstructured data they strive to collect and analyze to achieve insights regarding customer sentiment, procurement efficiencies and a wealth of other factors.