Over the years, I’ve seen people ask questions on where they can access a demo Oracle database so that they can practice and learn SQL or PL/SQL. Until today, I never knew of any available Oracle testbed for public consumption. Now, Oracle Corp has provided us with LiveSQL.oracle.com and the only thing you need to access the site is a free OTN account.
Live SQL lets you access a SQL Worksheet where you can enter SQL and PL/SQL commands. You also have read-only access to the HR and SH sample schemas.
I’ve been working on tuning some SQL statements in a newly upgraded database, from Oracle 126.96.36.199 to 188.8.131.52. As I typically do, I like to use SQL Developer to see the Explain Plan. I was surprised to see some gray text in the Explain Plan output, which you can see below.
OEM agents on each host upload data to your management servers every few minutes.
Here’s how you can see exactly what your agent has uploaded. First, enable local backups of the uploaded files with:
emctl setproperty agent -name 'backupUploadedFiles' -value 'true'
Then bounce the agent and perform an upload like this:
emctl reload agent
emctl upload agent
This posting covers the Middleware Management sessions at OOW2015. Note that these are middleware management via Enterprise Manager, as opposed to sessions specifically covering middleware features and functions.
This posting covers the Database Manageability sessions at OOW2015. Note that these are database manageability via Enterprise Manager, as opposed to sessions specifically covering database features and functions. The following sessions fall under this category:
Yesterday I posted an entry on what was coming with OOW2015, specifically discussing the Oracle Management Cloud sessions. This post is similar but looking at one of the more “traditional” EM areas that my team is responsible for – Private Cloud and DBLM. The sessions that are of most interest here are: