(Jeff Smith) With some excellent feedback from our friends on the In-Memory and Real World Performance tuning groups here, we made the following improvements to the SQL Monitoring interface in SQL Developer:
Tag: Oracle
Column Mapping and Transformation in Oracle Golden Gate
(Jagruti Jasleniya) In general, any replication tool replicates data in similar objects. We need an identical copy of the source and target if we want to do replication.
High Processes Cause Semaphore Errors
(Bobby Durrett) I could not create a new Delphix virtual database because I kept getting semaphore limit errors. I ended up reducing the processes parameter value to resolve the issue.
Managing Tablespace in Multi-Tenant Environment Part – II
(Jagruti Jasleniya) In the previous article, we have seen System tablespace and Users tablespace.
Quickly build self-signed certificates for Oracle GoldenGate 18c
(Bobby Curtis) With Oracle GoldenGate Microservices 12c and 18c, the architecture can be configured to use SSL certificates for securing and replicating between sites.
Strange Index Behavior
(amitzil) During a performance problem I had with a query I wanted to create an index on the table. Since this was a large table I wanted the index to include all the needed columns so I won’t need to access the table at all.
Introducing the Database Management REST API for your Oracle Database
(Jeff Smith) Oracle REST Data Services has for the past 5-6 years given you the ability to develop and deploy RESTful Services for your Oracle Database – by just writing some SQL and PL/SQL.
Build it Yourself — Chatbot API with Keras/TensorFlow Model
(Andrejus Baranovskis) Is not that complex to build your own chatbot (or assistant, this word is a new trendy term for chatbot) as you may think. Various chatbot platforms are using classification models to recognize user intent.
RMAN-04022
(Andrew Reid) I created an RMAN script to copy an Oracle 11.2.0.1 target database called BUSPROD into an auxiliary database called BUSSOUT2.
Configure and use the local UNDO mode
(Jagruti Jasleniya) In Oracle 12c Release 1 Undo tablespace was always Shared across PDBs. Rollback segment of each pdb was written in Undo tablespace which was created under the Container Root database.
