(Jeff Smith) I sometimes get a double-take when I do a blog post or tweet or show a picture of SQL Developer running on my Mac. My Macbook is my personal machine: I don’t normally do live-demo’s on it, but I almost always do my blog posts and screenshots from there.
Tag: Oracle
Wrong Results Involving INDEX FULL SCAN (MIN/MAX) in 12.1.0.2
(Christian Antognini) One of my customers that recently upgraded to 12c hit a bug (22913528) that I think is good to be aware of. Note that as the title of this post states, the problem only occur in 12.1.0.2. At least, I wasn’t able to reproduce it in any other version.
Big Data SQL Quick Start. Security – Part4.
(Alexey Filanovskiy) Big Data SQL is the way to acsess data that stored in HDFS through Oracle RDBMS, using Oracle external table mechanism. In context of security “table” is key word, which means that you may apply standard security approches to those tables. Today I want to give you couple example
Analyzing Performance
(amitzil) People ask me quite a lot about how I analyze performance issues. While I have some guidelines, there is no complete answer to this question. The actions I take depend on the situation, and there are many many different scenarios when talking about performance problems.
Can Oracle SQL Developer do that?
(Jeff Smith) Here’s a quick run-down of FAQ’s I get when doing presentations or demos.
Active and Inactive Sessions
(connormcdonald) Most people are aware of the STATUS column in V$SESSION. If it’s ‘ACTIVE’ then that connection is in the process of consuming database resources (running a SQL statement etc).
TRUNCATEing a Table makes an UNUSABLE Index VALID again
(Hemant K Chitale) If you set an Index to be UNUSABLE but later issue a TRUNCATE TABLE, the Index becomes VALID again — i.e. the Index gets updated with rows subsequently inserted.
EM13c Corrective Actions
(Kellyn Pot’Vin-Gorman) While at Collaborate 2016, a number of us were surprised that people still aren’t using Corrective Actions and in EM13c, there are a number of cool ones built into the system to make your life easier.
SQL Pattern Matching Deep Dive – Part 2, using MATCH_NUMBER() and CLASSIFIER()
(Klaker) Welcome to the second post in this deep dive series on SQL pattern matching using the new MATCH_RECOGNIZE feature that is part of Database 12c. In the first part of this series we looked at the areas of ensuring query consistency, how to correctly use predicates and how to manage sorting.
Oracle Advanced Analytics on Oracle Cloud
(Brendan Tierney) You have heard about the cloud? Right? Even the Oracle Cloud?
