Enterprise Manager does a LOT. Sometimes it may do too much. Customers on forums, on support or via email and social media may come to us asking how to address something they view as not working right and the truth is, we could simply answer their question, but they aren’t using the right tool to accomplish what they’re attempting.
Today’s post is courtesy of this question from a reader:
Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted?
The answer is ‘Yes!’
I’m going to use HR.EMPLOYEES to give me my data.
I start with…
SELECT Hire_date,... [Read More]
The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. Here’s the (slightly modified) table creation script he supplied:
Those of you who know me will know that I’m working at Cedar and we’re moving from PeopleSoft to the Oracle Cloud. I won’t talk about the company’s journey, but more how I’ve found the transition personally.
In brief, there’s a lot to learn.
Data Model knowledge
In the PeopleSoft world, once you know the table structures you could work significantly faster. Whether you were writing an SQR, an App Engine, an XMLP report, a (more...)
I was asked by Delphix earlier this year to review their product with a particular focus on Oracle security of course. I wrote two papers; the first about Data Masking and Delphix and the second about securing data in non-production....[Read More]
are working on large Fusion Middleware & PaaS opportunities &
projects? Oracle is pleased to invite you to the PaaS & Fusion
Middleware Summer Camps VI by the SOA & BPM and the WebLogic &
Developer Partner Communities. Goal of the trainings is to support you
to deliver a successful project. Most of the trainers are a member of
the Oracle product management team.
Come to Lisbon to get a 5 days hands-on training (more...)
Creating database tables in Oracle is one of the most common tasks an Oracle developer or Oracle DBA does. Learn how to create tables, what the syntax is, and see some examples in this article. What Is The Create Table Command Used For? The CREATE TABLE command is used to create a database table. It […]
A frequently reoccuring design problem with relational databases is the issue locating unprocessed rows in a large table, so we know which rows of data are still yet to be processed.
The problem with a STATUS column is that it generally has low cardinality; there are probably only a handful of distinct values [(C)omplete, (E)rror, (U)nprocessed or something like that]. Most records will be (C)omplete. This makes STATUS a poor candidate for standard B-Tree indexation. (more...)
If you didn’t come this page from my review about the OUGF Harmony16 Spring Conference, please don’t forget to read it. This post is generated almost automatically by scripts to share the twitter statistics of the conference. The statistics cover the period between May 17 and May 20. I included three hashtags (#OUGF, #OUGF16, #Harmony16), because at the beginning of the conference, people (including me) did not used the official hashtag (#Harmony16).
Last week I took part in the OUGF (Oracle User Group Finland) Harmony 16 Spring Conference. It was a two day event, and held in Helsinki, between May 18th and 19th. In the conference, I gave two speeches: “Essential Linux commands for DBAs” and “Enterprise Manager 13c for DBAs”. Most people expect to me to speak about Enterprise Manager but in my first session, I spoke about the tools which can be used for monitoring (more...)
JJUG CCC is the largest Java community event in Japan, held twice a year in spring and autumn. The one day event is organized by the Japan Java User Group and attracted over 1,300 attendees last Saturday. Top speakers presented sessions about all Java technologies in 7 tracks. The event closed with entertaining Ignite sessions including a blind sake tasting competition between NightHacking organizers, Sebastian and Stephen, and the community members.
Atom feeds provide notifications of Oracle Fusion Human Capital
Management (HCM) events and are tightly integrated with REST services.
When an event occurs in Oracle Fusion HCM, the corresponding Atom feed
is delivered automatically to the Atom server. The feed contains details
of the REST resource on which the event occurred. Subscribers who
consume these Atom feeds use the REST resources to retrieve additional
information about the resource.
Just realized that I wrote a follow-up to Part 2 2 years ago and never posted it! So here’s the stripped-out key facts to round off auditing control a bit more:
Deleting O/S audit files is, like, totally necessary. In Oracle 12C (12.1), they are created by default as AUDIT_SYS_OPERATIONS defaults to TRUE now, so you are going to be filling up your AUDIT_FILE_DEST whether you realized it or not.
Monday night we obtained access to the SOA Cloud Service here at
Flexagon, where we hope to use it for on-demand capacity. One of our
goals with FlexDeploy is to make it easy to move components from one
environment or instance to another, enabling a true “lift-and-shift”
into the cloud. Since the SOA Cloud Service is built on top of the same
underlying Oracle infrastructure, configuring it as a FlexDeploy target