DBA Blogs

GDPR - backups and database design

Tom Kyte - Wed, 2018-01-31 06:26
Really surprised to see that nobody had any queries posted on the impacts on backup strategies related to GDPR. There is a clause which says right to erase personal data with respect to the GDPR and we are thinking on the possible ways the backup ...
Categories: DBA Blogs

Open database read only

Tom Kyte - Tue, 2018-01-30 12:06
What is a command to change DB open mode from read write to read only without restarting the instance
Categories: DBA Blogs

How to find last inserted records from table

Tom Kyte - Tue, 2018-01-30 12:06
HI TOM, PLEASE EXPLAIN How to find last inserted records from table? IN ORACLE? THANKS BALA
Categories: DBA Blogs

Obtain all JSON keys from JSON columns

Tom Kyte - Tue, 2018-01-30 12:06
Hello, Is there a way to get all the keys that exist in a JSON column? JSON_VALUE function provides an easy way to access a value for a given key, but is there a way to obtain all the key names? Thanks, Gabi
Categories: DBA Blogs

Multiple SQL Profiles for one SQL

Tom Kyte - Tue, 2018-01-30 12:06
Is it possible to have multiple SQL Profiles for same query?
Categories: DBA Blogs

Database Performance Different Plans after Database Migration

Tom Kyte - Tue, 2018-01-30 12:06
I am facing the issue with database performance. Earlier, my database was running on XSeries Platform, Solaris OS. Then I migrated whole data and object to SPARC Platform. Both Servers have a bit different specs. For XSeries, data stores on S...
Categories: DBA Blogs

Re-enable of foreign key constraint takes a long time

Tom Kyte - Tue, 2018-01-30 12:06
I have two 11.2.0.3 databases on Solaris 11 64bit. They both have the same schemas. One is approx. 1GB and the other is approx. 10GB. On both databases, there is a parent and child table with similar number of records (~300k records each). Fr...
Categories: DBA Blogs

conceptual question regarding ODBC driver

Tom Kyte - Tue, 2018-01-30 12:06
Hi Tom: I used to work as a analyst who developed SQL queries mainly using SQL developer and SSIS, and recently I have moved to a new team which I have slightly different role , leading me to some questions I never consider before. I am not so sur...
Categories: DBA Blogs

Partner Webcast - Oracle Big Data Cloud Service – Compute Edition: Getting Started Hands-on

Oracle Cloud provides several big data services and deployment models. The big data service choices enable you or your customer to start at the cost and capability level suitable to your use case and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Index Skip Scan: Potential Use Case or Maybe Not ? (Shine On You Crazy Diamond)

Richard Foote - Tue, 2018-01-30 05:57
While answering a recent question on a LinkedIn forum, it got me thinking whether there’s a potential use case for using an INDEX SKIP SCAN I hadn’t previously considered. I’ve discussed Index Skip Scans previously (as I did here), a feature introduced around Oracle9i that allows an index to be considered by the CBO even […]
Categories: DBA Blogs

Performance issue while processing Huge XML file

Tom Kyte - Mon, 2018-01-29 18:06
I'm seeing performance issue while processing the xml file which has more then 10K records, it's working fine if the file has 100 records. Below is the sample procedure I'm using.. <code>++++++++++++++++ CREATE OR REPLACE PROCEDURE process_xml_fi...
Categories: DBA Blogs

Audit logon and logoff of specific users eg sys and system

Tom Kyte - Mon, 2018-01-29 18:06
Hi, I need to write a trigger to audit logon and logoff activities of specific users 'SYS' and 'SYSTEM'. I have one trigger but its not inserting records into the table mentioned in the trigger. Please, help me to fix the issue.Your help will be...
Categories: DBA Blogs

How to unpivot table data with out displaying column names

Tom Kyte - Mon, 2018-01-29 18:06
Hi Tom, Am working on Oracle DB and below query <code> select t1.id as dbid, t2.mid as askid, t3.m2idd as amid from table1 t1, table2 t2, table3 t3 where t1.actid = t2.senid and t2.denid = t2.mkid ...
Categories: DBA Blogs

SQL query that returns the difference between the latest

Tom Kyte - Mon, 2018-01-29 18:06
Problem Statement [question redacted] Comment from Connor, Jan 29 1018 ================================ You can see from our initial answer that were thrilled that you provided us a complete test case. However, when things seem too good to b...
Categories: DBA Blogs

SQL Query Optimization

Tom Kyte - Mon, 2018-01-29 18:06
We have a table called PROTOKOLL, with the following definition: <code> CREATE TABLE "PROTOKOLL" ( "UUID" CHAR(36 BYTE) NOT NULL ENABLE, "VERSIONSNUMMER" VARCHAR2(20 BYTE), "TYP" CHAR(1 BYTE) NOT NULL ENABLE, "BENUTZER_ID" VARCHAR2(25...
Categories: DBA Blogs

Creating Indexes on Custom Table

Tom Kyte - Sun, 2018-01-28 23:46
Hi Tom, I have below query <code> select a.order_number from xxdm.XXARX_INV_SOURCE_TBL_28_jan1 a,XXARX_INV_CNV_TBL_28th_jan1 b where a.trx_number = b.trx_number and a.customer_number_source = b.customer_number_source and a.trx_number = :t...
Categories: DBA Blogs

ContractOracle.com is for sale

ContractOracle - Sun, 2018-01-28 20:30
If you would like to purchase this domain, email Robert.Geier@ContractOracle.com

This domain is perfect if you are a contractor working with Oracle software. 
Categories: DBA Blogs

Temporary Table Questions

Tom Kyte - Sun, 2018-01-28 04:26
Tom, I have a few questions abt temporary table: 1. Which type of temporary table is better to use in a multi-user applications, a global temporary table with on commit preserve rows or a global temporary table without on commit preserve r...
Categories: DBA Blogs

How to capture user and encrypted password to be used in alter user statement after duplication of database

Tom Kyte - Sat, 2018-01-27 10:06
We perform a duplicate database from prod to test weekly and have a script that captures the current user permissions on dev via the dbms.metadata.get_ddl package that generates DDL to another file to be used after the duplication to re-create any us...
Categories: DBA Blogs

SQLcl spool numeric field as Text

Tom Kyte - Sat, 2018-01-27 10:06
Hello Tom, I love SQLcl for spooling data to a CSV-File for using in Excel. But i have trouble with comma inside a field. This is my SQL-Statement: <code> SET LINESIZE 3000 SET TRIMSPOOL ON SET PAGESIZE 0 SET SERVEROUTPUT ON SET VERIFY...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs