DBA Blogs

Oracle 12c: Indexing JSON in the Database Part III (Paperback Writer)

Richard Foote - Fri, 2016-09-02 00:13
In Part I and Part II, we looked at how to index specific attributes within a JSON document store within an Oracle 12c database. But what if we’re not sure which specific attributes might benefit from an index or indeed, as JSON is by it’s nature a schema-less way to store data, what if we’re not entirely sure […]
Categories: DBA Blogs

New graph: Average Active Sessions per minute

Bobby Durrett's DBA Blog - Thu, 2016-09-01 17:25

I am working on a production issue. I do not think that we have a database issue but I am graphing some performance metrics to make sure. I made a new graph in my PythonDBAGraphs program.

ash_active_session_count_today

It shows the average number of active sessions for a given minute. It prompts you for start and stop date and time. It works best with a relatively small interval or the graph gets too busy. Red is sessions active on CPU and blue is all active sessions. This graph is a production database today. Activity peaked around mid day.

It is kind of like the OEM performance screen but at least having it in Python lets me tinker with the graph to meet my needs. Check out the README on the GitHub link above if you want to run this in your environment.

Bobby

Categories: DBA Blogs

Send data to oracle procedure using ref cursor

Tom Kyte - Thu, 2016-09-01 01:26
Hi Tom, In our application (.Net & Oracle) we have an address table with 20+ fields, and I was wondering if it's a good idea to pass address to SP using REF CURSOR insted of multiple params (SP below will be called from other SPs as well as from C...
Categories: DBA Blogs

Java Codes for inserting list of directories in database

Tom Kyte - Thu, 2016-09-01 01:26
Hi Tom, This is a java programming language and i'm going to insert the directory path and filename in DB but my problem is the directory path without filename doesnt insert in DB it supposed to be the column FILE_NAMES is already null but it does...
Categories: DBA Blogs

Hierarchical query

Tom Kyte - Thu, 2016-09-01 01:26
Hi: I have hierarchical query where i would like to know all parents, grand parents, their parents etc. i.e. as connect by value is changing i would like to know. I know in 9i we have sys_connect_by_path but i need that functionality in 8.1.7. Is...
Categories: DBA Blogs

How to split the big file contains personal data

Tom Kyte - Thu, 2016-09-01 01:26
Hi Tom, Good evening. Can yo please guide me how we can do below requirement. Input will take huge data file it's having personal any data it's not like fixed sized or delimited. It's like any format. this data have to split 1. Based on t...
Categories: DBA Blogs

Analyzing 27 TB of database for upgrade from (10.2.0.5 to 11.2.0.4)

Tom Kyte - Thu, 2016-09-01 01:26
Hi, We are planning to upgrade 27 terabyte of database from 10.2.0.5 to 11.2.0.4. we are not sure things to look before upgrading as this is very huge database and it is running from many years live for users. Please suggest things and scripts t...
Categories: DBA Blogs

Oracle Open World 2016 – What GoldenGate sessions are there?

DBASolved - Wed, 2016-08-31 23:00

Well, it is that time of year again; the streets of San Francisco will be crowded with members of the Oracle community! As everyone in the Oracle community descends onto the bay area, there will be excitement about the things that will be announced this year. Sure a lot of it is going to be about “cloud” and what direction Oracle is taking with their “cloud” strategy. Besides, “cloud” there will be a lot of good things to take in as well. As I look through the online session catalog for 2016, I’m interested in the topics related to Oracle GoldenGate.

This year there appears to be a good number of Oracle GoldenGate sessions at Oracle Open World, to be specific there are 21 scheduled during the event. I have listed a few of the ones I think will be interesting and will make an attempt to attend; always check the session catalog because what I think is good you may not.

  • CON6632 – Oracle GoldenGate for Big Data
  • CON7318 – Getting Started with Oracle GoldenGate
  • CON6551 – New Oracle GoldenGate 12.3 Services Architecture (beta stuff)
  • CON6633 – Accelerate Cloud Onboarding with Oracle GoldenGate Cloud Service
  • CON6634 – Faster Design, Development and Deployment with Oracle GoldenGate Studio (should be updated from last year session)
  • CON6558 – Best Practice for High Availability and Performance Tuning for Oracle GoldenGate
  • UGF616 – Oracle GoldenGate and Apache Kafka: A Deep Dive into Real-Time Data Streaming
  • THT7817 – Real-Time and Batch Data Ingestion into Data Lake with Oracle GoldenGate Cloud Service
  • UGF5120 – Oracle GoldenGate and Baseball: Five Fundamentals Before Jumping to the Cloud

As we are within two weeks of Oracle Open World, I hope everyone is ready to go and looking forward to seeing others from the community.

Enjoy!

@dbasolved
http://about.me/dbasolved


Filed under: General
Categories: DBA Blogs

Year as input in a date column

Tom Kyte - Wed, 2016-08-31 07:26
I have a user who needs the possibility to enter just a year-number (ex. 2016) in a view containing a column that is defined as a date). The user see this value in the view as just a year (by using substr). I have been trying to make a trigger whi...
Categories: DBA Blogs

Procedures in one procedure

Tom Kyte - Wed, 2016-08-31 07:26
Hi, I've created a procedure containing 4 others procedures (INSERT INTO Table...) CREATE OR REPLACE PROCEDURE ALLPROC AS BEGIN PROC1; PROC2; PROC3; PROC4; END ALLPROC; Can you tell me if those 4 procedures are running in parallell or on...
Categories: DBA Blogs

When I trying to insert data to customer table it gives " inconsistent datatypes: expected UDT got CHAR" error,But i have given the datatype of " depNo" as char(9) already.. Can anyone explain me how to fix this error? Thanks.

Tom Kyte - Wed, 2016-08-31 07:26
--------------------creating types-------------- create type currency_vaty as varray(5) of char(3) / create type depcatogory_ty as object( depName char(5), intRate number(2,2), minDeposit number(8), currencies currency_vaty ) / ...
Categories: DBA Blogs

Datatype Number results in Numeric overflow although value is small enough

Tom Kyte - Wed, 2016-08-31 07:26
Try following Test Cases: DECLARE x NUMBER := 1; BEGIN x := 1024 * 1024 * 1024 * 5; END; / -> ORA-01426: numeric overflow DECLARE x NUMBER := 1; BEGIN x := x * 1024; x := x * 1024; x := x * 1024; x := x * 5; END; /...
Categories: DBA Blogs

Blocks allocation to tables and segments

Tom Kyte - Wed, 2016-08-31 07:26
1) select s.segment_name,sum(s.blocks),sum(s.BYTES),sum(s.extents) from user_segments s where s.segment_name='TBL_1' group by s.segment_name; SEGMENT_NAME SUM(S.BLOCKS) SUM(S.BYTES) SUM(S.EXTENTS) TBL_1 5504 45088768 8 2) sel...
Categories: DBA Blogs

How to display zero as count if there is no record in data base in combination with Date column?

Tom Kyte - Wed, 2016-08-31 07:26
Hello, After executing the Query Month Starts from APR to SEP only data is available in database and displaying properly. If there is no data i would like to display Month and Count as 0 with the same result. Ex: Here January(01) month has no re...
Categories: DBA Blogs

High number of buffers to get one block

Tom Kyte - Wed, 2016-08-31 07:26
I have a query who's DBMS_XPLAN output looks like this: <code>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | Id | O...
Categories: DBA Blogs

Cannot update simple Number(19,2) column

Tom Kyte - Wed, 2016-08-31 07:26
PS - I'm using Toad 4 to do this..... I have a database that has a table called parts_master with many columns, including.... pn varchar2(40) list_price Number(19,2) Mfg_auto_key Number list_price_date(date) I have a column: select pn, l...
Categories: DBA Blogs

dbms_xplan.display_cursor output

Tom Kyte - Wed, 2016-08-31 07:26
I am looking for a list of the output report columns provided by dbms_xplan.display_cursor. There are lots of possible columns but no place that I can find, including the documentation, that tells me very much about them. What I am looking to find is...
Categories: DBA Blogs

SYS_REFCURSOR Fetch with dynamically changing columns

Tom Kyte - Tue, 2016-08-30 13:06
I have a procedure that return sys_refcursor as its out parameter. Below is the code : <code> CREATE OR REPLACE PROCEDURE my_procedure ( o_result_set OUT SYS_REFCURSOR ) AS BEGIN ...
Categories: DBA Blogs

Rank/Sequence on Condition

Tom Kyte - Tue, 2016-08-30 13:06
Tool : SQL Developer Data CustId TransactionDate Transaction C001 01-JAN-2016 Inquiry C001 10-JAN-2016 Sales C001 21-JAN-2016 Repeat Inquiry C001 10-FEB-2016 Repeat Inquiry C001 01-MAY-2016 Sal...
Categories: DBA Blogs

Virtual Column Benefits

Tom Kyte - Tue, 2016-08-30 13:06
Hi team, I have a quick question for you today. I am creating a large (in terms of rows) table that will be queried by month, mainly for reporting purposes (each row represents a day and has a date column). Usually, when I have to design a ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs