-
How to Delete Table, Index or Schema Statistics in Oracle Database
To delete table, index, or schema statistics in Oracle Database, you can use the following methods: Continue reading
-
How to Stop / Drop Scheduled / Running jobs in Oracle
We create jobs and can schedule it by using DBMS_SCHEDULER package. We can also use this package for to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package. In some cases you will have to use the force option to stop the job. Let start to example SQL>… Continue reading
-
Oracle Data Guard Vs Oracle Active Data Guard
Oracle Data Guard and Active Data Guard… Both are super cool solutions for high availability and disaster recovery solutions. However, they differ in terms of their capabilities and functionalities. You need to be Enterprise Edition version to can use Data Guard. Just reminder, Oracle Data Guard bundle with Oracle EE license. You need to license… Continue reading
-
What is Oracle Cloud Terminology
Oracle Cloud is offer many of service for IT structures. In this post i want to share some of concept/terminology about Oracle Cloud. These are just a few examples of Oracle Cloud terminologies. Oracle Cloud encompasses a broad range of services and offerings, and the terminology can vary depending on the specific services and products… Continue reading
-
Investigating SQL performance? But how? What i should control or use?
Investigating SQL performance is very big topic in Oracle worlds. Many times we hit performance issue during daily control. Many of performance problems are related with bad coding, changed plan, missing index or missing statistics. It my also related with server components too. Investigating SQL performance in an Oracle database involves analyzing and identifying performance… Continue reading
-
Exadata? What is new?
Exadata.. If you are dba than its not possible to don’t hear Exadata machine. It is a popular and powerful database platform developed by Oracle Corporation. It is a most popular Appliance for Oracle database. Basically, It is designed for high-performance, scalable, and efficient processing of large volumes of data. I believe that, the most… Continue reading
-
RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database
One of our customer hit below message during backup of a Standby Database. Db version is 11.2.0.4 (yeah I know its old one) and linux version is OEL 7.8 Error messages are: RMAN-03090: Starting backup at 20-May-23RMAN-06820: WARNING: failed to archive current log at primary databaseRMAN-06003: ORACLE error from target database:ORA-17629: Cannot connect to the… Continue reading
-
Oracle Database Appliance (ODA)…Hımmm. I should use it?
In one of our customer want to use new server for their database. We offer Oracle Database Appliance (ODA) is an engineered system which is designed by Oracle. But why customer should prefer this engineered system? There are many competitors at current IT market. In this post, I try to explain why We offer Oracle… Continue reading
-
General Approach’s check to Migrating an Oracle Database to newer version on new server
With each Oracle release, we need to make plan database upgrade. It can be move from 12c to 19c or higher. Its better to use new server(of course if its possible) for this migration. In this posts, i wanted to share general approach for database migration steps by using new server In this example we… Continue reading
-
Oracle Cloud Service Level Agreements (SLAs)
Service Level Agreements (SLAs) is so important for each company. If you need to move cloud it became more important for your IT structure. Oracle Cloud provides Service Level Agreements (SLAs) to ensure the availability and performance of its cloud services. The specific SLAs offered by Oracle Cloud can vary depending on the service and… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 