Monthly Archives: January 2017

Containers Instead of Virtual Machines

Posted on January 26, 2017 by tosasan

The last couple of years have seen the rise of software products that leverage Linux Containers (LXC) to deploy many instances of an application on one operating system. Running applications in LXC is an alternative to running applications in a … Continue reading →

Posted in OS, Uncategorized | Leave a comment

Move or Rename the Tempfile in Oracle

Posted on January 24, 2017 by tosasan

1. Login as SYSDBA 2. Check the Tempfile status SQL> SELECT v.file#, t.file_name, v.status 2 FROM dba_temp_files t, v$tempfile v 3 WHERE t.file_id = v.file#; FILE# FILE_NAME STATUS ———- ————————- ——- 1 /u01/temp01.dbf ONLINE 2 /u02/temp02.dbf ONLINE 3 /u02/temp03.dbf ONLINE … Continue reading →

Posted in ORACLE | Tagged | Leave a comment

Renaming or Moving Oracle Files

Posted on January 24, 2017 by tosasan

original page : https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files Controlfiles The current location of the controlfiles can be queried from the V$CONTROLFILE view, as shown below. SQL> select name from v$controlfile; NAME ————————————————————- C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL01.CTL C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL02.CTL C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL03.CTL 3 rows selected. SQL> In order to rename or … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

ORA-00020: maximum number of processes … exceeded

Posted on January 23, 2017 by tosasan

First check your sessions, processes and transactions system parameter. Check Current Setting of Parameters sql> show parameter sessions sql> show parameter processes sql> show parameter transactions A basic formula for determining  these parameter values is as follows: processes=x sessions=x*1.1+5 transactions=sessions*1.1 … Continue reading →

Posted in ORACLE | Tagged | Leave a comment

How to list the most biggest directory on AIX

Posted on January 20, 2017 by tosasan

du command – To list the most biggest directory To list the five most biggest directory, you have to perform the command below: du -sk ./* | sort -rn | head -5 Output: $ du -sk ./* | sort -rn … Continue reading →

Posted in OS-AIX | Tagged | Leave a comment

Some Routine DB Checklist Queries

Posted on January 12, 2017 by tosasan

Mviews Not Refreshed from Last 7 Days: select mview_name from user_mviews where LAST_REFRESH_DATE < sysdate – 7; Total Number of Tables: select count(1) from user_tables where table_name not like ‘%$%’ Total Number of Mviews: select count(1) from user_mviews Total Number … Continue reading →

Posted in Sybase | Leave a comment

Oracle DBA Daily Checklist

Posted on January 12, 2017 by tosasan

Oracle DBA Daily Checklist 1. Check that all instances are up. 2. Monitor alert log entries (using tail -f) 3. Check that dbsnmp(SNMP subagent for Oracle DB) is running. 4. Check all last night backups were successful. 5. Check all … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment