Feed aggregator

Stat gather impact on production environment

Tom Kyte - 4 hours 19 min ago
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 - 4 hours 19 min ago
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 - 4 hours 19 min ago
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 - 4 hours 19 min ago
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 - 11 hours 5 min ago
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 - 13 hours 19 min ago
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 - 13 hours 19 min ago
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 - 13 hours 19 min ago
<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 - 13 hours 19 min ago
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

Data archival and purging for OLTP database.

Tom Kyte - Sat, 2019-10-19 15:45
Hi Tom, Need your suggestion regarding data archival and purging solution for OLTP db. Currently we are planning to have below approach. database is size is 150 Gb and planning to run the jobs monthly. 1) Generate flat files from table based on...
Categories: DBA Blogs

Job to end in case connection not establishing with utl_http.begin_request

Tom Kyte - Sat, 2019-10-19 15:45
i am tracking around 17000 orders through a web service through pl/sql to a destination server. i am running multiple jobs in batches(for 500 orders each job) for invoking webservice to get the order status. so around 34 jobs are running (17000/500) ...
Categories: DBA Blogs

Inserting values into a table with '&'

Tom Kyte - Sat, 2019-10-19 15:45
Hi, I want to insert a values into a table as follows: create table test (name varchar2(35)); insert into test values ('&Vivek'); I tried the escape character '\' but the system asks for a value of the substitution variable. I also did a...
Categories: DBA Blogs

SELECT ANY DICTIONARY - What Privileges Does it Have - SELECT_CATALOG_ROLE

Pete Finnigan - Sat, 2019-10-19 15:45
There has been a few blog posts over the years discussing what is the difference between SELECT ANY DICTIONARY and the SELECT_CATALOG_ROLE. Hemant posted in 2014 about the difference between SELECT ANY DICTIONARY and SELECT_CATALOG_ROLE . This post was a....[Read More]

Posted by Pete On 11/10/19 At 01:59 PM

Categories: Security Blogs

What Privileges Can you Grant On PL/SQL?

Pete Finnigan - Sat, 2019-10-19 15:45
Oracle has a lot of privileges and models; privileges can be granted to users, roles and also since 12c roles can be granted to PL/SQL code (I will not discuss this aspect here as i will bog separately about grants....[Read More]

Posted by Pete On 08/10/19 At 01:43 PM

Categories: Security Blogs

ORA-01950 Error on a Sequence - Error on Primary Key Index

Pete Finnigan - Sat, 2019-10-19 15:45
I posted yesterday a blog about an error on a sequence of ORA-01950 on tablespace USERS - ORA-01950 Error on a Sequence . This was attributed to the sequence by me because that's where the error in Oracle was pointing....[Read More]

Posted by Pete On 01/10/19 At 01:12 PM

Categories: Security Blogs

Pages

Subscribe to Oracle FAQ aggregator