Posted inLinux Oracle

Linux Operating System 1.

File and Directory The "pwd" command displays the current directory: [root@dg11 dbhome_1]# pwd /u01/app/oracle/product/19.0.0/dbhome_1 The "ls" command lists all files and directories in the specified directory. If no location is defined it acts on…
No Comments
Posted inOracle

Details of PGA, SGA, db_cache, shared_pool and db/sp%, subpools

with PGA_GB as (SELECT VALUE/(1024*1024*1024) PGA_GBFROM V$PARAMETER WHERE NAME = 'pga_aggregate_target'),subpools as (SELECT COALESCE(SUM(VALUE/(1)), NULL) subpoolsFROM V$PARAMETER WHERE NAME = '_kghdsidx_count'),SGA_GB as (select (trunc(sum(value)/1024/1024/1024,2)) SGA_GBfrom v$sga),SHARED_POOL_GB as (SELECT VALUE/(1024*1024*1024) SHARED_POOL_GBFROM…
No Comments
Posted inOracle

Users

Create user CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME> TEMPORARY TABLESPACE ; Drop user drop user <USERNAME> cascade; Alter user alter user <USERNAME> identified by (account un\lock); Backup…
No Comments
Posted inOracle SQL

ROWID Pseudocolumn

For each row in the database, the ROWID pseudocolumn returns the address of the row. Every table in an Oracle database has a pseudocolumn named ROWID. Oracle Database rowid values…
No Comments