Loading...

Follow Anar Godjaev on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Command to check CPU info on Linux cat /proc/cpuinfo|grep processor|wc -l OR nproc --all OR getconf _NPROCESSORS_ONLN Command to check CPU ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

While performing database audits, you might need to check who logged in last into the database. The query will help you find out last user ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mb from ( select 'sga' nm, sum(value) val from v$sga union all ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mb from ( select 'sga' nm, sum(value) val from v$sga union all ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The below script will drop all the objects owned by a schema. This will not delete the user but only deletes the objects SET SERVEROUTPUT ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Sometimes when you run datapump export, it might take a lot of time. Meanwhile client might ask you for the % of export completed. Use ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Below command will help you check Scheduler jobs which are configured inside database SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS where ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

set linesize 500 col BACKUP_SIZE for a20 SELECT INPUT_TYPE "BACKUP_TYPE", --NVL(INPUT_BYTES/(1024*1024),0)"INPUT_BYTES(MB)", --NVL( ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

set linesize 500 col BACKUP_SIZE for a20 SELECT INPUT_TYPE "BACKUP_TYPE", --NVL(INPUT_BYTES/(1024*1024),0)"INPUT_BYTES(MB)", --NVL( ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

SELECT * FROM (select SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024/1024 GB, TABLESPACE_NAME from dba_segments order by 3 desc ) WHERE ROWNUM ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview