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
September, 2021
- 16 September
How To Setup PasswordLess SSH Connectivity Using SshUserSetup.sh in Linux
I will explain How To Setup PasswordLess SSH Connectivity Using SshUserSetup.sh in this post.
Read More » - 10 September
Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6
Merhaba arkadaşlar, bu gün ki makalemizde mapping işlemlerine devam edeceğiz. Okumadıysanız öncelikle mappingin logical tanımlamalarını gerçekleştirdiğimiz makalemi okumanızı tavsiye ederim. Makaleye buradan erişebilirsiniz. Bu gün ki makalemizde Pyhsical sekmesinde …
Read More » - 8 September
DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle
I will explain DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle in this post.
Read More » - 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 »