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 …
Read More »baranyildiz
ORA-00020: maximum number of processes (%s) exceeded
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 …
Read More »ORA-01950: no privileges on tablespace
Hi , Grant the user the appropriate system privileges or grant the user space resource on the tablespace. GRANT UNLIMITED TABLESPACE TO BBY;
Read More »Grant Privileges
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 …
Read More »Revoke Privileges
The privileges to revoke. REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table FROM BARANYILDIZ; REVOKE SYSDBA FROM BARANYILDIZ;
Read More »Archivelog mod değiştirme
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. …
Read More »ORA-00059: maximum no. of DB_FILES exceeded
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 …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial