DBA Blogs

Issue with OR expanding and subquery

Tom Kyte - Wed, 2017-01-18 18:06
<code>Hi Tom I have an issue with OR expansion. Using literals, the OR conditions are expanded neatly. However, I am unable to make the optimizer come up with a plan that uses the index, when I use a subquery. drop table t1; drop table t2; ...
Categories: DBA Blogs

Degree of Parallelism (DOP) of Index

Tom Kyte - Wed, 2017-01-18 18:06
Hi Team, As part of a daily housekeeping practice I executed the below commands for an index rebuilding activity : ALTER INDEX DLM_RAMBO_ILQ_PK REBUILD ONLINE PARALLEL 12 NOLOGGING; ALTER INDEX RAMBO_ILQ_IDX2 REBUILD ONLINE PARALLEL 12 N...
Categories: DBA Blogs

Rename index with DBMS_METADATA

Tom Kyte - Wed, 2017-01-18 18:06
Hi, I am trying to change the name of an index using DBMS_METADATA ,but it seemingly does not works on the index name. Please let me know if I am doing something wrong. Best Regards, Manas drop table a; create table a (a clob); drop...
Categories: DBA Blogs

Refreshing SQL Profiles

Tom Kyte - Wed, 2017-01-18 18:06
Recently I had a performance issue where the solution was to drop the exising SQL profile. SQL profiles contain "auxiliary statistics specific to a SQL statement". These can of course get stale if the data in the tables referenced by the statement ...
Categories: DBA Blogs

Security lockdown - revoke all privileges from PUBLIC

Tom Kyte - Wed, 2017-01-18 18:06
Hi guys, I'm working on a system which requires good security, and therefore must operate on a minimum privilege basis. Naturally I've read the CIS recommendations and applied them, as well as DISA STIG, and disabled all default accounts etc. ...
Categories: DBA Blogs

spool output columns in seperate csv column - call from SQL developer

Tom Kyte - Wed, 2017-01-18 18:06
additional question to the question from yesterday : : http://asktom.oracle.com/pls/apex/f?p=100:12:0::NO::P12_ORIG,P12_PREV_PAGE,P12_QUESTION_ID:Y,1,9532893700346545049 I'm using the SQL developer for starting scripts. additional question: ...
Categories: DBA Blogs

Compound Principle Amount and Profit Calculation

Tom Kyte - Wed, 2017-01-18 18:06
Hi Tom, Hope you are at the best of you health. I have following table structure with sample data. CREATE TABLE investments ( investment_date DATE, registration_no VARCHAR2(100), amount NUMBER, profit_rate NUMBER...
Categories: DBA Blogs

Refreshing nested materialized views

Tom Kyte - Wed, 2017-01-18 18:06
Hi, When I have 2 materialized views (MV_1A and MV_1B) that are based on the same materialized view (MV_1) then using dbms_mview.refresh with the nested=>true option on 1 of those materialized views invalidates the other materialized view. As I un...
Categories: DBA Blogs

Partner Webcast – Developing Hybrid Mobile Applications with Oracle JET

Oracle Javascript Extension Toolkit (Oracle JET) is a modular open source toolkit based on modern JavaScript, CSS3 and HTML5 design and development principles. It is a collection of open...

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

Column data conversion

Tom Kyte - Tue, 2017-01-17 23:46
hi sir, My project employee table one column values are(w,w,w,w,w,nw,nw) here(w means working , nw means notworking) then result column value are (Su/M/Tu/W/Th9-17) Su -- sunday M -- Monday . . . . convert column values int...
Categories: DBA Blogs

Edition based redefinition- Data handelling

Tom Kyte - Tue, 2017-01-17 23:46
Hi, I am using EBR to upgrade from one application version to another with zero downtime. Definitely, this includes migration DB scripts to be run to migrate from one version to another. The requirement is that the migration scripts have some DMLs...
Categories: DBA Blogs

can i cache a table on active physical standby dataguard database

Tom Kyte - Tue, 2017-01-17 23:46
can i cache a table on active physical standby dataguard database?or?if not?can it be a new feature in the future
Categories: DBA Blogs

Parsing json file

Tom Kyte - Tue, 2017-01-17 23:46
<code>I'm trying to parse out a the [confirmation_code] value in the following json data. Is there a way I can quickly do this using a feature in Oracle 12c? stdClass Object ( [1] => stdClass Object ( [1] => Array ...
Categories: DBA Blogs

apex version usage

Tom Kyte - Tue, 2017-01-17 23:46
I have been very intrigued that asktom is an apex app. knowing that it has been brought into apex 5.x, I am wondering if our experts could tell me whether apex has moved forward so much from 4.2.6 that I should chuck all my 4.x-based books and move ...
Categories: DBA Blogs

Non partition to composite partition.

Tom Kyte - Tue, 2017-01-17 23:46
Hi team, Can you please let me know steps to convert non partition table to partition table. suppose i have sales table in that i want year wise range partition and later in range partition i want list partition. Please help to achieve thi...
Categories: DBA Blogs

Sending Mail Through Oracle Which Has HTML Table Content Or Sending mail Through Attachment Using Oracle

Tom Kyte - Tue, 2017-01-17 23:46
<code>Team, Good Monday Morning !!!!!! we are facing difficulty in sending mail through oracle code, for the data being retrieved from one or more data base tables .(Issue arises when the data is huge) The records fetched from the query sha...
Categories: DBA Blogs

SQL loader to load data from excel spreadsheet

Tom Kyte - Tue, 2017-01-17 23:46
Hi Team, The scenario is. we have saved an excel file in a folder. how can i load the data from excel sheet to oracle table. i am using oracle 11g. how can we approach this using SQL loader. please help us guys please post if any lin...
Categories: DBA Blogs

Run bash scripts from application server for DBA tasks on DB server

Tom Kyte - Tue, 2017-01-17 23:46
Hello Tom, We do not want to DBA enterprise manager and instead want to create a bash scripts to perform DBA tasks. The scripts will be residing on another server and we have a separate DB server. Can we perform below DBA tasks from remote se...
Categories: DBA Blogs

Insert statements

Tom Kyte - Tue, 2017-01-17 23:46
Hi, An Application has been sending insert statements to DB continuously from past two days. I would like to know the time gap between the insert statements. Thanks & Regards Krishna.
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs