IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I will explain ADR file lock wait event during RMAN L0 And L1 Backup in …
Read More »
June 8, 2020
Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners. …
May 10, 2020
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this…
April 15, 2020
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database…
December 10, 2019
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in …
July 4, 2019
Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Hi, I will share all Oracle DBA Scripts related Dataguard in this post. …
September 22, 2022
ORA-27106: system pages not available to allocate memory
I got “ORA-27106: system pages not available to allocate memory” error in Oracle databas…
June 30, 2022
4 Common Indicators That Signal Database Performance Issues
Dealing with database performance issues has to be a priority, regardless of the scope or scale of y…
June 13, 2022
ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace
I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespa…
June 13, 2022
ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file
I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: dat…
June 3, 2022
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error…
MapR Hadoop Distribution For Managing Big Data and Step by Step Mapr Cluster Install In The Best Way
Subjects Bigdata Manage What is Hadoop? Why is Hadoop important? What is MapR Hadoop Distribution …
Read More »
Kafka Stream API Json Parse
PySpark Makina Öğrenmesi (PySpark ML Classification Decision Tree)
PySpark Makina Öğrenmesi (PySpark ML Classification Preapering)
PySpark Makine Öğrenmesi
Clustering Wikipedia
Clustering Wikipedia Hi, in this article i’ll make a simple clustering example using wikipedia. You …
Read More »
Dimension reduction with PCA | Python Unsupervised Learning -6
Dimension reduction | Python Unsupervised Learning -5
t-SNE visualization | Python Unsupervised Learning -4
Introduction to gensim (Python)
4 Common Indicators That Signal Database Performance Issues
Dealing with database performance issues has to be a priority, regardless of the scope or …
Read More »
How to Avoid Activity Monitor Hurting Your SQL Server’s Performance
Random value for DATETIME column
Free Methods to Repair SQL Server Index Corruption
Fill In Missing Dates for SQL Server Query Output using CTE
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best Practices
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best …
Read More »Exadata X8M-2 Multi-Rack Introduction
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
How to Shutdown and Startup Exadata and Oracle Databases
Exadata Temp Tablespace Migration To Flash Disk
Android Programming -15 Custom Adapter
Hi guys in this tutorial we will continue the custom adapter. In my previous article, …
Read More »
Android Programming -14 Custom Listview-2
Android Programming -13 Custom Listview
Android Programming -12 ArrayAdapter
Android Programming -11 Listview Component
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error …
Read More »OGG-15121 Error obtaining the list of tables for: Does not match any catalog name
OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs
OGG-00041 Data source not specified.
OGG-00446 Checkpoint table GGSCHKPT does not exist
How to connect to Oracle from Your Windows Host to a VirtualBox Guest
I am sure that anyone who wants to work on a database or a data …
Read More »Windows İşletim Sistemi ile Oracle Linux Sanal Makinesinin haberleştirilmesi(Virtualbox)
DATA WAREHOUSE – ODS (OPERATIONAL DATA STORE)
ODS (Operational Data Store) ODS (Operational Data Store) is the database where all the source …
Read More »
Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6
DATA WAREHOUSE – OLTP/OLAP
DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
DATA WAREHOUSE – ETL/ELT
Execute Immediate in Oracle
I will explain Execute Immediate in Oracle in this post.
Read More »Oracle SQL Date Comparison
Alter table rename column in Oracle
Rename Table in Oracle
NEXTVAL and CURRVAL function in Oracle
UTL_FILE FOPEN in PL/SQL
I will explain UTL_FILE FOPEN in PL/SQL in this post.
Read More »DBMS_OUTPUT.PUT_LINE in PL/SQL
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
PL/SQL Conversion/Decoding/NULL-Related Functions
PL/SQL Datetime Functions
PostgreSQL – How to Eliminate Repeated Values
It’s possible that in a table, some field that has repeated values is necessary to …
Read More »
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Bulk Insert and Bulk Update in Oracle Database
What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -15
Usefull Scripts For Couchbase Dba
Why Couchbase? Today’s mission-critical applications demand support for millions of interactions with end-users. Traditional databases …
Read More »
MongoDB Backup and Restore Using MongoDump
How to Access MongoDB Instance 4.2?
How to Install MongoDB on Windows System?
How To Install MongoDB 4.2 on RedHat/ CentOS 7 systems
Recent Posts
February, 2022
- 5 February
failed to detect Grid Infrastructure setup due to null during Opatchauto apply
I got ” failed to detect Grid Infrastructure setup due to null ” error in the Oracle during Opatchauto apply.
Read More » - 5 February
ORA-10485: Real-Time Query cannot be enabled while applying migration redo
I got ” ORA-10485: Real-Time Query cannot be enabled while applying migration redo ” error in the Oracle dataguard.
Read More »
January, 2022
- 31 January
Agent ve Contexts Arası Bağlantı Oluşturma – ODI Dersleri 9
Merhaba arkadalar, bu gün ki makalemizde gözden kaçma ihtimali yüksek bir konu olan Agent ve Contexts arası bağlantı oluşturma konusu üzerinde duracağız. Öncelikle daha önce okumadıysanız ODI serisini okumanızı tavsiye …
Read More » - 18 January
ORA-14100: partition extended table name cannot refer to a remote object
I got ” ORA-14100: partition extended table name cannot refer to a remote object ” error in the Oracle database when Select Partition of table using DBLink ( database link …
Read More »
December, 2021
- 13 December
Elements of a Good Developer Portal
A developer portal can be defined as the interface standing between a set of SDKs, APIs, and other interactive tools and applications. The portal is responsible for helping organizations achieve …
Read More »