Feed aggregator

Oracle 12c: Indexing JSON in the Database Part II (Find A Little Wood)

Richard Foote - Fri, 2016-08-05 02:00
In Part I, we looked at how you can now store JSON documents within the Oracle 12c Database. For efficient accesses to JSON documents stored in the Oracle database, we can either create a function-based index based on the JSON_VALUE function or on JSON .dot notation. These indexes are useful for indexing specific JSON attributes, […]
Categories: DBA Blogs

Links for 2016-08-04 [del.icio.us]

Categories: DBA Blogs

No Fun with EM 12c

Michael Dinh - Thu, 2016-08-04 17:21

Confession: I have not been using OEM for decades since there was never a real need for it and it’s starting to take its toll on me.

Throughout the day, I keep getting paged from OEM – Message=Number of failed login attempts exceeds threshold value.

The information provided is utterly useless, e.g. what is the threshold value and what’s the error code.

What would be useful is to provide the SQL used for the check for ease of troubleshooting.

Then I found Finding the source of failed login attempts. (Doc ID 352389.1)

SQL> @pr "select username,os_username,userhost,client_id,trunc(timestamp),count(*) failed_logins from dba_audit_trail where returncode=1017 and timestamp>trunc(sysdate) group by username,os_username,userhost, client_id,trunc(timestamp) order by 5";
USERNAME              : JANE
OS_USERNAME           : oracle
FAILED_LOGINS         : 1

That wasn’t it.

SQL> @pr "select username,os_username,RETURNCODE,userhost,trunc(timestamp),count(*) failed_logins from dba_audit_trail where returncode<>0 and timestamp>trunc(sysdate) group by username,os_username,RETURNCODE,userhost,trunc(timestamp) order by 5";
USERNAME              : 
OS_USERNAME           : tomcat
RETURNCODE            : 28000
FAILED_LOGINS         : 1065
-------------------------
USERNAME              : JANE
OS_USERNAME           : oracle
RETURNCODE            : 1017
FAILED_LOGINS         : 1

$ oerr ora 28000
28000, 00000, "the account is locked"
// *Cause:   The user has entered wrong password consequently for maximum
//           number of times specified by the user's profile parameter
//           FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
// *Action:  Wait for PASSWORD_LOCK_TIME or contact DBA

$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

1065 failed logins and no one even knows about this?

Lesson learned, there are many types of failed logins.

 


Installing SQLcl on OEL/RHEL

Dimitri Gielis - Thu, 2016-08-04 16:55
In my previous post I talked about how SQLcl came in handy to work with JavaScript against the database.

The installation of SQLcl is easy... you just download the zip, unpack and run the executable.

But to be fair, before I got SQLcl running (especially the script part) I encountered a number of issues, so hopefully this post helps you be able to run SQLcl with all features in minutes as it's meant to be :)


Those were the error messages I received when running sql (script):

javax.script.ScriptException: sun.org.mozilla.javascript.EvaluatorException: Java class "java.util.ArrayList" has no public instance field or method named "0".

javax.script.ScriptException: sun.org.mozilla.javascript.EcmaError: ReferenceError: "Java" is not defined. (#1) in at line number 1

The solution for me was to upgrade my Java version to Java 8.

Here're the steps on my OEL/RHEL system to upgrade Java:

$ cd /opt

$ wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/8u102-b14/jdk-8u102-linux-x64.tar.gz"

$ tar xzf jdk-8u102-linux-x64.tar.gz 

cd jdk1.8.0_102/

alternatives --install /usr/bin/java java /opt/jdk1.8.0_102/bin/java 2
$ alternatives --config java

There are 5 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
   1           /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java
   2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
   3           /usr/lib/jvm/jre-1.5.0-gcj/bin/java
*+ 4           /usr/java/jre1.8.0_101/bin/java
   5           /opt/jdk1.8.0_102/bin/java

Enter to keep the current selection[+], or type selection number: 5

$ alternatives --install /usr/bin/jar jar /opt/jdk1.8.0_102/bin/jar 2
$ alternatives --install /usr/bin/javac javac /opt/jdk1.8.0_102/bin/javac 2
$ alternatives --set jar /opt/jdk1.8.0_102/bin/jar
$ alternatives --set javac /opt/jdk1.8.0_102/bin/javac
$ java -version
java version "1.8.0_102"
Java(TM) SE Runtime Environment (build 1.8.0_102-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.102-b14, mixed mode)


$ export JAVA_HOME=/opt/jdk1.8.0_102
export JRE_HOME=/opt/jdk1.8.0_102/jre
$ export PATH=$PATH:/opt/jdk1.8.0_102/bin:/opt/jdk1.8.0_102/jre/bin

Now when running SQLcl everything worked like a charm. Hurray :)

Categories: Development

SELECT Query

Tom Kyte - Thu, 2016-08-04 14:06
How to select a last value of a column which is not in group by For eg Emp id salary j_dt 1. 100. 1-Jan 1. 200. 1-Feb 1. 130. 1-Mar select last value of amount, sum of amount, avg of amount ...
Categories: DBA Blogs

Identify overlapped intervals

Tom Kyte - Thu, 2016-08-04 14:06
Hi team, I have a table with intervals of numbers. However, my table have intervals that overlap and a number can be in more than one interval. For example, start_interval | end_interval 1 | 2 2 | 4 3 ...
Categories: DBA Blogs

Nullable Property When Copying a Table Using CTAS

Tom Kyte - Thu, 2016-08-04 14:06
Hello, In the example below, I'm using a CTAS statement with where 1=2 to copy the structure of a table. Four of the columns that are defined as NOT NULL on the source table retain that property in the new table. However, one column (patient_id) b...
Categories: DBA Blogs

Change the creator of a dbms_scheduler job

Tom Kyte - Thu, 2016-08-04 14:06
Hello, is it possible to change the creator of a dbms_scheduler job, so it is executed with the rights of another user? Regards Wolfgang
Categories: DBA Blogs

Find rows inserted yesterday

Tom Kyte - Thu, 2016-08-04 14:06
Hi, I have a table with 3 columns emp_id,last_name and date_of_birth. And each day data loading starts after 12 am . I have to generate the report on data loaded before today's load (exclude loaded today after 12 am). I was asked this questio...
Categories: DBA Blogs

PLSQL INTERVIEW QUESTIONS

Tom Kyte - Thu, 2016-08-04 14:06
HI TOM, PLEASE EXPLAIN WITH AN EXAMPLE ...BREIFLY I KNOW ONLY LITTLE BIT 1)How to debugg your code? 2)How to trace error handling? 3)Can you alter procedure with in package? 4)Is it possible to open cursor which is in package in another procr...
Categories: DBA Blogs

ORA-01000 - How to close open CURSORs?

Tom Kyte - Thu, 2016-08-04 14:06
Hi, I have a cursor leak at the application level (Java), how can I close open cursors? If I Kill the session, does this close the related cursors? Also, if I use DBMS_SHARED_POOL.PURGE to flush the query behind the issue, does this close the ...
Categories: DBA Blogs

Sessions disconnected automatically.

Tom Kyte - Thu, 2016-08-04 14:06
Hi Tom. I can't find how my database is disconnecting the inactive sessions because when I ran the following statements: select * from user_resource_limits a where a.resource_name in ('IDLE_TIME','CONNECT_TIME'); IDLE_TIME UNLIMITED CONNE...
Categories: DBA Blogs

EBS 12.2 DB Migration Using 12cR1 Transportable Tablespaces Now Certified

Steven Chan - Thu, 2016-08-04 11:49
Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release 12.2 (12.2.3 or higher) with Oracle Database 12c Release 1 (12.1.0).

This certification requires that the source database be 11gR2 (11.2.0.4) or 12cR1 (12.1.0.2) and the target database be 12cR1 (12.1.0.2). This 12.2/12cR1 database migration process utilizes the 'full transportable export/import' feature of 12c to greatly speed up the migration while also offering the optional use of incremental backup.

This migration process requires a patch delivered by the EBS Platform Engineering team which is now generally available on MOS for use by EBS customers.

The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba):
SQL> select platform_name, endian_format from v$transportable_platform;

Here's a list of relevant platforms certified for the EBS R12 with 12cR1 on the database tier:

 Big Endian
 Little Endian
 Oracle Solaris on SPARC
 Linux x86-64
 HP-UX Itanium
 Windows x64
 IBM AIX on Power Systems
 Oracle Solaris on x86-64
 IBM: Linux on System z

The use of Transportable Tablespaces may greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. Smaller databases (less than 1TB) may see little gain from the use of Transportable Tablespaces, and other techniques like export/import will be simpler and likely faster.

For smaller databases, we highly recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that TTS is suitable as a migration process to reduce downtime.

Database migration between platforms of the same endian format should use the 'Transportable Database' process or Rapid Clone if migrating between the same platform.

References

Related Articles

Categories: APPS Blogs

Forbes Media Selects Oracle Marketing Cloud to Increase Advertising Revenue

Oracle Press Releases - Thu, 2016-08-04 07:00
Press Release
Forbes Media Selects Oracle Marketing Cloud to Increase Advertising Revenue Global publisher to leverage high-quality data and superior analytics capabilities to help advertisers reach and engage new audiences

Redwood Shores Calif—Aug 4, 2016

Forbes Media has selected the Oracle Marketing Cloud to take advantage of new digital channels to increase advertising revenue. The deep insights delivered by the Oracle Marketing Cloud’s data analytics and management platform will enable Forbes Media to help advertisers increase audience reach and engagement.
 
Digital technologies have transformed the competitive landscape in the publishing industry. Free, easily accessible content makes it more difficult for publishers to grow paid subscriptions; new digital publishing platforms have increased the number of publishers by eliminating many of the traditional barriers to market entry; and an explosion of digital channels such as search, social and video have created new competition for ad buys. These changes have forced publishers to rethink how they work with advertisers to reach and engage audiences.
 
"We knew we needed a new platform that could help our advertisers increase audience reach and engagement,” said Mark Howard, chief revenue officer, Forbes Media. “The Oracle Marketing Cloud provides us with the tools we need to expand and customize our advertisers’ experience on our site and to offer marketers deeper insight into the performance of their digital campaigns. The breadth and scale of Oracle’s third-party data and the seamless integration it has with our systems has created a product that will allow us to provide advertisers with a level of analytics that was previously unachievable.”
 
Forbes will use the Oracle Data Management Platform (DMP), part of Oracle Marketing Cloud, to analyze its core user base and to provide advertisers, including those running a native BrandVoice program, with enriched detail about the audience that their campaign has reached. The Oracle DMP’s advanced analytics will allow Forbes to work with its advertising partners to develop custom, niche segments tailored to the marketers’ ideal audience. Finally, the Oracle ID Graph, a technology that helps marketers connect identities across disparate marketing channels and devices to one customer, will help Forbes target customers and prospects across all channels and devices, ensuring a relevant, personalized customer experience for each individual.
 
“Savvy publishers like Forbes are becoming more sophisticated in how they tap their first-party data to make its sites’ audiences more valuable to advertisers,” said Andrea Ward, Vice President of Marketing, Oracle Marketing Cloud. “Leveraging the power of the Oracle data management platform to scale their first-party audience data, Forbes will be better able to package audience inventory to align with advertisers’ needs. This will enhance both the advertisers’ and Forbes revenue streams.”
 
For more information on the Oracle Marketing Cloud’s data management platform, please see the Oracle Marketing Cloud website.
 
About Forbes Media
Forbes Media is a global media, branding and technology company, with a focus on news and information about business, investing, technology, entrepreneurship, leadership and affluent lifestyles. The company publishes Forbes, Forbes Asia, and Forbes Europe magazines as well as Forbes.com. The Forbes brand today reaches more than 94 million people worldwide with its business message each month through its magazines and 36 licensed local editions around the globe, Forbes.com, TV, conferences, research, social and mobile platforms. Forbes Media’s brand extensions include conferences, real estate, education, financial services, and technology license agreements.
 
Contact Info
Erik Kingham
Oracle
1.650.506.8298
erik.kingham@oracle.com
Mia Carbonell
Forbes Media
1.212.620.2288
mia.carbonell@forbes.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. 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.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Erik Kingham

  • 1.650.506.8298

Mia Carbonell

  • 1.212.620.2288

Oracle SESSIONTIMEZONE Function with Examples

Complete IT Professional - Thu, 2016-08-04 06:00
In this article, I’ll explain what the Oracle SESSIONTIMEZONE function is, and show you some examples. Purpose of the Oracle SESSIONTIMEZONE Function The SESSIONTIMEZONE function returns the timezone offset of your session, in the format of [+|-]TZH:TZM, or a time zone region name. This can be helpful to know, especially if you’re doing a lot of […]
Categories: Development

Orchestration 2.0 - creating an instance

Pat Shuff - Thu, 2016-08-04 02:07
Today we will continue our evaluation of Oracle Orchestration by looking at how to define an instance. Yesterday we looked at creating a WordPress instance from an Oracle Marketplace image. We started by going down the structure of a storage element. Today we are going to continue with our Bitnami WordPress instance provisioning by looking at the bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance.json file which describes the compute instance. The default install from Bitnami creates this file. In our example we are going to create an instance called WordPress_4_5_3 rather than the default and change the default storage from 10 GB to 60 GB as the Marketplace suggests is the minimum.

bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance.json

If we look at the orchestration file we see the definition

{
  "relationships" : [ ],
  "account" : "/Compute-metcsgse00028/default",
  "description" : "",
  "schedule" : {
    "start_time" : "2016-07-21T19:46:32Z",
    "stop_time" : null
  },
  "oplans" : [ {
    "obj_type" : "launchplan",
    "ha_policy" : "active",
    "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance",
    "objects" : [ {
      "instances" : [ {
        "networking" : {
          "eth0" : {
            "seclists" : [ "/Compute-metcsgse00028/default/default" ],
            "nat" : "ippool:/oracle/public/ippool"
          }
        },
        "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012/b531af9b-e075-4a51-a867-449fd948d374",
        "storage_attachments" : [ {
          "volume" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage",
          "index" : 1
        } ],
        "boot_order" : [ 1 ],
        "hostname" : "a2d1e4.compute-metcsgse00028.oraclecloud.internal.",
        "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012",
        "shape" : "oc3",
        "attributes" : {
          "userdata" : {
          },
          "nimbula_orchestration" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance"
        },
        "imagelist" : "/Compute-metcsgse00028/marketplace01-user@oracleads.com/bitnami-wordpress-4.5.3-0-linux-oel-6.7-x86_64",
        "sshkeys" : [ "/Compute-metcsgse00028/cloud.admin/2016" ],
        "tags" : [ ]
      } ]
    } ]
  } ],
  "user" : "/Compute-metcsgse00028/cloud.admin",
  "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance"
}

If we break down this file it can be abbreviated as

{
  "relationships" : [ ],
  "account" : "/Compute-metcsgse00028/default",
  "description" : "",
  "schedule" : { …  },
  "oplans" : [ … ],
  "user" : "/Compute-metcsgse00028/cloud.admin",
  "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage"
}

Note that this is exactly what it looked like for the storage definition. The differences happen in the oplans parameter field. For the instance definition we define the obj_type as launchplan. The launchplan parameters are detailed in the documentation. The required field for the launchplan object type is the instances parameter. All of the other fields are optional. The instances fields are defined in the documentation on instances. The shape parameter is the only required parameter with all other parameters being optional. The oplans field for our instance looks like

    "obj_type" : "launchplan",
    "ha_policy" : "active",
    "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance",
    "objects" : [ {
      "instances" : [ {
        "networking" : {
          "eth0" : {
            "seclists" : [ "/Compute-metcsgse00028/default/default" ],
            "nat" : "ippool:/oracle/public/ippool"
          }
        },
        "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012/b531af9b-e075-4a51-a867-449fd948d374",
        "storage_attachments" : [ {
          "volume" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage",
          "index" : 1
        } ],
        "boot_order" : [ 1 ],
        "hostname" : "a2d1e4.compute-metcsgse00028.oraclecloud.internal.",
        "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012",
        "shape" : "oc3",
        "attributes" : {
          "userdata" : {
          },
          "nimbula_orchestration" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance"
        },
        "imagelist" : "/Compute-metcsgse00028/marketplace01-user@oracleads.com/bitnami-wordpress-4.5.3-0-linux-oel-6.7-x86_64",
        "sshkeys" : [ "/Compute-metcsgse00028/cloud.admin/2016" ],
        "tags" : [ ]
      } ]
    } ]

In this definition the object type is launchplan. The ha_policy is active which means that the instance will be rebooted if it fails. The label is the name of the compute instance. The default installed by Bitnami is "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance" but our example would be WordPress_4_5_3_instance. The objects parameter holds the meat of the definition. We have the required field shape that defines our instance as an oc3 size instance. We give it a name as well as network connection using the default security list association. The default security list opens up port 22 that allows us to ssh into the Linux instance to configure the application. We have one storage volume attached that we looked at in the previous blog post. Note that we attach the volume by name and associate it with logical unit 1. We also define some optional attributes that give the boot loader a hint so that we can not only boot this image from a boot file but associate ssh keys to the instance so that we can log in once the system is up and running. The only additional information that we see in this file is the hostname used to address this system. In this example we use the hostname of a2d1e4.compute-metcsgse00028.oraclecloud.internal. This is the internal name that can be used through the DNS service provided by the Oracle Cloud services.

bitnami-wordpress-4.5.3-0-linux-20160721144012_master.json

The third file that is defined for our instance is the master json file. The default file name created by Bitnami is bitnami-wordpress-4.5.3-0-linux-20160721144012_master.json for our instance. The key differences in this file is the oplan obj_type being orchestration and the relationships entry being non null. The obj_type of orchestration tells the Oracle Cloud service that this is the file that is used to describe the instance and how to load and boot it. The relationships parameter shows that there are two plans that we need to reference for booting. We require the "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance" file to describe the instance and this file depends upon the file "bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage". The storage file defines the disk that we will boot from and use to run our instance. If there were multiple disks we would have multiple dependencies listed. The full contents of this file look like

{
  "relationships" : [ {
    "to_oplan" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage",
    "oplan" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance",
    "type" : "depends"
  } ],
  "account" : "/Compute-metcsgse00028/default",
  "description" : "",
  "schedule" : {
    "start_time" : "2016-07-21T19:40:33Z",
    "stop_time" : null
  },
  "oplans" : [ {
    "obj_type" : "orchestration",
    "ha_policy" : "",
    "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage",
    "objects" : [ {
      "info" : {
        "errors" : {
        }
      },
      "status" : "ready",
      "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_storage",
      "status_timestamp" : "2016-07-21T19:45:16Z",
      "uri" : null
    } ]
  }, {
    "obj_type" : "orchestration",
    "ha_policy" : "",
    "label" : "bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance",
    "objects" : [ {
      "info" : {
        "errors" : {
        }
      },
      "status" : "ready",
      "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_instance",
      "status_timestamp" : "2016-07-21T19:47:16Z",
      "uri" : null
    } ]
  } ],
  "user" : "/Compute-metcsgse00028/cloud.admin",
  "name" : "/Compute-metcsgse00028/cloud.admin/bitnami-wordpress-4.5.3-0-linux-_20160721144012_master"
}

These two files define the instance and the instance relationship with storage. When we look at the Orchestration part of the Compute Console we note that we can view, start, delete, resize, and download the orchestration. If the instance is running we can stop the instance.

If we view the orchestration it allows us to look at the download the json code. The download allows us to download the json code to our desktop. The delete function for an instance has moved from the Instances tab to this tab. To delete an instance you need to stop the instance through the Orchestations tab then delete the components that make up the instance. Note that the Resize Instance only appears for a compute instance. This allows us to size up or size down an instance to a different shape. We can’t size up and down storage but need to edit the orchestration to make it bigger. Making it smaller is currently not supported. It is important to note that editing of the json files is currently not supported from this interface. If you want to edit a json file you need to download it, edit it on your desktop, then upload it with a different name. The upload is done using the Upload Orchestration button on the Orchestrations tab.

Yesterday we looked at the storage json file that makes up a storage orchestration. Today we looked at the instance and master orchestration files that define an instance. All three of these files help us define an instance and how to start it. The example that we started with is a simple example that creates an Apache web server with PHP and MySQL on a Linux instance. We then layer WordPress on this configuration and define security ports to allow us to log in and manage the instance as well as see the http and https ports. Automation of instances can be done through REST apis once we have the orchestrations defined. We can use tools like Enterprise Manager to catch errors and exceptions thrown if an instance fails and initiate a restart function. We can also use Enterprise Manager to reconfigure or rescale services if utilization goes above a threshold over a period of time. Amazon uses CloudFormation to make this happen but it is specific for Amazon AWS services only. Oracle uses Enterprise Manager because these scripts and monitoring utilities can be used for on premise servers, virtual instances running in your data center, or compute instances running in the Oracle or other cloud service.

related to stored procedure

Tom Kyte - Wed, 2016-08-03 19:46
why we can't call stored procedure from sql select? and why stored function called from sql select statement has only in variables? and can sys_refcursor exhibits dynamic sql?
Categories: DBA Blogs

ORA-06548: no more rows needed

Tom Kyte - Wed, 2016-08-03 19:46
Hi Team, Below is the sql used SELECT * FROM TABLE(pkg.fn_api('PR_LOAD_PL_PROT_TO_SITE','ROLE_ABBR') Below is the code snippet of pkg TYPE t_parm_val_txt_rec IS RECORD ( o_parm_value_txt VARCHAR2 (4000 BYTE) ); TYPE t_...
Categories: DBA Blogs

how to find bottleneck sql's in a package in oracle without using dbms_profiler or dbms_hprofiler? is there any alternatives?

Tom Kyte - Wed, 2016-08-03 19:46
how to find bottleneck sql's in a package in oracle without using dbms_profiler or dbms_hprofiler? is there any alternatives?
Categories: DBA Blogs

Waiting for parallel query to finish

Tom Kyte - Wed, 2016-08-03 19:46
Is there any way I could know the status of a parallel query i.e. the query has finished the job. I am trying to use few parallel updates and inserts in a VB6 application and finally a truncate. The truncate query causes "ORA-00054: resource busy a...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator