Daily Archives: February 6, 2014
Date Formats on Linux
Time Formatting %H – Hour in 24 hour format (00-23) %M – Minutes (00-59) %S – Second (00-61) 61 permits leap seconds. %I – Hour in 12 hour format. (01-12) %p – PM or AM Full Time Formatting %R – Time in %H:%M %T – Time in %H:%M:%S %r – Time in %I:%M:%S %p Day […]
Extending an ASM Datafile
The following example shows how to extend a datafile to the APP_DATA tablespace in the +DATA ASM group. 1. Identify the datafiles for the tablespace you want to increase. SQL> select file_name,bytes/1024/1024 mb aaaaaafrom dba_data_files aaaaaawhere tablespace_name = ‘APP_DATA’ aaaaaaorder by file_name; FILE_NAMEaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaMB ———————————————————— ——- +DATA/SID/datafile/app_data.259.669898683aaaaaaaaaaaaaaaa20000 +DATA/SID/datafile/app_data.267.636216519aaaaaaaaaaaaaaaa28100 2. Extened the Datafile SQL> alter database datafile ‘+DATA/SID/datafile/app_data.259.669898683’ resize […]
ORA-06413 Connection Not Open with TOAD
I Installed Oracle Client32Bit on Windows 2008 R2 64Bit. When I was trying to connect through TOAD it was giving an error ORA-06413 Connection Not Open on the same system. Cause: TOAD Was installed in Program Files (86) Solution: I installed TOAD into QUEST folder in C: drive. Note : The similar problem was coming […]
Show CPU Usage for Active Sessions
— — Show CPU Usage for Active Sessions — SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 COLUMN username FORMAT A30 COLUMN sid FORMAT 999,999,999 COLUMN serial# FORMAT 999,999,999 COLUMN “cpu usage (seconds)” FORMAT 999,999,999.0000 SELECT s.username, t.sid, s.serial#, SUM(VALUE/100) as “cpu usage (seconds)” FROM v$session s, v$sesstat […]
anargodjaev.wordpress.com 