Feed aggregator

PeteFinnigan.com is now HTTPS

Pete Finnigan - Wed, 2025-05-14 03:22
It has been a long time coming but I have finally got this website running on HTTPS / SSL. Google have been pushing webmasters and site owners to move to HTTPS for more than 10 years. Google in fact stated....[Read More]

Posted by Pete On 13/05/25 At 02:07 PM

Categories: Security Blogs

Embed Scripting Languages in PL/SQL Programs

Pete Finnigan - Wed, 2025-05-14 03:22
One of the goals of creating an interpreter written in PL/SQL to execute a custom language was for our use in our tools. We wanted to be able to ship PL/SQL and customise it after its deployed without re-compiling the....[Read More]

Posted by Pete On 14/04/25 At 12:11 PM

Categories: Security Blogs

The search for existing encryption and wallets in the database

Pete Finnigan - Wed, 2025-05-14 03:22
In the first blog in this series we discussed the main issue with using DBMS_CRYPTO to encrypt data within the database. This is the lack of key management provided by Oracle natively for use with this package. I had intended....[Read More]

Posted by Pete On 07/04/25 At 01:25 PM

Categories: Security Blogs

Encryption Key Management with DBMS_CRYPTO

Pete Finnigan - Wed, 2025-05-14 03:22
I often get asked how to use DBMS_CRYPTO to encrypt data in the Oracle database. Or I used to be asked how to use DBMS_OBFUSCATION_TOOLKIT when it was the go-to encryption in an Oracle database. Before we go far; this....[Read More]

Posted by Pete On 02/04/25 At 02:22 PM

Categories: Security Blogs

Update on Oracle Security

Pete Finnigan - Wed, 2025-05-14 03:22
Just an update as I have not posted too many blogs recently. I have a bag log of blog ideas to write on technical subjects directly relating to Oracle security so please watch out for those by subscribing / following....[Read More]

Posted by Pete On 19/03/25 At 03:00 PM

Categories: Security Blogs

AI and Oracle Security

Pete Finnigan - Wed, 2025-05-14 03:22
Can we use AI in Oracle security? - yes as an answer? we can but how effective it would be means the answer is maybe? It depends on what we want to use AI for and how much data is....[Read More]

Posted by Pete On 27/02/25 At 03:35 PM

Categories: Security Blogs

Free Licenses for Oracle Security Software

Pete Finnigan - Wed, 2025-05-14 03:22
We are holding a 3 day live, in person training event here in York, UK on March 11th to March 13th 2025 (Tuesday to Thursday). The class is taught by Pete Finnigan. The class is a unique event and will....[Read More]

Posted by Pete On 19/02/25 At 10:32 AM

Categories: Security Blogs

3 Day Oracle Security Training in York in March

Pete Finnigan - Wed, 2025-05-14 03:22
Our recent 3 day Oracle Security training class in York scheduled in January was popular and a lot of people who enquired for the January class asked if we could do the class again in March. I decided to do....[Read More]

Posted by Pete On 06/02/25 At 10:22 AM

Categories: Security Blogs

"proper" way to join v$session and v$sqlarea

Tom Kyte - Tue, 2025-05-13 03:19
Hello, a few questions: 1. All of the scripts I have written years ago use both address and hash_value to join v$session and v$sqlarea. What I don't quite understand is why it's not sufficient to just join on hash_value (or sql_id). Why was/is address also needed? Doc ID 43716.1 seems to indicate both should be included when doing the join. SQL_ADDRESS RAW(4|8) Used with SQL_HASH_VALUE to identify the SQL statement that is currently being executed. ----> Joins to <<View:V$SQL>> . ADDRESS / HASH_VALUE SQL_HASH_VALUE NUMBER Used with SQL_ADDRESS to identify the SQL statement that is currently being executed. ----> Joins to <<View:V$SQL>> . ADDRESS / HASH_VALUE 2. If I wanted to instead use v$sqlstats, it seems the best way to join v$session to that view is to use sql_id? Note my use-case for doing these joins in the above two questions is to get the full SQL text. 3. Why was Bug 27760729 (for SQL_FULLTEXT in v$sqlstats not actually showing the full SQL text) closed out as not a bug?!?
Categories: DBA Blogs

Sequence will skip some numbers

Tom Kyte - Tue, 2025-05-13 03:19
Hi, I have a sequence skip number problem. I have this sequence. The cache is 20 and noorder. <code> create sequence seq_serial_no minvalue 1 maxvalue 999 start with 2 increment by 1 cycle </code> The current situation that has arisen is: I have two servers A and B. They connect to the same database instance. Sometimes the sequence is incremented, but sometimes it jumps, and every time it jumps, it jumps to the last_number. Here is two examples. The first example: server value -- comment B 201 2025/04/23 9:14 A 202 2025/04/23 9:22 A 221 2025/04/23 10:35 --skip B 222 2025/04/23 11:08 A 241 2025/04/23 13:22 --skip B 242 2025/04/23 15:13 A 261 2025/04/23 17:41 --skip The second examples: server value -- comment A 541 2025/05/08 14:36 B 542 2025/05/08 15:12 A 561 2025/05/09 9:28 -- skip B 562 2025/05/09 10:18 A 563 2025/05/09 10:46 A 581 2025/05/12 9:17 -- skip B 582 2025/05/12 9:23 A 583 2025/05/12 10:30 B 601 2025/05/12 14:53 -- skip A 602 2025/05/12 15:19 The skipping of numbers looks like it has something to do with the cache being cleared. May I ask if my guess is correct? If it is right, then what would clear the cache for SGA?
Categories: DBA Blogs

Gather Schema Stats

Tom Kyte - Mon, 2025-05-12 12:17
Hope you're doing well. I'm reaching out to get your inputs on statistics gathering in our Oracle Autonomous Database (version 19c), which we use to support our integration workloads. We have a few very large tables (approximately 70 million records each) that serve as history tables for archiving and auditing purposes. On a daily basis, we dump data from staging tables into these history tables. Since these tables are not frequently queried, we have historically not gathered statistics on them regularly. However, we've recently observed some performance degradation when querying these tables. To address this, we are considering to run GATHER_SCHEMA_STATS nightly on entire schema. We are assuming this could help improve performance. But, we are not very familiar with the DBMS_SCHEMA_STATS APIs. Based on the documentation we are planning to run the following <code> DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'XXDB' , estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE , method_opt => 'FOR ALL COLUMNS SIZE AUTO' , cascade => TRUE); </code> Could you please let us know if this is the right approach to gather schema stats? By any chance if yo have any automation scripts created for this purpose to refer? Thanks in advance.
Categories: DBA Blogs

Upload XLSX file to table in oracle apex

Tom Kyte - Mon, 2025-05-12 12:17
I want to upload multiple XLSX files, each containing multiple sheets. The data from each sheet should be inserted into a table with the same name as the sheet (the tables already exist) using Oracle APEX. Is this possible?
Categories: DBA Blogs

After Insert Trigger, Synchronous or Async

Tom Kyte - Mon, 2025-05-12 12:17
Hi Tom, What I need to do is, to monitor a table for changes. For this a trigger needs to be setup. But my doubt is, if we create a trigger after insert or update of my table column on my table for each row, and the trigger does some time consuming task like DBMS_LOCK.SLEEP (60*1), will this block subsequent inserts? I mean, will the next insert be able to run only after the sleep? In short, Is, after insert trigger is blocking or not? Will the cost of trigger amount to the cost of insert statement? I know the before statement will. But it is really confusing for after insert. Thanks in advance, Jimson
Categories: DBA Blogs

Learn Skills That Help You

Michael Dinh - Mon, 2025-05-12 08:46

At a young age, Jerry gave me the book Looking Out for #1 by Robert J. Ringer.

I am reminded of my dear departed friend (Jerry Roberts) for his friendship and wisdom.

Learn to invest.

Pages

Subscribe to Oracle FAQ aggregator