Feed aggregator

FAR SYNC FAILOVER

Tom Kyte - 45 min 6 sec ago
Dear Sir, In case of an outage on the primary database, the standard failover procedure applies, and after some time primary server available then how it going to sync all 3 server. please help me to understand this. Thanks Pradeep
Categories: DBA Blogs

Oracle query running slow

Tom Kyte - 45 min 6 sec ago
Hi Team, we have a SQL query which is a source query for the ETL load job, this take around 3 hours to run, could you please help us how we can make it run faster. The row count of the tables involved are as follows. D_PERSON 4618595 ...
Categories: DBA Blogs

Keep pooI

Tom Kyte - 45 min 6 sec ago
when I assign any of the segment to keep pool , It is nessesary to set appropriate DB_KEEP_CACHE_SIZE as per the sizes of the segment. or it will dynamically set DB_KEEP_CACHE_SIZE?
Categories: DBA Blogs

Limit parallelism

Tom Kyte - 45 min 6 sec ago
Hi ASKTOM team, I am not very good with parallelism, so have a question about DW database. These are my current settings: <code> parallel_adaptive_multi_user boolean TRUE parallel_automatic_tuning boolean FALSE parallel_degree_li...
Categories: DBA Blogs

Log Files in Oracle External Tables

Tom Kyte - 45 min 6 sec ago
My External Tables were working fine before i accidentally deleted all the .log and .bad files from the default location. Now I am getting below error ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-...
Categories: DBA Blogs

(Theoretical) Confusion with roles and public synonyms

Tom Kyte - 45 min 6 sec ago
Hi Tom, <b>Confusion1:- </b> Suppose I have three user accounts in my database: A, B and C. 'A' user has the privilege to create a role. Suppose there is a table named 'employee' in schema 'A' and 'A' issues:- 1. create role GiveAccess; 2...
Categories: DBA Blogs

Stat gather impact on production environment

Tom Kyte - Mon, 2019-10-21 12:45
On OLTP production environment, during huge transaction period, what is an impact if we run the stat gather of used schema for transaction???, It will missed any indexes, and other operation issues???
Categories: DBA Blogs

Best practice for "archiving" legacy tables and their data

Tom Kyte - Mon, 2019-10-21 12:45
Hi, I recently removed the last piece of front-end functionality that relied on a table, and am certain that that table and its data is no longer needed for the application to function. We'll have more similar tables in this situation in the near ...
Categories: DBA Blogs

Fetch across commit

Tom Kyte - Mon, 2019-10-21 12:45
what do you mean by 'Fetch across commit'
Categories: DBA Blogs

Is there a maximum number of schemas that can be included in a datapump par file?

Tom Kyte - Mon, 2019-10-21 12:45
I've been tasked with migrating a very large warehouse database (9TB) from hardware in one data center to new hardware in a different data center. For various reasons, the method I've selected for the migration is datapump. I'm breaking up the data...
Categories: DBA Blogs

Moat Wins Adweek “Reader’s Choice” Award for Best Brand Safety/Verification Solution

Oracle Press Releases - Mon, 2019-10-21 06:00
Blog
Moat Wins Adweek “Reader’s Choice” Award for Best Brand Safety/Verification Solution

By Kurt Kratchman, GVP, Product Development, Oracle Data Cloud—Oct 21, 2019

 

If you want to find the best product or service, you should ask the people who know that product or service best for their recommendations.

Want a reliable dishwasher? Check out the online reviews from appliance installers and repairmen. In the market for a new car?  Explore the consumer satisfaction surveys from thousands of current owners. Searching for the perfect pizza in Pittsburgh? Pick up a copy of the “Best of Pittsburgh” poll in the local City Paper.

The same holds true in digital advertising, which is why we are so honored and delighted to announce that Moat by Oracle Data Cloud is the winner of the 2019 Adweek “Readers’ Choice: Best of Tech” Award for Brand Safety/Verification.

The awards are based on an Adweek reader survey in which more than 50,000 votes were cast by executives from leading brands and agencies for their favorite technology providers and solutions. These experts know our industry the best, as they evaluate and make mission-critical decisions on a daily basis about which technologies, products, and solutions they should use to support their brands.

Equally important, these executives measure success by the real-world impact of their marketing investments. Therefore, they dedicate significant time and resources to finding technology partners who can help keep their brands safe, ensure their ads are viewable, and protect their campaigns from invalid traffic and fraud, which are the cornerstone of our Moat products.

Reinforcing Moat’s industry leadership, MediaPost editor-in-chief Joe Mandese noted in a column last week that Moat “has become the closest thing to a de facto currency for digital audience attention.”

Moat offers a range of products to help customers ensure their advertising dollars are well-spent, including our industry-leading Moat Analytics and Pre-Bid by Moat, which help identify brand-safe, fraud-safe, and viewable inventory before an ad is placed. Part of that solution is Oracle’s Contextual Intelligence, which provides real-time content review and classification across the majority of the addressable footprint of the open web. That functionality gives advertisers greater control over the safety and suitability of content near their ads.

Moat customers, along with their marketing peers, added their strong voice to the vote results. “To be effective, advertising needs to be viewable by real people in brand-safe environments, which is why rigorous standards for ad measurement, verified by third party independent providers is so important,” said Yale Cohen, EVP Digital Investment Ad Standards, Publicis Media. “As a long-term Moat customer, we congratulate the Oracle Data Cloud team on this award.”

“As a Publisher, it is critical we provide our clients with the confidence that their ad dollars are being spent wisely on our platforms,” added Nicole Lesko, SVP Ad Product & Revenue for Meredith Corporation. “As a customer of Moat, we have come to rely on their best-in-class measurement to ensure our inventory is bot-free, viewable and safe across channels.”

Beyond Moat’s win, Oracle Data Cloud’s recognition in the Adweek survey extended across its full product suite, with additional top-three finishes against scores of companies in the categories of Data Supplier (Oracle Data Cloud) and Measurement and Analytics: Digital and Mobile Display Advertising (Moat). In fact, Oracle Data Cloud secured a top-three finish in every one of its product categories from Audience to Measurement and Context.

As a data-driven company, we are delighted that Adweek’s analysis of votes by agency and brand executives supports what hundreds of their peers already know: If you want to protect your brand with the best viewability, fraud, and brand safety solutions, there’s only one Moat.

For more information about Moat by Oracle Data Cloud and the full range of solutions offered, including brand safety, viewability and IVT measurement, please visit Moat.com.

Index Rebuild and analyze

Tom Kyte - Mon, 2019-10-21 03:45
Hello Tom , I have a query regarding Index rebuild . what according to you should be time lag between index rebuilds. We are rebuilding indexes every week .but we found it is causing lot of fragmentation. is there any way we could find out whet...
Categories: DBA Blogs

Views of Views

Tom Kyte - Mon, 2019-10-21 03:45
I remember hearing some time ago that creating views based upon other existing views should be avoided as it can often confuse the optimiser and result in full table scans. I expect that this is just another urban myth however I would be intereste...
Categories: DBA Blogs

Inserts with APPEND Hint.

Tom Kyte - Mon, 2019-10-21 03:45
<code>insert /*+ append */ into t select rownum,mod(rownum,5) from all_objects where rownum <=1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- -----...
Categories: DBA Blogs

Kill a session from database procedure

Tom Kyte - Mon, 2019-10-21 03:45
How i can kill a session from a stored database procedure. There is some way to do this?
Categories: DBA Blogs

Why cost for TABLE ACCESS BY INDEX ROWID to high for only one row

Tom Kyte - Sat, 2019-10-19 15:45
Dear Tom, I have problem with query on table have function base index. create index : <code> create index customer_idx_idno on Customer (lower(id_no)) ; --- id_no varchar2(40) </code> <b>Query 1:</b> execute time 0.031s but cost 5,149, 1 row ...
Categories: DBA Blogs

How to get unique values/blanks across all columns

Tom Kyte - Sat, 2019-10-19 15:45
Hi, I have a wide table with 200 odd columns. Requirement is to pivot the columns and display the unique values and count of blanks within each column <code>CREATE TABLE example( c1 VARCHAR(10), c2 VARCHAR(10), c3 VARCHAR(10) ); / INSERT ...
Categories: DBA Blogs

Elastic search using Oracle 19c

Tom Kyte - Sat, 2019-10-19 15:45
Team, Very recently we got a question from our customer that "can I replace Elastic search using Oracle 19c or any version of Oracle database prior to that"? Any inputs/directions to that please - kindly advice.
Categories: DBA Blogs

Add NULLABLE column with DEFAULT values to a large table

Tom Kyte - Sat, 2019-10-19 15:45
I'm adding a number of columns with DEFAULT values that are NULLABLE to a large table e.g <code> alter table big_table add (col1 varchar2(1) default 0, col2 varchar2(1) default 0); </code> It's taking a long time to do because Oracle is e...
Categories: DBA Blogs

Create table from select with changes in the column values

Tom Kyte - Sat, 2019-10-19 15:45
Hello, In the work we have an update script that takes around 20 hours, and some of the most demanding queries are updates where we change some values, something like: <code> UPDATE table1 SET column1 = DECODE(table1.column1,null,null,'no...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator