Feed aggregator

XMLQuery

Tom Kyte - 1 hour 15 min ago
Hi Tom, I am trying to learn XQuery use with SQL but it looks very complicated. Can you please advise with some simple cases (I am not interested in XML generation but using XML and XQuery functions with relational data tables). Where to start? Wh...
Categories: DBA Blogs

Oracle Database - Grant/Revoke High Concurrency

Tom Kyte - 1 hour 15 min ago
We have an Oracle 10g release 2 database running on a production environment. It's experiencing a lot of concurrency, as Sql Developer 17.4 "Waits for past 1 hour" graph shows. When the database is behaving slow, we take a look at that graph, and ...
Categories: DBA Blogs

Can I user automatic List in subpartitions?

Tom Kyte - 1 hour 15 min ago
Dears, I have a table that contains two columns one for year and the other for month. I need to partition this table based on year and month, where year represent the partitions and under that the month represent that sub-partitions. What I need i...
Categories: DBA Blogs

Multiple block allocation to small table

Tom Kyte - 1 hour 15 min ago
Hi, I executed below query on my database and found given output: <code>select a.table_name, a.NUM_ROWS, a.AVG_ROW_LEN, a.LAST_ANALYZED, a.SAMPLE_SIZE, a.blocks from user_tables a where num_rows <10;</code> Output: <code>TABLE_NA...
Categories: DBA Blogs

Nested loop and hash join.

Tom Kyte - 1 hour 15 min ago
Hi Tom, Can you help me in understanding how optimizer decides which join ( hash or nested loop) it will use for joining. Also which is the driving table in nested loop. There are lot of confusing answers on this on internet, which one to rely...
Categories: DBA Blogs

Create a physical standby for 12c RAC

Tom Kyte - 1 hour 15 min ago
hi - this weekend we have a project that is going live. we will be importing data (about 1TB) into the database. after that we want to create the physical standby. what is the best, efficient and most proven way to create a physical standby database ...
Categories: DBA Blogs

How to gather statistics on a standard edition database

Tom Kyte - 1 hour 15 min ago
Hi, I'll like to gather some statistics on long running statements on a standard edition database. Can you please suggest the best way to gather stats on this statement? <code> BANNER ...
Categories: DBA Blogs

Limit and conversion very long IN list : WHERE x IN ( ,,, ...)

Tom Kyte - 1 hour 15 min ago
How many elements may be in the WHERE x IN (,,,) list ? I see 2 ways to overcome IN list limitation: 1) use x=el_1 OR x=el_2 OR x=el_3 OR ... 2) create temporary table , but another question arise here: why create table A( X INTEGER, Y...
Categories: DBA Blogs

Running Code as SYS From Another User not SYSDBA

Pete Finnigan - Wed, 2018-05-23 13:06
I have been embroiled in a twitter thread today about the post i made in this blog yesterday around granting privileges to a user and who should do the granting. Patrick today asked a further question: How do you make....[Read More]

Posted by Pete On 22/05/18 At 08:42 PM

Categories: Security Blogs

Who Should Grant Object Rights?

Pete Finnigan - Wed, 2018-05-23 13:06
Patrick Jolliffe posted a question via a tweet back in April but due to personal health pressures with a close relative of mine I have not had the time to deal with much over the last few months. I did....[Read More]

Posted by Pete On 21/05/18 At 07:08 PM

Categories: Security Blogs

Plaintiffs' Law Firms to Pay Oracle $270,000 to Settle Sanctions

Oracle Press Releases - Wed, 2018-05-23 12:43
Press Release
Plaintiffs' Law Firms to Pay Oracle $270,000 to Settle Sanctions

Redwood Shores, Calif.—May 23, 2018

Today, four plaintiffs’ law firms agreed to pay Oracle Corporation $270,000 to avoid Oracle’s motion for sanctions over their misconduct in a lawsuit related to Oracle’s acquisition of Micros Systems, Inc. in Case No. 13-C-14-099672, in the Circuit Court for Howard County, Maryland.

In 2014, Brower Piven, Robbins Arroyo LLC, Weisslaw LLC, and Pomerantz, LLP, along with other firms, sued Micros and its directors, claiming that Micros’s shareholders were not adequately informed about the transaction and that Oracle’s offer price was too low. The firms also sued Oracle for aiding and abetting the Micros board, despite the fact that Oracle simply engaged in arm’s-length negotiations to obtain the best price possible. The trial court dismissed all claims with prejudice against all defendants, including Oracle, and then courts at every level of the state system rejected five subsequent motions for reconsideration and appeals brought by these firms, affirming the trial judge’s finding that “with respect to Oracle, the Plaintiffs have failed to allege any acts, alleged acts, by agents or employees or Oracle that were impermissible under the law. The mere fact that Oracle pursued the merger is insufficient.” The outrageous litigation conduct drew the sanctions motion by Oracle, which the four firms identified above agreed to settle rather than defend.

“This substantial monetary settlement reflects the strength of our sanctions motion for what Oracle believes was clearly a “strike” suit brought against Oracle. For more than a decade, plaintiffs’ lawyers have brought these suits, challenging legitimate public mergers, in order to line their own pockets at the expense of shareholders. We are grateful that the Maryland courts recognized that the claims had no merit, and we urge other public companies to challenge these baseless suits. Shareholders’ attorneys cannot simply claim and collect what is effectively an unwarranted tax on mergers,” said Dorian Daley, Oracle’s General Counsel.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, SCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE: ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Four Enhancements for Concurrent Processing in EBS 12.1 Now Available

Steven Chan - Wed, 2018-05-23 12:15

We have just released four new enhancements for Concurrent Processing in E-Business Suite 12.1.3:

  1. Storage Strategies for Log and Output File Locations: Create custom storage strategies for management of large numbers of concurrent processing log and output files. Customers can specify the strategy that best suits their particular needs. These strategies are called schemes.
  2. Output File Naming Strategies: The output file naming conventions are now based on USER.REQID and REQID.OUT. The old USER format is desupported.
  3. Timed Shutdown: submit a normal, graceful shutdown and also specify a number of minutes after which an Abort command will be executed. After this number of minutes has passed, and Concurrent Processing has not yet shut down, the graceful shutdown will be converted to an Abort, and all remaining Concurrent Processing processes will be aborted.
  4. 64-bit Java Support for the Output Post-Processor Service: A 64-bit Java Virtual Machine (JVM) is now supported for the Output Post Processor (OPP). This support allows for a larger heap size to be set, compared to the 2G heap size that 32-bit Java allows. This larger heap size will decrease out-of-memory errors. Note that the 64-bit JVM can be run for the OPP service only.

Details about these four new enhancements are published here:

You can download these enhancements here:

Related Articles

 

Categories: APPS Blogs

Users, schemas & privileges in #Exasol

The Oracle Instructor - Wed, 2018-05-23 09:18

Exasol Logo

In Exasol, a database user may own multiple schemas – or even none at all. I connect to my Community Edition to show that:

C:\Users\uh>cd \Program Files (x86)\EXASOL\EXASolution-6.0\EXAplus

C:\Program Files (x86)\EXASOL\EXASolution-6.0\EXAplus>exaplusx64 -c 192.168.56.101:8563 -u sys -p exasol -lang EN

EXAplus 6.0.8 (c) EXASOL AG

Wednesday, May 23, 2018 3:28:29 PM CEST
Connected to database EXAone as user sys.
EXASolution 6.0.8 (c) EXASOL AG

SQL_EXA> create user adam identified by adam;
EXA: create user adam identified by adam;

Rows affected: 0

SQL_EXA> grant dba to adam;
EXA: grant dba to adam;

Rows affected: 0

SQL_EXA> select user_name from exa_dba_users;
EXA: select user_name from exa_dba_users;

USER_NAME
------------------------------------------------------------
SYS
ADAM

2 rows in resultset.

SQL_EXA> select schema_owner,schema_name from exa_schemas;
EXA: select schema_owner,schema_name from exa_schemas;

SCHEMA_OWNER
-------------------------------------------------------------
SCHEMA_NAME
-------------------------------------------------------------
SYS
RETAIL

1 row in resultset.

SQL_EXA> connect adam/ADAM;

Wednesday, May 23, 2018 3:34:42 PM CEST
Connected to database EXAone as user adam.
EXASolution 6.0.8 (c) EXASOL AG

SQL_EXA> create table t1 (n number);
EXA: create table t1 (n number);
Error: [42000] no schema specified or opened or current schema has been dropped [line 1, column 27] (Session: 1601269589413551548)
SQL_EXA> open schema adam;
EXA: open schema adam;
Error: [42000] schema ADAM not found [line 1, column 13] (Session: 1601269589413551548)

Demo user adam has the DBA role granted but there is no adam schema yet. I need to create it first:

EXA: create schema adam;

Rows affected: 0

SQL_EXA> open schema adam;
EXA: open schema adam;

Rows affected: 0

SQL_EXA> create table t1 (n number);
EXA: create table t1 (n number);

Rows affected: 0

SQL_EXA> create schema adam2;
EXA: create schema adam2;

Rows affected: 0

SQL_EXA> create table adam2.t2 (n number);
EXA: create table adam2.t2 (n number);

Rows affected: 0

SQL_EXA> select table_schema,table_name from exa_user_tables;
EXA: select table_schema,table_name from exa_user_tables;

TABLE_SCHEMA
--------------------------------------------------------
TABLE_NAME
--------------------------------------------------------
ADAM
T1
ADAM2
T2

2 rows in resultset.

As you see, user adam has now two schemas with different tables in them. Now briefly to privileges:

SQL_EXA> create user fred identified by fred;
EXA: create user fred identified by fred;

Rows affected: 0

SQL_EXA> grant create session to fred;
EXA: grant create session to fred;

Rows affected: 0

SQL_EXA> grant select on adam.t1 to fred;
EXA: grant select on adam.t1 to fred;

Rows affected: 0

SQL_EXA> connect fred/FRED;

Wednesday, May 23, 2018 3:53:34 PM CEST
Connected to database EXAone as user fred.
EXASolution 6.0.8 (c) EXASOL AG

SQL_EXA> select * from adam.t1;
EXA: select * from adam.t1;

N
-----------------

0 rows in resultset.

SQL_EXA> select * from adam2.t2;
EXA: select * from adam2.t2;
Error: [42500] insufficient privileges: SELECT on table T2 (Session: 1601270776421928841)
SQL_EXA> connect adam/ADAM;

Wednesday, May 23, 2018 3:54:33 PM CEST
Connected to database EXAone as user adam.
EXASolution 6.0.8 (c) EXASOL AG

SQL_EXA> create role allonadam2;
EXA: create role allonadam2;

Rows affected: 0

SQL_EXA> grant all on adam2 to allonadam2;
EXA: grant all on adam2 to allonadam2;

Rows affected: 0

SQL_EXA> grant allonadam2 to fred;
EXA: grant allonadam2 to fred;

Rows affected: 0

SQL_EXA> connect fred/FRED;

Wednesday, May 23, 2018 3:55:54 PM CEST
Connected to database EXAone as user fred.
EXASolution 6.0.8 (c) EXASOL AG

SQL_EXA> select * from adam2.t2;
EXA: select * from adam2.t2;

N
-----------------

0 rows in resultset.

SQL_EXA> drop table adam2.t2;
EXA: drop table adam2.t2;
Error: [42500] insufficient privileges for dropping table (Session: 1601270923042332982)

That’s because ALL contains ALTER, DELETE, EXECUTE, INSERT, SELECT and UPDATE but not DROP which can be confirmed using EXA_DBA_OBJ_PRIVS.

Categories: DBA Blogs

Oracle Developer Cloud - New Continuous Integration Engine Deep Dive

OTN TechBlog - Wed, 2018-05-23 02:00

We introduced our new Build Engine in Oracle Developer Cloud in our April release. This new build engine now comes with the capability to define build pipelines visually. Read more about it in my previous blog.

In this blog we will delve deeper into some of the functionalities of Build Pipeline feature of the new CI Engine in Oracle Developer Cloud.

Auto Start

Auto Start is an option given to the user while creating a build pipeline on Oracle Developer Cloud Service. The below screenshot shows the dialog to create a new Pipeline, where you have a checkbox which needs to be checked to ensure the pipeline execution auto starts when one of the build job in the pipeline is executed externally, then that would trigger the execution of rest of the build jobs in the pipeline.

The below screen shot shows the pipeline for NodeJS application created on Oracle Developer Cloud Pipelines. The build jobs used in the pipeline are build-microservice, test-microservices and loadtest-microservice. And in parallel to the microservice build sequence we have, WiremockInstall and WiremockConfigure.

Scenarios When Auto Start is enabled for the Pipeline:

Scenario 1:

If we run build-microservice build job externally, then it will lead to the execution of the test-microservice and loadtest-microservice build jobs in that order subsequently. But note this does not trigger the execution of WiremockInstall or WiremockConfigure build jobs as they are part of a separate sequence. Please refer the screen shot below, which shows only the build jobs executed in green.

Scenario 2:

If we run test-microservice build job externally, then it will lead to the execution of the loadtest-microservice build job only. Please refer the screen shot below, which shows only the build jobs executed in green.

Scenario 3:

If we run loadtest-microservice build job externally, then it will lead to no other build job execution in the pipeline across both the build sequences.

Exclusive Build

This enables the users to disallow the pipeline jobs to be built externally in parallel to the execution of the build pipeline. It is an option given to the user while creating a build pipeline on Oracle Developer Cloud Service. The below screenshot shows the dialog to create a new Pipeline, where you have a checkbox which needs to be checked to ensure that the execution of build jobs in pipeline will not be allowed to be built in parallel to the pipeline execution.

When you run the pipeline you would see the build jobs queued for execution which you can see in the Build History. In this case you would see two build jobs queued, one would be build-micorservice and other would be WiremockInstall as they are parallel sequences part of the same pipeline.

Now if you try to run any of the build jobs in the pipeline, for example; like test-microservice, you will be given an error message, as shown in the screenshot below.

 

Pipeline Instances:

If you click the Build Pipeline name link in the Pipelines tab you will be able to see the pipeline instances. Pipeline instance is the instance at which it was executed. 

Below screen shot shows the pipeline instances with time stamp of when it was executed. It will show if the pipeline got Auto Started (hover on the status icon of the pipeline instance) due to an external execution of the build job or shows the success status if all the build jobs of the pipeline were build successfully. It also shows the build jobs that executed successfully in green for that particular pipeline instance. The build jobs that did not get executed have a white background.  You also get an option to cancel while the pipeline is getting executed and you may choose to delete the instance post execution of the pipeline.

 

Conditional Build:

The visual build pipeline editor in Oracle Developer Cloud has a feature to support conditional builds. You will have to double click the link connecting the two build jobs and select any one of the conditions as given below:

Successful: To proceed to the next build job in the sequence if the previous one was a success.

Failed: To proceed to the next build job in the sequence if the previous one failed.

Test Failed: To proceed to the next build job in the sequence if the test failed in the previous build job in the pipeline.

 

Fork and Join:

Scenario 1: Fork

In this scenario if you have a build job like build-microservice on which the other three build jobs, “DockerBuild” which builds a deployable Docker image for the code, “terraformBuild” which builds the instance on Oracle Cloud Infrastructure and deploy the code artifact and “ArtifactoryUpload” build job to upload the generated artifact to Artifactory are dependent on then you will be able to fork the build jobs as shown below.

 

Scenario 2: Join

If you have a build job test-microservice which is dependent on two other build jobs, build-microservice which build and deploys the application and another build job WiremockConfigure to configure the service stub, then in this case you need to create a join in the pipeline as shown in the screen shot below.

 

You can refer the Build Pipeline documentation here.

Happy Coding!

 **The views expressed in this post are my own and do not necessarily reflect the views of Oracle

Professional Tips For Building Mockups For Web And Mobile

Nilesh Jethwa - Tue, 2018-05-22 23:57

Given how incredibly easy it is to develop a web or mobile application, startups have become commonplace as a lot of players have already joined the bandwagon. You might be here because you want to learn how to compete against … Continue reading ?

Original: MockupTiger Wireframes

InfoCaptor Reviews – Customer Feedback and Testimonials

Nilesh Jethwa - Tue, 2018-05-22 23:52

My organization was looking for a way to chart MyQSL data on our website. One of the requirements was to use something that didn’t require extensive coding or multiple js files to run. InfoCaptor fit the bill. The programmer interface … Continue reading ?

Credit: InfoCaptor Dashboard

InfoCaptor Stack bar label fix

Nilesh Jethwa - Tue, 2018-05-22 23:47

A quick patch was released to fix the problem in display of data labels for stack bar chart. Please grab the new versions

By: InfoCaptor Dashboard

Wireframe Software – MockupTiger new version released

Nilesh Jethwa - Tue, 2018-05-22 23:42

A quick note that MockupTiger new version is now available. This release is for the cloud access. Desktop version of the wireframe tool is coming very soon. Link : Wireframe software online and desktop Key highlights of this mockup and … Continue reading ?

Via: InfoCaptor Dashboard

How to edit connection on existing dashboard or visualization

Nilesh Jethwa - Tue, 2018-05-22 23:37

Scenario: You have built a dashboard on a development database connection and you need to migrate to a production server using production database. How do you change the connection on the dashboard charts and visualization? There are two ways to … Continue reading ?

By: InfoCaptor Dashboard

How to delete or disable JDBC or database connection

Nilesh Jethwa - Tue, 2018-05-22 23:32

Here are the steps to disable or remove any connection handle From the launch pad, click on Manage project/Users Switch to the “Database” Tab Select the connection handle by clicking on it Next, click on the pencil icon to edit … Continue reading ?

Source: InfoCaptor Dashboard

Pages

Subscribe to Oracle FAQ aggregator