As a DBA, you must know the important locations of Oracle database and Exadata log files. Like database alert log file there is also a alert log file for the exadata cell nodes. So lets look at the locations of all these files. Cell alert.log file /opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log if the CELLTRACE parameter is set just…
As an application user you might have been asked to write a cleanup script to delete old data from a big table which is having millions of rows based on date or some fields. Being a DBA, application guys used to ask me any best way to delete huge amounts of rows from a huge…
Here are the top level directories in your Linux system, with a brief explanation of the purpose of each: /: The top level directory in your system. It’s called the root directory, because it’s the root of the system: all the rest of the directory structure emanates from it like branches from the root of…
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is enable? — DB_CACHE_ADVICE should be ON SQL> show parameter db_cache_advice NAME TYPE VALUE ———————————— ——————————– —————— db_cache_advice string ON — STATISTICS_LEVEL should be TYPICAL/ALL. SQL>…
In this article, we will discuss about temporary tablespace usage and shrinking tempfiles to reclaim unused space from the TEMP tablespace in Oracle. Temporary tablespaces are used for database sorting and joining operations and for storing global temporary tables. It may grow in size over a period of time and thus either we need to…