(Fernando Salgado) This is the second in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. In the previous post, Part 1, we covered how to set up basic monitoring.
Tag: Oracle
12.2.0.1 And Later Support (Limited) Extended Stats On Virtual columns / Column Groups of Expressions
(Randolf Geist) I do have a demo as part of my optimizer related workshops that shows the restriction / limitation of DBMS_STATS not supporting extended statistics on virtual columns / group of expressions, so for example the combination of both expressions and column groups, like ((TRUNC(COL1)), (T
Data Guard Fast-Start Failover Test – Shutdown Standby Host
(mdinh) Data Guard Fast-Start Failover Test – Shutdown Primary Host
Monitor your lockdown profiles
(Connor McDonald) Most administrators are now aware of the lockdown profile facility in the Oracle database (available since 12c). They allow a more granular level of privilege control of components and functionality within the database.
Asynchronous Function Calls through API Gateway on Oracle Cloud Infrastructure
(Lucas Jellema) In a recent article, I described how serverless Functions on Oracle Cloud Infrastructure can invoke each other: synchronously and asynchronously.
OCI: Enabling X11 Forwarding on an Oracle Linux instance
(Trent) I was connecting to one of my works servers the other day hoping to copy the contents of a file into my clipboard, which would require the use of an X11 forwarded session, but as I connected to the server with X11 forwarding enabled, I was sad to see the following message:
Modernizing an Oracle Forms Application to an Oracle APEX Application
(Monica Godoy) Oracle Forms is an established technology that has been popular for building data applications for decades, particularly in South America you can find a vast array of companies working with Oracle Forms, even with an unsupported version.
OCI Serverless Functions invoking other Functions – synchronous and asynchronously through API Gateway and Streaming
(Lucas Jellema) OCI allows for cloud native application development, using facilities such as serverless functions, a light weight API gateway, a streaming service for asynchronous communication based on event messaging and built-in monitoring.
Single Value Column Frequency Histogram Oracle 12c and later
(Randolf Geist) It is hopefully in the meantime well known that Oracle has introduced in version 11g a new algorithm to gather statistics on a table that no longer requires sorting for determining the critical Number Of Distinct Values (NDV) figure – it instead uses a clever “approximate NDV” algori
Did You Know #32 – OEM Scripts Location
(Liron Amitzi) Sometimes you get an alert from OEM but you can figure out why. It would help a lot if you could see the test and understand what exactly OEM is checking.