Calculating CPU usage in Oracle
The performance of Oracle is determined by 4 factors: the CPU, internal memory, disk access and network performance. The latter, network performance, is only relevant if data are written or…
The performance of Oracle is determined by 4 factors: the CPU, internal memory, disk access and network performance. The latter, network performance, is only relevant if data are written or…
Oracle has several possibilities to back up the data. One possibility is backing up via data pump. This facility can be used by the command line. Let us discuss three…
It happens to me quite often. I install Oracle and it only listens to the localhost. In a few steps, one can get it to listen to the IP address…
Oracle has a nice facility to store data in an encrypted form. This allows to hide data content from users while still allowing them to see the columns. If one…
Oracle has recently introduced masking as one of the facilities. Masking allows data to be hidden from users / or only display part of the content. Other users can still…
The question is simple: we have an Oracle query and we want to use one search criterium as a parameter. Let us take a simple example. We want to use…
One may implement security by creating a view. This view then only contains the columns that you would like to show. If one adds a filter, one may also limit…
Oracle knows the command “drop table”. One may include this in a script where a table is first deleted (using “drop table”) and subsequently rebuilt with additional SQL statement. But…
It is possible to process CSV files in Spark as if these files are tables. That looks very promising: reading a file, translating the file into something that can be…
Oracle has now included an Oracle tuning advisor. Its purpose is to advise on a SQL statement. For me, it provides an answer on whether to add an index or…