MEMORY_TARGET is a database initialization parameter that can be used for automatic PGA and SGA memory sizing. MEMORY_TARGET provides the following: A single parameter for total SGA and PGA sizes Automatically …

How to increase PROCESSES initialization parameter :  Check Current Setting of Parameters 1)show parameter sessions 2)show parameter processes 3)show parameter transactions   A basic formula for determining  these parameter values …

Hi , Grant the user the appropriate system privileges or grant the user space resource on the tablespace. GRANT UNLIMITED TABLESPACE TO BBY;

You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL.   GRANT SELECT ANY CUBE TO …

The privileges to revoke.   REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table  FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ;  

Sysdba kullanıcısı ile sqlplus girişi yapılır. [oracle@baranyildiz ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 12 22:02:41 2019 Copyright (c) 1982, 2014, Oracle.  All rights reserved. …

ORA-00059: maximum number of DB_FILES exceeded   While adding a new datafile to tablespace, I got the ” ORA-00059: maximum no. of DB_FILES exceeded ” error, then I checked db_files …