
BigDBA
153 FOLLOWERS
Keep up with articles from BigDBA.
BigDBA
4M ago
In the realm of oracle database management, engineers often rely on robust tools to streamline their workflows and enhance productivity. Two such indispensable tools are Oracle SQL Developer and Oracle SQLcl (command line). Both tools serve distinct purposes but are equally valuable in an engineer’s toolkit. Whether you prefer the graphical interface of SQL Developer […]
The post To export query results into an INSERT text file, you can use Oracle SQL Developer or Oracle SQLcl appeared first on BigDBA - Database,Devops,Big Data,Cloud & Oracle Blog ..read more
BigDBA
6M ago
I recently encountered a problem like the following, you can follow the steps below for a solution ?
The post ORA-39038: Object path “STATISTIC” is not supported for SCHEMA jobs. appeared first on BigDBA - Database,Devops,Big Data,Cloud & Oracle Blog ..read more
BigDBA
11M ago
Understanding Oracle APEX:
Oracle APEX is a low-code development platform that empowers users to build data-centric web applications swiftly. Leveraging SQL and PL/SQL, developers can create responsive and feature-rich applications without extensive programming knowledge. APEX offers a plethora of pre-built components and templates, facilitating rapid prototyping and deployment.
Key Features of Oracle APEX:
Drag-and-Drop Interface: APEX’s user-friendly interface allows developers to design applications effortlessly by simply dragging and dropping components onto the canvas.
Responsive Design ..read more
BigDBA
11M ago
Oracle Advanced Support Gateway is a crucial component for managing and maintaining Oracle Engineered Systems effectively. It provides advanced support capabilities, allowing businesses to optimize performance, enhance security, and streamline operations. The installation process involves several steps, including preparation, software download, configuration, testing, and documentation. Each step must be executed carefully to ensure a successful installation and integration with existing systems.
During the preparation phase, it’s essential to review system requirements and ensure compatibilit ..read more
BigDBA
1y ago
Hi folks, I decided to write a practical article for the Undo retention calculation. The transaction undo information generated in the database is stored in the rollback segments until the commit or rollback is performed. Sometimes our long-running queries in the database are met with the error ”ORA-01555:Snapshot Too Old”.
This is due to the fact that our UNDO parameters are not configured correctly.
If you are wondering how many ORA-1555 errors our database receives in total, you can find it with the following query.
select ‘”ORA-01555 (Snapshot too old)” hata sayisi: ‘
|| sum(ssolderrcnt ..read more
BigDBA
1y ago
I recently had to face such a problem. For those who give up, the answer is below
exec dbms_Stats.gather_schema_stats(‘TESTSCHEMA’);
ERROR at line 1:
ORA-20000: Schema ” TESTSCHEMA” does not exist or insufficient privileges
ORA-06512: at “SYS.DBMS_STATS”, line 38330
ORA-06512: at “SYS.DBMS_STATS”, line 38289
ORA-06512: at “SYS.DBMS_STATS”, line 8593
ORA-06512: at “SYS.DBMS_STATS”, line 38172
ORA-06512: at “SYS.DBMS_STATS”, line 38317
ORA-06512: at line 1
select dbms_stats.get_prefs(‘concurrent’) from dual;
exec dbms_stats.set_global_prefs(‘CONCURRENT’,’FALSE’);
SQL> exec dbms_Stats ..read more
BigDBA
1y ago
Recently, I needed to use bluetooth on my computer using the linux operating system, and I saw that the services were turned off, I share the steps and controls I applied as follows. You can also follow the same similar steps to give an idea in these distro’s as well: debian, ubuntu, kali, redhat, rhel6,7,8,9
sudo apt-get update
sudo apt-get upgrade
sudo nano /etc/apt/sources.list –> we’ve linux distros deb file is ok.
Example sources.listfor Debian 12/Bookworm (stable).
deb http://deb.debian.org/debian bookworm main
deb-src http://deb.debian.org/debian bookworm main
deb http://deb.debi ..read more
BigDBA
1y ago
Unable to allocate memory for new incident error in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/instance_name_m72034.trc:
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
I had a same problem and solved it by doing the following.
See what the current pga_aggregate_limit is using this (in case you want to revert your changes):
show parameter pga_aggregate_limit;
alter system set pga_aggregate_limit = 0;
or
alter system set pga_aggregate_limit=30348M scope=both;
The post PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT “ORA-04036” appe ..read more
BigDBA
1y ago
Hi Folks,
I recently saw wait events on the single instance database, the root cause of the problem was caused by the undo event “Wait for a undo record”.
There are cases where parallel process recovery is not as fast as serial process recovery, because the PQ secondary can interfere with each other’s operation by competing for the same resource. With such a process rollback, the performance may be worse in parallel compared to serial rollback.
Due to this contention and the perceived slowness and ‘hang’-like symptoms (the database may seem to hang, the SMON and parallel query secondary may se ..read more
BigDBA
1y ago
You can’t close an extract that is a long running transaction with Golden gate. Let’s find out how it’s done.
./ggsci
You can check extract
GGSCI (dev) 21> info all
GGSCI (dev) 21> send extract name showtrans tabular
GGSCI (dev) 21> stop extractname
STOP request pending. There are open, long-running transactions.
Before you stop Extract, make the archives containing data for those transactions available for when Extract restarts.
To force Extract to stop, use the SEND EXTRACT GREPORA_EXT, FORCESTOP command.
Oldest redo log file necessary to restart Extract is:
You can copy e ..read more