Category Archives: Database Stuff
How to kick your Oracle Career up several notches or How speaking at Oracle users groups gave me back my passion for my profession. #ACE #ILOVEMYJOB #ODEVCHOICE
Please vote in the Oracle Developers Choice Awards. You need to log into your OTN account. You don’t have to vote for me, but I would appreciate it. Oracle Developers Choice Awards Here is the link for database design … Continue reading
Don’t get invited to sit in front of a Congressional Committee. #Oracle #TDE August 27, 3PM EST #INFOSEC
Register here: https://attendee.gotowebinar.com/register/7938280806383993602 Sponsored by @ODTUG
#Oracle #TDE Ghost Data Teaser
Here is a teaser for the Oracle Transparent Data Encryption presentation We look at having an existing table with existing indexes. A policy comes out that says we need to encrypt SSN and Credit Card Numbers. Once we encrypt the … Continue reading
Posted in Database Stuff, encryption, infosec, Security
Tagged Encryption, GHOST, infosec, oracle
Leave a comment
Oracle #OTN #OPSEC #TMTT
Oracle Technology Network Two Minute Tech Tip. Oracle Transparent Data Encryption.
Posted in Database Stuff, encryption, infosec, Security
Tagged Encryption, GHOST, infosec, oracle
Leave a comment
Oracle Transparent Data Encryption Baseline Practices webinar
I will be giving a webinar on Oracle Transparant Data Encryption Baseline Practices August 27, 2015 at 3PM. Sponsored by @odtug Why “Baseline Practices?” well best practices does not seem to be working so we are going to start improving … Continue reading
#Oracle #TDE #dataleak #Histograms
While at #KSCOPE15, I was asked about encrypted data showing up in histograms. So, I ran a few experiments and learned that encrypted data does indeed leak. I contacted Oracle through an old friend to get their input. Here is … Continue reading
Oracle Transparent Data Encryption Performance. Oracle 12.1.0.2 on Linux 5
Some performance test on Oracle TDE. I have three tables t1, t2 and t3. All three tables have identical data and 1.6M rows. I’m going to come back and visit this a bit more later, but want to get … Continue reading
#Oracle #In-Memory
I started to play with in-memory to see what performance improvements I can get. I set up four tables, zip, customers, products and sales and executed a simple queries against them. Sales has 3M rows, and customers has 110K rows, … Continue reading
OTN Two Minute Tech Tip – SYS_CONTEXT to help secure your database
My Two minute tech tip with OTN on using sys_context to help you secure your database. We can use the values returned from sys_context along with Virtual Private Databases, Fine Grained Auditing, and Redaction to lock down the sensitive data.
Posted in Database Stuff, Security
Leave a comment
#infosec #encrypt backups with #rman
Why should you encrypt your backups? Why should you test your backups? I will be speaking on Holistic Database Security at #kscope15 and #harmony15
#infosec #Oracle data #redaction
I had a rather disturbing conversion with my wife a couple nights ago, she had called a service provider to discuss a bill. The customer service rep asked her for her social security number to verify her identity. When my … Continue reading
RDBMS Vs NoSQL
What are the use cases for the RDBMS vs. NoSQL?
Posted in Database Stuff
Leave a comment
Insert Performance analysis part 2
I promised I would have more today. Here is the raw data from my analysis. As you can see as rejection (dup_val_on_index) increased, the execution time for select + insert decreased and execution time increased for insert with exception. This … Continue reading
Posted in Database Stuff
Leave a comment
Insert performance on a unique constraint.
In the past, I have read about the performance of exception handlers and all that is said is, There is performance overhead. Okay, the generic answer of “performance overhead” tells us nothing. One of the great pleasures of what I … Continue reading
displaying histograms of date and number data
It started with a bit of pl/sql in an ole’ library of mine. Knowing the old code was not the best way to display histogram data and If you can do something in one sql statement then that’s how you … Continue reading
Why does the Oracle cbo interest me so much?
There is a short answer and a very long answer to this. I will try and keep the answer somewhere in the middle of short and long. The first assumption we must accept and from my observations over the past … Continue reading
Expand your DBA skills to include #Bigdata
Big data is more then having petabytes of information. Data is coming at you fast. The data may be structured or unstructured. Expand your DBA skills to be more valuable to your employer and master big data. DBA to Big … Continue reading
Posted in Database Stuff
Leave a comment
Oracle 10053 trace viewer
There are two trace files that I use when tuning. Cary Millsap @CaryMillsap and Method-R @MethodR have a great tool for analyzing the 10046 trace file. There is the profiler and my personal favorite mrskew http://method-r.com/store . But the 10053 … Continue reading
A quick reference to Outer joins
I frequently have to stop and think what side the (+) goes on for outer joins. I found this graphic originally from: http://oakweb02.oaktable.net/node/6628
Posted in Database Stuff
Leave a comment
What about NULL
What is NULL? Is NULL a space? Is NULL a NULL string? NULL is unknown. If null is unknown then you can not do anything with null. You can not perform any operation on null: Y := 5+UNKNOWN then Y=UNKNOWN … Continue reading
Posted in Database Stuff
Leave a comment
Beyond the basic select statement: Using the WITH clause inline SUBQUERY
We looked at the with statement with embedded PL/SQL, now lets look at another use of the with statement. This time we are going to use it with embedded subqueries. Query A This query searches a stocks table, returns the … Continue reading
Beyond the basic select statement: Using the WITH clause inline PL/SQL
For years I used the basic select statement: SELECT A.C1, A.C2, B.C1, B.C2, <…> FROM TAB1 A, TAB2 B WHERE A.C1 = B.C1; Sometimes this basic select statement would not answer my question. You can make a select statement quite … Continue reading
Exploring the CBO
Lets start with a simple experiment on what the CBO can do with query optimization. We are going to build on the structure as we go to see if we can help out the CBO with more information. Test 1) … Continue reading
Posted in Cost Based Optimizer, Database Stuff
Leave a comment
something about the cbo was bothering me
A query similar to this was getting a full table scan. Now we know the NDR in archived, deleted and flag is 1. My initial thought was because of this we would get a full table scan. I was wrong, … Continue reading
Foreign Keys and indexes
In this test case we are going to use two tables with a foreign key. The question is, if we create a foreign key, do we need to add an index on that foreign key column? OPS$ORACLE@VETDEV > create … Continue reading
Posted in Database Stuff
Leave a comment