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. 240,706 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. 230,190 views las…
November 8, 2022
How to Recover Data from Flash Drives [2022 Guide]
USB flash drives are ideal storage devices when we need to back up files and transfer data across di…
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…
How to Recover Data from Flash Drives [2022 Guide]
USB flash drives are ideal storage devices when we need to back up files and …
Read More »
MapR Hadoop Distribution For Managing Big Data and Step by Step Mapr Cluster Install In The Best Way
Kafka Stream API Json Parse
PySpark Makina Öğrenmesi (PySpark ML Classification Decision Tree)
PySpark Makina Öğrenmesi (PySpark ML Classification Preapering)
-
How to Recover Data from Flash Drives [2022 Guide]
USB flash drives are ideal storage devices when we need to back up files and …
Read More » 
Clustering Wikipedia
Dimension reduction with PCA | Python Unsupervised Learning -6
Dimension reduction | Python Unsupervised Learning -5
t-SNE visualization | Python Unsupervised Learning -4
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
How to Prevent SQL Injection Attacks by Secure
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)
-
How to Recover Data from Flash Drives [2022 Guide]
USB flash drives are ideal storage devices when we need to back up files and …
Read More » 
DATA WAREHOUSE – ODS (OPERATIONAL DATA STORE)
Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6
DATA WAREHOUSE – OLTP/OLAP
DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC)
Execute Immediate in Oracle
I will explain Execute Immediate in Oracle in this post. 166,468 views last month, 22 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. 180,004 views last month, 22 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
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. 47,699 views last month, 1 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. 24,090 views last month, 3 views today
Read More » - 26 August
Find Table Size & Schema Size and Database Size in Oracle
I will explain How to Find Table Size & Schema Size and Database Size in Oracle in this post. 23,784 views last month, 1 views today
Read More »