DBA Blogs

Oracle Block Size

Tom Kyte - Thu, 2017-11-09 10:06
Hi Tom, I would be very grateful if you could share your thoughts on Oracle block size. "rule of thumb" is Oracle Database block sizes (2 KB or 4 KB) for online transaction processing (OLTP) or mixed workload environments and larger block size...
Categories: DBA Blogs

Where clause mix of AND and OR with()

Tom Kyte - Thu, 2017-11-09 10:06
Hello, I need to mix and or in where cluse: like: and con1 and (con2 or con3 or con4)... t_where := t_where || ' and a.field1 = ''' || l_1 || '''' || ' ( ' || 'a.field2 = ''' || l_2 || '''' || ' or ' || ......
Categories: DBA Blogs

sql loader and date

Tom Kyte - Thu, 2017-11-09 10:06
hi!!! i am using sqlloader, i have a table T in my database T (empno, start_date date, resign_date date) my data file has data like this (date format IN THE DATAFILE is 'YYYYMMDD') 1, 19990101,20001101 2, 19981215,20010315 3, 19950520...
Categories: DBA Blogs

Tabuler row no

Tom Kyte - Thu, 2017-11-09 10:06
In oracle forms 12c, I created data block with tabula, I changed the otem row number displayed to 10 row, I need to get current selected row no in this tabuler on form at run time not current_record, O mean this number between 1 to 10, I tried get ...
Categories: DBA Blogs

SGA_target is greater than the total physical memory on the server (Windows)

Tom Kyte - Thu, 2017-11-09 10:06
HI Tom, We have a databases running on with memory parameters set as below: This is a windows server 2008 R2. SQL> show parameter sga NAME TYPE VALUE ------------------------------------ --...
Categories: DBA Blogs

What´s your oppinion about the DBA job in the future

Tom Kyte - Thu, 2017-11-09 10:06
Hi Tom, First, i would like to thank you for your site in web. I learn a lot of things with the doubts of my coleages registered in this site. I learn too how to explain to the developers using examples (like you). Well, i would like to know wh...
Categories: DBA Blogs

List of Networking Concepts to Pass AWS Cloud Architect Associate Exam

Pakistan's First Oracle Blog - Wed, 2017-11-08 16:31
Networking is a pivotal concept in cloud computing. Knowing it is a must to be a successful Cloud Architect. Of course you won't be physically peeling the cables to put RJ45 connectors on but you must know various facets of logical networking.

You never know what exactly gonna be in the exam but that's what exams are all about. In order to prepare for AWS Cloud Architect Associate exam you must thoroughly read and understand the following from AWS documentation:

Before you read above, it would be very beneficial if you also go and learn following networking concepts:

  • LAN
  • WAN
  • IP addressing
  • Difference between IPV4 and IPV6
  • CIDR
  • VPN
  • NAT
  • DNS
  • OSI Layers
  • TCP
  • UDP
  • ICMP
  • Router, Switch
  • HTTP
  • NACL
  • Internet Gateway
  • Virtual Private Gateway
  • Caching, Latency
  • Networking commands like Route, netstat, ping, tracert etc
Feel free to add any other network concept in comments which I might have missed.
Categories: DBA Blogs

IS JSON is not working for Nested Jsons

Tom Kyte - Wed, 2017-11-08 15:46
Hi Team, In one of our table we have column which holds JSON format text. data will be inserted to this column from a file we receive from Vendor. While Inserting the data to this column we dont't validate whether its in JSON format or not but bef...
Categories: DBA Blogs

RMAN Backup script

DBA Scripts and Articles - Wed, 2017-11-08 03:54

This is a sample backup script I used, it has already a lot of options. Feel free to make any modification you want. If you add some good enhancements, let me know I can put them here so everybody can profit from them. RMAN Backup script [crayon-5a031da255613263047755/]  

The post RMAN Backup script appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Error handling behavior change according to PLSQL_OPTIMIZE_LEVEL

Tom Kyte - Tue, 2017-11-07 21:26
We had faced a case in our application where error message disappear according to PLSQL_OPTIMIZE_LEVEL. I had isolated the problem in a simple script. Run this script, you will see that at first execution of the procedure "test_error_proc#" error i...
Categories: DBA Blogs

SQL Query based on performance

Tom Kyte - Tue, 2017-11-07 21:26
Hi Tom, There is a table say t_tab with columns a,b and c. Data in the table is huge(more than million). You run the following three statements: 1. select * from t_tab 2. select a,b,c from t_tab 3. select b,c,a from t_tab Will there be a diffe...
Categories: DBA Blogs

Fuzzy Matching in SQL

Tom Kyte - Tue, 2017-11-07 21:26
Is there any SQL construct that does fuzzy matching ? As an example , if I have the values as Monroe , Monroe Twp , Monroe Township , "Monroe Twp,NJ" , I would like to consider them as one value .
Categories: DBA Blogs

Subquery with Select statement works in 12C but not on 11g.

Tom Kyte - Tue, 2017-11-07 21:26
Hi I am trying to run a select query which has the sub queries it is running well and good in 12C environment but its throughout error in 11g. Could you please help me on this. Thanks, Kumar
Categories: DBA Blogs

Index creation on empty column on Large Table

Tom Kyte - Tue, 2017-11-07 21:26
Quite a time we face a situation where we have large table with Hundreds of Millions of records(sometimes even Billions of records), and we might need to add column to that table and then add index on that new column. We have absolute control over...
Categories: DBA Blogs

ORA-29284: file read error for a few lines

Tom Kyte - Tue, 2017-11-07 21:26
Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will hav...
Categories: DBA Blogs

using connect by without relationship using parent_id

Tom Kyte - Tue, 2017-11-07 21:26
Hi, I have information about father's , mother's and children but there is no relationship between the rows using Paernt_id as follows, <code>drop table tbl_family; create table tbl_family ( father nvarchar2(50) , mother nvarchar2(50) , ...
Categories: DBA Blogs

database migration from AIX to Linux

Tom Kyte - Tue, 2017-11-07 21:26
Hello Tom, We are planning to migrate database from AIX to Linux. Because of different endian we can't built the standby,here my request was Production databases have 30-40TB of data. Some tables have 1-5 TB of only data what was the best way...
Categories: DBA Blogs

Replication of multiple sourde database to a single read only database

Tom Kyte - Tue, 2017-11-07 21:26
Dears Hope you are fine,,, I have a distributed database about 20 branch,,, each database have the same schema structure we need a centralized report that reads from only four tables. currently we take a dump file from each branch and impo...
Categories: DBA Blogs

Guaranteed Way to Pass AWS Cloud Architect Certification Exam

Pakistan's First Oracle Blog - Tue, 2017-11-07 06:00
Today and for the sometime to come, one of the hottest IT certification to hold is AWS Cloud Architect Certification. There are various reasons for that:

  • If you pass it, it really means you know the stuff properly
  • AWS is the Cloud platform of choice world over and its not going anywhere
  • There is literally a mad rush out there as companies scramble to shift or extend their infrastructure to cloud to stay relevant and to cut costs.
  • There is a huge shortage of professional with theoretical and hands-on know-how of Cloud and this shortage is growing alarmingly.
So its not surprising that Sysadmins, developers, DBAs and other IT professionals really yearning to achieve Cloud credentials and there is no better way to do that other than getting AWS Certified.

So is there any  Guaranteed Way to Pass AWS Cloud Architect Certification Exam?

I say Yes and here is the way:

Read AWS Documentation about following AWS Services. Read about these services and read them again and again and then again. Learn them like you know your name. Get a free account and then play with these services. When you feel comfortable enough with these services and can recite them to anyone inside out then go ahead sit in exam and you will pass it for sure. So read and learn all services under sections:

  • Compute
  • Storage
  • Database 
  • Network & Content Delivery
  • Messaging
  • Identity and Access Management
Also make sure to read FAQs of all above services. Also read and remember what AWS Kinesis, WAF, Data Pipeline, EMR, Workspace are. No details are necessary for these ones but just what they stand for and what they do.

Best of Luck.
Categories: DBA Blogs

Passed the AWS Certified Solutions Architect - Associate Exam

Pakistan's First Oracle Blog - Tue, 2017-11-07 05:11
Well, it was quite an enriching experience to go through taking the AWS certification exam and I am humbled to say that I passed it. It was first time, I underwent any AWS exam and I must say that quality was high and it was challenging and interesting enough. 

I will be writing soon as how I prepared and what are my tips for passing this exam.

Good night for now.
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator - DBA Blogs