Category: Oracle

Two potential problems are possible that should be addressed when considering whether to increase the size of Oracle log files: batch jobs that donâ€Read More…

Would you like to know who is connected to your Oracle database? Is there anybody currently connected? How to check where the connections come from? Read More…

System tablespace is the most critical tablespace in Oracle database. To rename datafiles related to SYSTEM tablespace , we cannot proceed as we procRead More…

I was assigned to collect performance data on an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under SRead More…

SQL Developer may not be the perfect IDE, but it doesn’t mean that it has not got any tricks at all. One of those features I’d like mention about canRead More…

Asking why to use this parameter? Why this is set in your environment? Or even how it can hep you? Here we go: As per Oracle documentation, this pRead More…

One of the Oracle database serverës memory is to be upgraded from 48GB to 72GB, so some parameters should be adjusted to take advantage of the newlyRead More…

Oracle Restart is a new feature introduced in Clusterware 11.2. In simple terms it allows you to register resource such as ASM disk groups, ASM- and Read More…

Many Oracle DBAs, developers and just end-users often encounter an issue when they can not connect remotely to an Oracle database. There can be diffeRead More…

Some of the DBA asked me to restrict the connection to DB from specific IPs. Its simple and you can use the logon trigger for this purpose. CREATERead More…