ACID properties
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1d ago
  To maintain the integrity of the data, there are four properties described in the database management system, which are known as the ACID properties ACID properties are a set of principles that ensure reliable transaction processing in a database. They stand for: Atomicity – A transaction is either fully completed or fully rolled back. If one part of the transaction fails, the entire transaction is undone to maintain database integrity. Example: If you transfer money from one account to another, both debit and credit operations must succeed. If the debit succeeds but the c ..read more
Visit website
Oracle Database vs Database Instance
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1w ago
  Oracle Database vs. Oracle Database Instance Oracle uses a multi-layered architecture where the database and database instance are distinct yet interconnected. Understanding their differences is key for Oracle DBAs. 1. Oracle Database ? An Oracle Database is a collection of physical files that store data and metadata. It consists of: ✅ Datafiles (.dbf) – Store actual user and system data. ✅ Control files (.ctl) – Track database structure and SCN. ✅ Redo log files (.log) – Record all changes for recovery. ✅ Temporary & Undo tablespaces – Handle transactions and rollback. ✅ Archived ..read more
Visit website
Edition of Oracle Database
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1w ago
  Oracle Database comes in different editions, each designed for specific use cases, from small businesses to large enterprises. Here’s a breakdown of the available Oracle Database Editions: 1. Oracle Database Standard Edition 2 (SE2) ? Designed for small to medium-sized businesses. ? Supports basic high availability with Oracle RAC (up to 2 nodes). ? Limited to 16 CPU threads (across a maximum of 2 sockets). ? No advanced features like Partitioning, Data Guard, or In-Memory. ? Cost-effective compared to Enterprise Edition. 2. Oracle Database Enterprise Edition (EE) ? Full-featured enter ..read more
Visit website
Introduction to Oracle Database
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1w ago
In this article , I am going to give you brief about what is Oracle database .  Before going to deep dive let's discuss some basic terminology :- What is Data ? Data is fact or figures , Data is any collection of facts, statistics, or information that can be stored, processed, and analyzed. It can exist in various forms, such as numbers, text, images, audio, or video. In computing and databases, data refers to raw information that is stored in structured or unstructured formats. Structured data: Organized in databases, tables, and spreadsheets (e.g., customer records, sales transactions ..read more
Visit website
How to set autocommit off in postgreSQL ?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  postgres=# \set AUTOCOMMIT off postgres=# postgres=# \echo :AUTOCOMMIT off postgres ..read more
Visit website
How to check autocommit in PostgreSQL ?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  postgres=# \echo :AUTOCOMMIT on postgres ..read more
Visit website
How to check command history in PostgreSQL ?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  postgres=# \s \d \l \l \c \c postgres select pg_backend_pid(); alter user postgres password 'abcd12345'; \c demo \c \l \c \l select * from pg_database; show data_directory show data_directory; show data_directory; select setting from pg_settings; select * from pg_settings; show data_directory; \q \conninfo SELECT * FROM pg_settings WHERE name = 'port'; \c \! \! ls -lrt \s \d \l \s postgres ..read more
Visit website
How to execute OS command from psql prompt ?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  postgres=# postgres=# \! bash-4.4$ bash-4.4$ bash-4.4$ ls -la total 16 drwx------.  3 postgres postgres   79 Jan 15 08:33 . drwxr-xr-x. 47 root     root     4096 Jan 10 12:04 .. drwx------.  4 postgres postgres   51 Jan 10 12:05 16 -rw-------.  1 postgres postgres 1405 Jan 15 12:17 .bash_history -rwx------.  1 postgres postgres  391 Jan 15 08:33 .bash_profile -rw-------.  1 postgres postgres  352 Jan 15 10:00 .psql_history bash-4.4$  postgres=# postgres=# postgres=# postgres=# \! ls -lrt total 0 ..read more
Visit website
How to check database directory in PostgreSQL ?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  postgres=# show data_directory;      data_directory ------------------------  /var/lib/pgsql/16/data (1 row) postgres ..read more
Visit website
How to check port in postgreSQL?
ORACLE DATABASE PROBLEM AND SOLUTIONS
by
1M ago
  How to check which port running our postgreSQL database ? [postgres@myserver ~]$ netstat -plunt |grep postgres (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      5963/postgres tcp6       0      0 ::1:5432                :::*      ..read more
Visit website

Follow ORACLE DATABASE PROBLEM AND SOLUTIONS on FeedSpot

Continue with Google
Continue with Apple
OR