Andrew's Oracle Blog
International Dba Blog Spot. Over 500 worked examples using versions 9 through 12 of the Oracle RDBMS..
Read International-dba.blogspot.com news digest here: view the latest International Dba Blog Spot articles and content updates right away or get to their most visited pages. International-dba.blogspot.com is not yet rated by Alexa and its traffic estimate is unavailable. It seems that International Dba Blog Spot content is notably popular in USA. We haven’t detected security issues or inappropriate content on International-dba.blogspot.com and thus you can safely use it. International-dba.blogspot.com is hosted with Google LLC (United States) and its basic language is English.
- Content verdict: Safe
- Website availability: Live
- Language: English
- Last check:
-
N/A
Visitors daily -
N/A
Pageviews daily -
N/A
Google PR -
N/A
Alexa rank
Best pages on International-dba.blogspot.com
-
Andrew's Oracle Blog: ORA-12954
Over 500 worked examples using versions 9 through 12 of the Oracle RDBMS.
-
Andrew's Oracle Blog commit statements between a end. Assuming this is appropriate for your application, it can produce two benefits: (1) If the code runs for a long time, it allows you to monitor p...
-
Andrew's Oracle Blog: log file switch (archiving needed)
SQL> SQL> exec dbms_lock.sleep(10); PL/SQL procedure successfully completed. SQL> ... and when I looked again, the seconds_in_wait had increased by 10 seconds too, proving that the session was sp...
International-dba.blogspot.com news digest
-
2 years
Oracle to Postgres Migration Issue with Commit
If you have some PL/SQL, Oracle allows you to include commit statements between a begin and end. Assuming this is appropriate for your application, it can produce two benefits:
(1) If the code runs for a long time, it allows you to monitor progress by running select statements from a separate session.... -
2 years
Minor Problem with Resumable Session
Oracle started allowing sessions with space issues to hang rather than fail in version 9. I had always assumed this only worked if a tablespace ran out of space. However, I read recently that it also works for quota failures so I decided to try this...
-
3 years
How Auditors Might Be Cracking Your Oracle Passwords
I have often wondered how auditors crack Oracle passwords, particularly if the user concerned has a profile which locks the account after a few unsuccessful login attempts. I just realised today how they might be doing it. First I created a user in an...
-
3 years
Oracle apparently introduced list partitioning in Oracle 9. I decided to try it out in an Oracle 11 database.
In this simple example I created a table to store the names of towns in Buckinghamshire, together with the people living in each one:
SQL> create table buckinghamshire_people...
Domain history
Web host: | Google LLC |
Registrar: | MarkMonitor Inc. |
Registrant: | Google LLC |
Updated: | June 29, 2023 |
Expires: | July 31, 2024 |
Created: | July 31, 2000 |
Whois record
Safety scores
Trustworthiness
N/AChild safety
N/A