Просторы интернета
This document is my attempt to bring together the available options that can be used to determine the root cause of an issue in order to create a roadmap to help support engineers narrow down the cause of concern.
It is a living document and will be edited and amended as [...]
This document is my attempt to bring together the available options that can be used to determine the root cause of an issue in order to create a roadmap to help support engineers narrow down the cause of concern.
It is a living document and will be edited and amended as [...]
I created this simple service a couple of years ago. It's pretty simple, small and intuitive Python app, so you can easily modify it to suit your own needs and run on any platform: https://github.com/xtender/pySync
[...]Obviously we can format/beautify SQL or PL/SQL code using external tools, but sometimes it would be more convenient to format it directly in database, for example if we want to see few different sql_text's from v$sqlarea. And thanks to Oracle SqlCL and [...]
Write a pure SQL query with PL/SQL that stop after :N seconds, where :N is a bind variable.
My solution with v(start_hsecs, delta, flag) as ( select hsecs as start_hsecs, 0 as delta, 1 as flag from v$timer union [...]You can add also any information from v$rtsm_sql_plan_monitor if needed
create or replace function px_session_info return varchar2 parallel_enable as vSID int; res varchar2(30); begin vSID:=userenv('sid'); select to_char(s.server_group,'fm000') ||'-'||to_char(s.server_set,'fm0000') [...]I've just released new version of my Simple Android Oracle Client.
New features:
Supported Oracle versions: 11.2, 12.1, 12.2, 18, 19, 20. SQL Templates: now you can save and load own script templates Server output (dbms_output) Export results as JSON, CSV and HTML files (long tap on results) Copy results to the Clipboard as JSON [...]These screenshot are from JDevelopers - 12c
1. Click on Window - Resources
2. In the Resources pallet - Click on Import to open the 'Import Catalogs and Connections' window.
3. Now browse to locate the *.rcx file containing connection details.
4. Then click on Import to import [...]
You may know that whenever you call PL/SQL functions from within SQL query, each query in the function is consistent to the SCN of its start and not to the SCN of parent query.
Simple example:
create table test as select level a, level b from dual connect by [...]Instance Auto recovery is the functionality to recover the failed instances with in a stipulated time period. The Instances which are faulted and marked to be recovered can be recovered in a particular time.
At sometime it's a disadvantage if your instances are falling which might lead increase table spaces issue [...]
As of Oracle 19c OJPPD doesn't support connect-by and TABLE():
OJPPD: OJPPD bypassed: query block contains START WITH/CONNECT BY. OJPPD: OJPPD bypassed: View contains TABLE expression. [...]I forgot to share my files from presentations, so I'm going to keep them here:
8-sql-2596013-Использование-некоторых-новых-возможностей-SQLCBO-в-12сDownload Intra-block-row-chaining(RuOUG)Download Intra-block-row-chaining(RuOUG).pptxDownload Когда-выбирается-план-с-большим-COSTDownload Sayan Malakshinov. CBO – Query Transformations(RuOUG)Download [...]Use ORAMDS for all XSD / WSDL files on the project (oramds:...) in all composite.xml and wrappers in location tag. Doing that you will guarantee that you can deploy anywhere even when you don't have remote access to a environment.
Also, in this way it is not necessary to change [...]
Details Case 1 : If BPEL Process is Async or one-way process then, Delivery policy attribute can have three values. Those are 1)- async.persit 2)- async.cache 3)- sync
meaning: - async.persit: Delivery [...]
How can I use the API to identify the SOA composite instance ID? [...]
Log in to Enterprise Manager Fusion Middleware Control.
http: // {host name or IP}: {port number} / em Open the SOA folder, right click on the soa_infra (soa_server1) folder and [...]