DBA Blogs

Hi Tom, How to do sorting the data in alphabetical order and assign the rank of them like I have data and assign the rank(rank must be assign alphabetical order) like this. for that, I used to order by, <code>A ADAMS-1 ALLEN-2 B B...

Hi Tom, Can you please explain me difference between dequeue options dbms_aq.remove and dbms_aq.remove_nodata using in dbms_aq.dequeue. 2. Does dbms_aq.dequeue generate more redolog log that normal delete statement. Is it advisable to hav...

Hi, I have installed oracle 11g and created database name XYZ in machine A Two systems are connected in same network which is reachable by ping ip address port is also open How B machine will access the DB XYZ on A machine ?? Thanks ...

Hi Oracle professionals, Please advice us and give right direction. We have database on 12c on OS Red Hat Enterprise Linux Server release 6.10 with memory settings: SGA: 4928M PGA: 1250M OS memory: 8GB CPU q-ty: 2 Huge Pages disabled. I...

From https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/innodb-information-schema-buffer-pool-tables.html warning that Querying the INNODB_BUFFER_PAGE or INNODB_BUFFER_PAGE_LRU table can can affect performance. From the source code i can find th...

good day Tom - I am writing to you because I am having problems with a development where I need to access a linux server to extract files dynamically and place them on my windows server using the scp command supported in a java library. but it is ...

Hello Oracle Masters, I have a very basic question to understand the internal behavior of oracle. I read couple of blogs and unfortunately end up in confusion; So thought of asking you .. Assume, i m updaing a block (a record) and not issued...

Hi Tom, I have this requirement but regexp_replace is behaving odd here. It gives me all NULL Requirement for function- Suppose a number 9845-089160 ? function logic should convert one digit at a time and not entire number in one go. ? First ...

Hi Tom, How can I find partitions (PARTITION BY RANGE (DATE) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) of two tables within same date range (HIGH_VALUE) to merge those partitions? I have many tables and I am trying to create a script for it. Thanks...

Hi, My Windows System Administrator colleague wants to replace classical RMAN backup with a proprietary tool (VEEM). That tool apparently has some ability to take the snapshot backup of the database (see more https://www.veeam.com/blog/how-to-back...

During the installation of some application software, we build the necessary schema objects in Oracle if they don't exist. Additionally, we point out any potential problems to the user doing the install. Some of these problems vary with the Oracle se...

Scenario: I have a table called test1 with 2 columns say Id(NUMBER(10,0)), SearchData(CLOB). <code>Id SearchData 1 COLL-ETTE AKACOMMON 2 @#$!%*@#$!%*@#$!%*</code> Statement1: select * from test1 where contains (SEARCHDATA ,'\-ETTE AKACOMMO...

Hello, There is a requirement for us where non users should be restricted from logging to the application in a trigger in Oracle forms which use PL SQL. This needs to be done using a new database function. I only have a developer access and not a...

Hi, We dropped and re-created a materialized view group and would like to add it in a certain materialized view group but an ORA-22165 is encountered when trying to add the materialized view in an existing group. Can I ask how this is encountered?...

I just want to create triggers for checking salary that employee salary cannot exceed manager's. there are one table: EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SALARY,DEPTNO) FK:MGR references EMPNO Thanks.

Hello, teams These two days I've deployed Oracle RAC 18c on OL 7.5 (my Linux server) via VirtualBox 5.2.18. During this time I encountered some problems as follows, (1) after installing RPM "oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm",...

Hi Tom,I have met a SQL that with the latest statistics and the execution plan is in the wrong estimate-rows ,that's to say,it's a large difference between the estimate and the actual,the sql statement and execution is below: <code>select t1.card_no...

Hello, we have a requirement to load multiple data based on different conditions. The details are as below, Create: <code> create table table_a (empno number, empname varchar2(50),salary number, status varchar2(30)) / Control file: opt...

APIs are at the center of the digital economy and new business models are associated with them. They have become a foundational technology for the development of scalable enterprise applications and...

We share our skills to maximize your revenue!

My System tablespace has grown to approx 15GB. Is that normal?? The top 3 space taking segments are as follows- I_HH_OBJ#_COL# 1.375 I_HH_OBJ#_INTCOL# 1.375 I_COL1 ...