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. 176,172 views …
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. 168,097 views las…
21 hours ago
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…
December 13, 2021
Elements of a Good Developer Portal
A developer portal can be defined as the interface standing between a set of SDKs, APIs, and other i…
November 30, 2021
OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs
I got ” OGG-01433 Failed to validate table. The table is compressed and extract will not be ab…
November 30, 2021
ORA-10459: cannot start media recovery on standby database; conflicting state detected
I got ” ORA-10459: cannot start media recovery on standby database; conflicting state detected…
November 30, 2021
Microsoft Exchange Server Security Best Practices in 2021
Microsoft Exchange is the most common email server solution used by private businesses, government o…
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)
How to Avoid Activity Monitor Hurting Your SQL Server’s Performance
There is no question that monitoring the performance of your SQL Server deployment is an …
Read More »
Random value for DATETIME column
Free Methods to Repair SQL Server Index Corruption
How to Prevent SQL Injection Attacks by Secure
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-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs
I got ” OGG-01433 Failed to validate table. The table is compressed and extract will …
Read More »OGG-00041 Data source not specified.
OGG-00446 Checkpoint table GGSCHKPT does not exist
GoldenGate Table Based Extract, PUMP, REPLICAT parameters setting
Table Based GoldenGate initial load
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)
Veri Ambarı Konsepti(OLAP,OLTP)
Tableau Server Architecture
Tableau Server has a high scalable architecture that many users can connect and receive service …
Read More »Tableau Sunucu Mimarisi
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. 102,349 views last month, 160 views today
Read More »
Oracle SQL Date Comparison
Alter table rename column in Oracle
How to Prevent SQL Injection Attacks by Secure
Rename Table in Oracle
UTL_FILE FOPEN in PL/SQL
I will explain UTL_FILE FOPEN in PL/SQL in this post. 115,852 views last month, 159 views today
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
September, 2021
- 7 September
DATA WAREHOUSE – OLTP/OLAP
OLTP (On-line Transaction Processing) By the mid-1970s, online transaction processing (OLTP) made even faster access to data possible, opening whole new vistas for business and processing. Shortly after the advent …
Read More »
August, 2021
- 30 August
Random value for DATETIME column
Today, I am going to describe how to generate random value for DATETIME field within a given range. This is very useful specially for generating test data. For this, we …
Read More » - 26 August
Mapping 1 – ODI Dersleri 5
Merhaba arkadaşlar, bu gün ODI de MSSQL database inden Oracle database’ine ODI mapping ile tablo aktarılmasını göreceğiz. Mapping’in yapıla bilinmesi için öncelikle model tanımlanmasını gerekmektedir. Bu yüzden okumadıysanız öncelikle …
Read More » - 26 August
Oracle Invalid Objects | Compile Invalid Objects Using utlrp.sql
I will explain Oracle Invalid Objects | Compile Invalid Objects Using utlrp.sql in this post. 46,882 views last month, 2 views today
Read More » - 26 August
V$Active_session_history | Active Session History in Oracle
I will explain V$Active_session_history | Active Session History in Oracle in this post. 23,164 views last month, 3 views today
Read More »