DBA Blogs

Why does the year to month interval return an erroneous value compared to the day to second interval?

Tom Kyte - Mon, 2018-04-09 06:26
Hi Tom, While I was working through an example in a book, I ran into a problem I couldn't figure out. It involves two scripts and its results which are provided below: Script 1: <code> SELECT loan_id,due_date, tool_out_date, NUMTOYMINTERVAL...
Categories: DBA Blogs

Error: ORA-06533: Subscript beyond count

Tom Kyte - Mon, 2018-04-09 06:26
Please help me in editing the below Pl/SQL code: <code>create or replace Function user_score_scurve (scurve_in varchar2, inpt IN number) RETURN number IS params_number number; TYPE type_params IS table OF number; Params ...
Categories: DBA Blogs

Split 1 row into 2 rows based on column values without UNION

Tom Kyte - Sun, 2018-04-08 12:06
Hi, I will be glad if you could help me to know if the below can be achieved without using UNION I want to split a row into 2 based on a column value create table xx_test_split ( id number, amount number, discount_amount number, currency ...
Categories: DBA Blogs

Oracle Query CPU Utilization

Tom Kyte - Sun, 2018-04-08 12:06
I am looking at instance sizing and have some questions on how Oracle uses CPU cores. Assume this is a Standard Edition database so no queries will be running in parallel mode. Assuming system background processes are negligible: *) When a single ...
Categories: DBA Blogs

DBA career advice

Tom Kyte - Sun, 2018-04-08 12:06
I work in mid-size company in India. I'm Oracle Developer last 1 year. I want to become DBA. How to become professional Oracle DBA like Core DBA or Oracle Application DBA in INDIA? Which book should be read for me? What should be work do by me ...
Categories: DBA Blogs

How can i change my sys password

Tom Kyte - Sun, 2018-04-08 12:06
How can i change my sys password
Categories: DBA Blogs

How to pass a bind variable inside string inside exexute immediate string?

Tom Kyte - Fri, 2018-04-06 23:26
The benefits of using bind variables inside dynamic SQL statements have been discussed many times here. I have dynamic SQl statement like this where "id" is a pls_integer: <code>---- ENSURE THAT BULK PROCESSING IS DISABLED ---- b...
Categories: DBA Blogs

Custom pivot with count and sum summaries and horizontal sorting

Tom Kyte - Fri, 2018-04-06 23:26
Hello Team, Good Day! I have linked livesql script for data creation. Data basically looks like this. <code> 1 symnum NUMBER 22 2 symname VARCHAR2 100 3 remnum NUMBER 22 4 remname VARCHAR2 32 5 grade NUMBER 22 </code> ...
Categories: DBA Blogs

Move data within partitions

Tom Kyte - Fri, 2018-04-06 23:26
Hi Tom. I'm working on a database with a partitioned table (by date). There are weekly partitions plus a edge partition where values higher than a certain value are stored. The last partition has never been used and is empty. Counting recor...
Categories: DBA Blogs

Soundex

Tom Kyte - Fri, 2018-04-06 05:06
Buen dia Connor, espero estes bien. Estoy realizando una practica e investigacion sobre chatbots, en mi algoritmo estoy buscando por dos metodos el parseo o proceso de las palabras para hacer el NLP y darles sentido, se que existe la funcion soun...
Categories: DBA Blogs

How to start a job on two conditions with DBMS_SCHEDULER : another job has finished and we are on monday ?

Tom Kyte - Fri, 2018-04-06 05:06
Hi, I have a job (JOB1) which runs every night at 0:30. I have another job (JOB2) which must be run after JOB1 completes but only once a week, on monday. For the moment, I manage this by starting JOB2 on monday at 4:00 because most of the time J...
Categories: DBA Blogs

Oracle EMEA Identity & Security Partner Forum 2018 #OPNCloudSecurity

          ...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Question: Anything Wrong With Query Performance? (Straight To You)

Richard Foote - Thu, 2018-04-05 00:21
I have a query that runs pretty darn efficiently, here’s the setup: So the query basically returns 1000 rows based on the CODE column and it does so using an index on CODE. The CBO has got the costings for this just about spot on. For 1000 rows returned, it does so with just 1006 […]
Categories: DBA Blogs

Virtual Workshop: Developing Microservices Using DevOps

Get Hands On with your Oracle Cloud Trial The Oracle Cloud Developing Microservices using DevOps workshop will walk you through the Software Development Lifecycle (SDLC) for a Cloud Native...

We share our skills to maximize your revenue!
Categories: DBA Blogs

To generate list of unique Random Numbers based on the number count required

Tom Kyte - Mon, 2018-04-02 09:46
Hi, My requirement is to generate the list of random numbers based on the total count provided. for instance, if total count is 100, i have to generate 100 unique random numbers. Below is the sample code i used. Could you please check and let me ...
Categories: DBA Blogs

Group by is failing on remote database query

Tom Kyte - Mon, 2018-04-02 09:46
Hello, My issue is the good old ORA02070 and I've found different workarounds but none of them fits my particular problem. It happens when I try to do a group by on remote database query. I need to compare data between the local and remote dat...
Categories: DBA Blogs

DB stuck at check point not complete.

Tom Kyte - Mon, 2018-04-02 09:46
Our DB stuck and check poin not complete. As per the logs DBA says.. ELECT for update running on the db causing the high number of block changes and caused the issue After this issue we are unable to generate ASH or AWR for that time. How to iden...
Categories: DBA Blogs

Not all standby Redo logs are being used in Physical standby database

Tom Kyte - Mon, 2018-04-02 09:46
Hi I wanted to know how does Oracle physical standby database decides how many standby Redo to be used. As We have a Standby which have multiple Standby Logs but its is only using 2 of them for each thread. We tried to switch the logs on both...
Categories: DBA Blogs

character set us7ascii missing from dbca

Tom Kyte - Mon, 2018-04-02 09:46
I am trying to create a database in oracle 12.1.0.2 using dbca. THe character set us7ascii is not in the list of character sets.
Categories: DBA Blogs

New functions not yet documented - TO_DOG_YEAR

Tom Kyte - Sun, 2018-04-01 15:26
Over the past few months I've been working on a project using oracle advanced analytics to detect IBS in Dogs. I've written a short blog post about this here (http://www.oralytics.com/2018/04/predicting-ibs-in-dogs-using-oracle-18c.html) I've noti...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs