Follow Oracle-dba-help'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 Oracle-dba-help.
Subscribing and unsubscribing is fast, easy and risk free.
The whole service is free of cost.
Oracle-dba-help: Learn DBA : A Life Long Learning Experience
Is this your feed? Claim it!
If you have spent years tuning Oracle Database, HugePages is probably second nature to you. You would not even think about running a large SGA without it.
Now, when moving into PostgreSQL, many DBAs assume memory works differently or that HugePages are optional. Technically, they are optional. Practically, ignoring ...
"Can we give this user access, but make sure they cannot change anything?"
Before Oracle AI Database 26ai, DBAs usually handled this by creating a separate reporting user, granting only SELECT, removing DML privileges, or depending on carefu...
A PostgreSQL performance issue rarely starts with one bad setting.
In production, it usually looks like this: the application team says the database is slow, CPU is not always high, storage graphs look confusing, and nobody changed anything “major”. Then we check deeper and find long transactions, dead tuples, stale statistics, unused indexes, ch...
A PostgreSQL table can grow quietly for weeks before anyone notices. The application team says they already deleted old data. Storage still looks high. Queries are touching more blocks than expected. Autovacuum is running, but the table does not seem to become smaller. This is where many DBAs first realize that DELETE in PostgreSQL is not the same as phys...