Please turn JavaScript on
header-image

Anuragkumarjoy

Follow Anuragkumarjoy's news and updates in a matter of seconds! We will deliver any update via email, phone or you can read them from here on the site on your own news page.

You can even combine different feeds with the feed for Anuragkumarjoy.

Subscribing and unsubscribing is fast, easy and risk free.

The whole service is free of cost.

Anuragkumarjoy: ORACLE DATABASE PROBLEM AND SOLUTIONS

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.34 / day

Message History

Key Differences between AMM and ASMM & 19c Best Practices


AMM (Automatic Memory Management) -  (MEMORY_TARGET):

How it works: Oracle automatically distributes memory between SGA and PGA.


Pros: Simplest to configure; dynamic resizing across both areas.


<...


Read full story

Which is better for minimizing swap usage?


 AMM (Automatic Memory Management)

MEMORY_TARGET 

 ASMM (Automatic Shared Memory Management) 

SGA_TARGET


In most real-world Oracle deployments, using manual memory management (i.e., SGA_TARGET + PGA_AGGREGATE_TARGET) results in lower swap usa...


Read full story
Oracle AI Database 26ai – Supported Free Platforms


The Oracle AI Database 26ai Free tier can be deployed on the following platforms:


Oracle Linux 8 (OL8 / RHEL 8)Oracle Linux 9 (OL9 / RHEL 9)Oracle Linux 8 for ARM (aarch64)Docker / PodmanOracle VirtualBoxMicrosoft Windows (64‑bit)



Client Tools and Languages for Connec...

Read full story

 


postgres=#

postgres=#

postgres=#

postgres=# \c demo

You are now connected to database "demo" as user "postgres".

demo=#

demo=#

demo=# \l demo

 demo | postgres | UTF8     | libc            | English_India.1252 | English_India.1252 |    &nbs...


Read full story

 

postgres=#

postgres=#

postgres=# create database demo;

CREATE DATABASE

postgres=#

postgres=# \l

 demo      | postgres | UTF8     | libc            | English_India.1252 | English_India.1252 |        |           |


Read full story