Loading...

Follow Anar Godjaev on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Anar Godjaev
Oracle blog by Anar Godjaev.
+

Oracle Database Relase 19c New Features You can perform Sql and Pl/sql operations in Active data Guard standby database Allows DML to be ..read more

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

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

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

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

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

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

Below command will help you check Scheduler jobs which are configured inside database SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS where ..read more

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

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