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 »Architecture
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 »How to Move, Rename and Relocate Datafiles in Oracle
I will explain How to Move Rename and Relocate Datafiles in Oracle database.
Read More »What is the Tablespace in Oracle
I will explain What is the Tablespace in Oracle in this post.
Read More »Oracle Database 19c New Initialization Parameters
The following initialization parameters are new in Oracle Database 19c: In Oracle 19c database Oracle introduced six parameters. We know that parameter plays very important role in database. You …
Read More »What is the Execution Plan and How to View Execution Plan in Oracle | Oracle Database Performance Tuning Tutorial -4
Hi, I will explain What is the Execution Plan and How to Generate Execution Plan in this article.
Read More »What is the Oracle Optimizer and How Cost-Based Optimizer Works ? | Oracle Database Performance Tuning Tutorial -3
Hi, I will explain What is the Oracle Optimizer and How Cost-Based Optimizer Works in this article.
Read More »SQL Statement Processing in Oracle Database
Hi, I will explain SQL Statement Processing in Oracle Database in this article.
Read More »Oracle Database Editions & Oracle Features | Enterprise Edition vs Standard Edition
Hi, I will explain Oracle Database Editions and Oracle Features in this post.
Read More »Oracle Database Version History & Oracle Release Versions
I will explain about Oracle Database Version History & Oracle Release Versions in this article. Let’s review the Oracle Database Version History | Oracle Release Versions.
Read More »