DBA Blogs

DDL related parse, execute, fetch

Tom Kyte - Mon, 2019-12-02 17:52
Dear Mr. Tom, When we issue a DML it undergoes PARSE EXECUTE FETCH process and the things happen in Database Buffer Cache. Kindly tell me when we issue a DDL then PARSE EXECUTE is understandable but what about FETCH? What it will...
Categories: DBA Blogs

Plan changes when json_arrayagg function got added

Tom Kyte - Mon, 2019-12-02 17:52
Team, could you please help us to understand why the plan changes when json_arrayagg function got added? <code> demo@PDB1> create table t as select * from all_objects; Table created. demo@PDB1> alter table t add constraint t_pk primary ...
Categories: DBA Blogs

transportable DBF Import in 12c

Tom Kyte - Mon, 2019-12-02 17:52
i'm trying to import transportable data files to Oracle DB 12.2 . These files are exported from as transportable from Oracle DB 11.1.i recieve the following error. ORA-39123: Data Pump transportable tablespace job aborted ORA-19721: Cannot find dat...
Categories: DBA Blogs

How to extract table data into CSV file dynamically using generic procedure

Tom Kyte - Mon, 2019-12-02 17:52
Hi, Need help on how to generate the CSV file for the given tablename dynamically using PLSQL procedure. I understand we can use UTL_FILE oracle package to generate the CSV file however I would like to know how we can create generic script which ...
Categories: DBA Blogs

Multiple Schema Oracle Wallet

Tom Kyte - Mon, 2019-12-02 17:52
Dear AskTom, I have a shell script that connects as several different users to the same database. From Oracle: You can store multiple credentials for multiple databases in one client wallet. You cannot store multiple credentials (for logging i...
Categories: DBA Blogs

Good Minecraft Usernames

VitalSoftTech - Thu, 2019-11-28 08:53

You are all set to play Minecraft, things get whacky when you cannot think of a good Minecraft username. We are here to help! Minecraft is an award-winning videogame developed by Markus Presson, a Swedish game developer. It is much like a videogame in a sandbox because the player can create, modify, and destroy his […]

The post Good Minecraft Usernames appeared first on VitalSoftTech.

Categories: DBA Blogs

Goal seek excel Function – A Step By Step Tutorial

VitalSoftTech - Wed, 2019-11-27 10:33

Microsoft Excel is one of the most widely used applications for data analysis. Professionals from financial industry to information technology and researchers to academics make extensive use of Excel on a day to day basis. There is no denying the fact that the range of features that Microsoft Excel offers is truly amazing. This is […]

The post Goal seek excel Function – A Step By Step Tutorial appeared first on VitalSoftTech.

Categories: DBA Blogs

What Does PDF Stand For?

VitalSoftTech - Tue, 2019-11-26 09:52

The acronym PDF is widely used while converting, downloading documents, and browsing on the internet. You might have wondered what does PDF stand for. In today’s day and age, jargonization has enveloped every part of our life, including writing and browsing. It is, however, very convenient to use these acronyms instead of pronouncing the entire […]

The post What Does PDF Stand For? appeared first on VitalSoftTech.

Categories: DBA Blogs

Nightly process slowing down.

Tom Kyte - Thu, 2019-11-21 11:50
Hi. We have a process that runs every night that is beginning to slow down and we need some help to find the resources to analyse the problem. In our setup, unfortunately both transaction schemas and warehousing (statistics) schemas are kept on...
Categories: DBA Blogs

Golden Signals for performance

Tom Kyte - Thu, 2019-11-21 11:50
Hello Tom I am a member of an site reliability team (SRE) and we are trying to develop SRE "golden signals" for an Oracle 11g/12c database. These signal are: 1) Throughput 2) Latency 3) Response Time 4) Error rate (not sure about this one...
Categories: DBA Blogs

Difference between DBRM and IORM

Tom Kyte - Thu, 2019-11-21 11:50
Dear Sir, Please help me to know below points. 1)difference between DBRM and IORM? 2)difference between ACFS,ADVM and DBFS? Thanks Pradeep
Categories: DBA Blogs

SQL*Loader-503 in 19c for UNC names

Tom Kyte - Thu, 2019-11-21 11:50
Hi TOM, next Month we are migrating from Oracle 12.1.0.2 to Oracle 19, so I installed the new Oracle Client 19c on my PC. Using SQLLDR with (all in one line) sqlldr userid=user/passwd@server control=\\server\share$\folder\controlfile.ini ...
Categories: DBA Blogs

future of dba

Tom Kyte - Thu, 2019-11-21 11:50
Dear, I am Core Oracle DBA. I do not have experience in RAC,Golden Gate. Sometimes I worried about future of oracle dba in upcoming years in India for all industry like medium and large company. Can you give some recommendation or new technology n...
Categories: DBA Blogs

questions about sampling

Tom Kyte - Thu, 2019-11-21 11:50
<b>a. how does sampling work internally ?</b> meaning: how is it determined by Oracle which blocks are read by a sample-query and which not ? <code>create table t as select level i, rpad('a', 1000, 'a') s from dual connect by level <= 1e5; cre...
Categories: DBA Blogs

Local temporary tablespace

Tom Kyte - Thu, 2019-11-21 11:50
Since Oracle 12.2, Oracle has introduced a new feature of local temporary tablespace. The documentation does not provide any information on the pros and cons of this new feature. Can you please provide some information on why this feature was introdu...
Categories: DBA Blogs

Is Your Print Screen not Working? We are here to help!

VitalSoftTech - Thu, 2019-11-21 09:54

Print Screen is a hotkey present on your keyboard that helps you take the snapshot of your desktop screen and save it on the computer. All you have to do is press this button, open Paint, press ‘Ctrl+V,’ crop the image to your setting and Voila! Computers make everything we do more comfortable, including the […]

The post Is Your Print Screen not Working? We are here to help! appeared first on VitalSoftTech.

Categories: DBA Blogs

Installing Oracle GoldenGate Microservices – Part 2 of 2

DBASolved - Wed, 2019-11-20 14:32

In the my last post, I showed you how to install the binaries for Oracle GoldenGate Microservices.  Then at the end of the post, I mentioned that you will need to run Oracle GoldenGate Configuration Assistant to finish the configuration of Oracle GoldenGate Microservices.  Let’s take a look at how to do this. After installing […]

The post Installing Oracle GoldenGate Microservices – Part 2 of 2 appeared first on DBASolved.

Categories: DBA Blogs

Installing Oracle GoldenGate Microservices – Part 1 of 2

DBASolved - Wed, 2019-11-20 10:43

Recently I was exchanging emails with a few community members about Oracle GoldenGate Microservices.  One of them commented on that Oracle GoldenGate Microservices was difficult to install; at the time, I was puzzled.  The reason I was puzzled was due to the install process for Oracle GoldenGate hasn’t changed since Oracle GoldenGate 12.1 came out […]

The post Installing Oracle GoldenGate Microservices – Part 1 of 2 appeared first on DBASolved.

Categories: DBA Blogs

5 Ways to Read Deleted Comments from the Reddit Archive

VitalSoftTech - Tue, 2019-11-19 09:44

Have you ever wondered how you can restore Reddit’s deleted posts from the Reddit archive? Here’s a short guide about how to see deleted Reddit posts! If you’re a Reddit aficionado, someone who is fond of reading long, fascinating threads about different topics, then you’ve probably come across deleted comments at one point or another. […]

The post 5 Ways to Read Deleted Comments from the Reddit Archive appeared first on VitalSoftTech.

Categories: DBA Blogs

Excel Average Function – A Step By Step Tutorial

VitalSoftTech - Wed, 2019-11-13 10:33

Calculating average when you only have a few entries in your data is one thing but having to do the same with hundreds of data entries is a whole another story. Even using a calculator for finding the average of this many numbers can be highly time-consuming and to be honest, quite frustrating. After all, […]

The post Excel Average Function – A Step By Step Tutorial appeared first on VitalSoftTech.

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs