Skip to content
Tuesday, February 07, 2023
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
Latest Posts
  • MySQL
    How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-Errors
    ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC
    Oracle RAC log files locations
  • DB Scripts
    Drop all tables in Oracle DB (Schema)
  • Oracle
    How to Determine If the Oracle Redo Log File Size Is a Problem
  • Home
  • Page 2

HOW TO RESIZE INNODB LOGS?

1 September 20201 September 2020 Administrator

If for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guRead More…

Reset MySQL forgotten root Password

1 September 20201 September 2020 Administrator

Step # 1: Stop the MySQL server process. [[email protected] ~]# /etc/init.d/mysqld stopStopping mysqld:      &nbspRead More…

How to Create a Scheduler Job in Oracle 12c

1 September 20201 September 2020 Administrator

The Oracle 12c Scheduler example here creates a simple job that runs a stored Programming Language/Structured Query Language (PL/SQL) procedure. The Read More…

Grant Select on all Tables Owned By Specific User

1 September 20201 September 2020 Administrator

BEGIN FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner=’TheOwner’) LOOP EXECUTE IMMEDIATE ‘grant select on ‘||R.owner||’.’||R.Read More…

How to tune Oracle Standard Edition without Option Packs

26 August 202026 August 2020 Administrator

When you monitor a Oracle Standard Edition, you did not have a Tuning or Diagnostic Pack. This Feature must be disabled because they are not allowed Read More…

Oracle AWR in Standard Edition

26 August 202026 August 2020 Administrator

I was assigned to collect performance data on an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under SRead More…

MySQL overall server status report

26 August 202026 August 2020 Administrator

In MySQL it is a very beautiful way to find the server’s over all current status or even we can generates a HTML code to get a report like Oracle ARead More…

How to find out total memory used by each database ?

26 August 202026 August 2020 Administrator

The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values ​​from timeRead More…

What are Patches and how to apply patches ?

21 August 202021 August 2020 Administrator

Patching is one of the most common task performed by DBA’s in day-to-day life . Here , we will discuss about the various types of patches which are pRead More…

Step by step how to apply PSU patch in Oracle

21 August 202021 August 2020 Administrator

STEP 1:Check the operating system bit version (32 bit or 64 bit). [[email protected] ~]$ uname -a Linux host11.intra.searshc.com 2.6.18-308.1.1.el5xRead More…

Posts navigation

Older posts
Newer posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 36
  • 49,284

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.