DBA Blogs

Export all table in a schema into csv files

Tom Kyte - Tue, 2018-04-10 00:46
Hello, I want to export all table in a schema into csv files. I want that the csv files having the same name as the tables. I have following SQLPlus Code: <code>connect username/password set serveroutput on; set lines 80 set head off...
Categories: DBA Blogs

Problem with large tables and LIKE query

Tom Kyte - Tue, 2018-04-10 00:46
Hi, we have an application that uses Oracle database to hold company data. One of it's table, called PWORKSPACEOBJECT holds all 'displayable' objects in GUI client. Most of the time users are searching for some data only by typing *some text* ...
Categories: DBA Blogs

Had to set parallel_max_servers to 2 for Delphix clone

Bobby Durrett's DBA Blog - Mon, 2018-04-09 17:50

This is a quick note about a problem I had creating a Delphix virtual database clone of a production database.

This is an older 11.1.0.7 HP-UX Itanium database. I tried to make a new virtual database copy of the production database and it failed due to the following error:

ORA-07445: exception encountered: core dump [krd_flush_influx_buffers()+96] [SIGSEGV] [ADDR:0x10000000005D8] [PC
:0x400000000B415880] [Address not mapped to object] []

I only found one thing on Oracle’s support site about krd_flush_influx_buffers but it was not an exact match because it had to do with Data Guard.

So I tried various parameters and none worked. I tried setting parallel_max_servers to 0  down from 100 in production but that caused other issues. Then I remembered something about setting it to 2 so I tried that and it worked.

The strange things is that I still see a ORA-07445 krd_flush_influx_buffers error in the alert log for the successful clone. But, somehow changing the parallel_max_servers parameter to 2 allowed the various Delphix and Oracle processes to complete.

Bobby

Categories: DBA Blogs

ORACLE SQL Question sum credits and debits

Tom Kyte - Mon, 2018-04-09 06:26
I have a transaction table called TRANSACTION DETAIL.... TRANSACTION DETAIL CNN TYPE AMT DATE C1 C 1000 10-Jan-16 C2 C 1200 10-Jan-16 C3 C 2000 11-Jan-16 C4 D 1000 12-Jan-16 C3 D...
Categories: DBA Blogs

Unable to get expdp/impdp utility run successfully, getting ORA-39002: invalid operation ORA-39070: Unable to open the log file.

Tom Kyte - Mon, 2018-04-09 06:26
Dear Tom, very Good day to you. I am trying to use expdp/impdp utility to backup tables,schema etc and it is not executing successfully. The followings are what I am getting in regard to errors <code>ORA-39002: invalid operation ORA-39070: Un...
Categories: DBA Blogs

Where is the web address of the "Partition" introduction details on AskTom ?

Tom Kyte - Mon, 2018-04-09 06:26
Hello, AskTom Team. A few months ago, I have glanced a link about "<b><i>Partition</i></b>" introduction details. But now I haven't seen it. Please tell me what web address is. Best Regards Quanwen Zhao
Categories: 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

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs