Skip to content
Saturday, June 25, 2022
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
  • Home
  • Oracle

Category: Oracle

How to Determine If the Oracle Redo Log File Size Is a Problem

2 September 20202 September 2020 Administrator

Two potential problems are possible that should be addressed when considering whether to increase the size of Oracle log files: batch jobs that donâ€Read More…

Who is connected to my Oracle database?

2 September 20202 September 2020 Administrator

Would you like to know who is connected to your Oracle database? Is there anybody currently connected? How to check where the connections come from? Read More…

Renaming SYSTEM datafiles of Oracle Database

2 September 20202 September 2020 Administrator

System tablespace is the most critical tablespace in Oracle database. To rename datafiles related to SYSTEM tablespace , we cannot proceed as we procRead 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…

SQL Developer Hints to Format Output

21 August 202021 August 2020 Administrator

SQL Developer may not be the perfect IDE, but it doesn’t mean that it has not got any tricks at all. One of those features I’d like mention about canRead More…

SQLNET.ORA Parameter: SQLNET.EXPIRE_TIME

21 August 202021 August 2020 Administrator

Asking why to use this parameter? Why this is set in your environment? Or even how it can hep you? Here we go: As per Oracle documentation, this pRead More…

Reconfigure OS Parameters After Linux Server Memory Upgrade

21 August 202021 August 2020 Administrator

One of the Oracle database serverĂ«s memory is to be upgraded from 48GB to 72GB, so some parameters should be adjusted to take advantage of the newlyRead More…

Oracle Restart

21 August 202021 August 2020 Administrator

Oracle Restart is a new feature introduced in Clusterware 11.2. In simple terms it allows you to register resource such as ASM disk groups, ASM- and Read More…

How to troubleshoot Oracle remote database connection

21 August 202021 August 2020 Administrator

Many Oracle DBAs, developers and just end-users often encounter an issue when they can not connect remotely to an Oracle database. There can be diffeRead More…

How to Restrict User from Connecting to Database Through Specific IP Address

21 August 202021 August 2020 Administrator

Some of the DBA asked me to restrict the connection to DB from specific IPs. Its simple and you can use the logon trigger for this purpose. CREATERead More…

Posts navigation

Older 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
  • 25
  • 32,394

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.