How to check default tablespace in Oracle Database : 2 Easy Steps
Today in this article, we will learn how to check default tablespace in Oracle database. Let's go through the steps : Step 1: Check default tablespace Step 2: Check default…
How to Check Default Tablespace For User and Change it in Oracle: 3 Easy Steps
Today in this article, we will learn how to check default tablespace for user in Oracle and then how to change it. Let's go through the steps : Step 1:…
How to check when a table is last updated in Oracle :
As a DBA, we might often get complaints from the Application Team. For this, sometimes we may need to check when a table is last updated in Oracle. Today we…
How to move ASM Disk from one disk group to another in Oracle :
If one disk group space is very low, then we need to move ASM disk from one disk group to another. Today we will learn how to do this. Let's…
How to resolve ORA-00261: log 10 of thread 1 is being archived or modified
Today in this article, we will learn how to resolve ORA-00261 error. Let's go through this : Error :Solution : Error : SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 10;ALTER…
How to drop standby redo logs in Oracle : 5 easy Steps
Today, we will learn how to drop standby redo logs in Oracle in this article. Let's go through this step by step: Steps to drop standby redo logs in Oracle…
How to run scp in Background with nohup : Easy Guide
As a Linux Admin or DBA, we may often face the issue of copying a larger file from one host to another using scp. Sometimes, our connection may be lost…
Nohup sqlplus command in Oracle : Easy Guide
Nohup is used to run a query in background. Suppose, if your query/task will be taking lot of time, even if it may take couple of days, then also we…
How to Relink Binaries in Oracle : Easy Guide in 7 Steps
Today in this article, we will learn how to relink binaries in Oracle. It is recommended after OS patching or any linux kernel/ version upgrade. Let's go through this step…
How to find bind variable values for a given sql_id in Oracle: Easy Guide
Today in this article, we will see how to find bind variable values for a given sql_id in Oracle. Let's go through this. Query to find bind variable values for…
- 1
- 2
- 3
- 4
- …
- 16
- Go to the next page