To export query results into an INSERT text file, you can use Oracle SQL Developer or Oracle SQLcl
BigDBA
by Buğra ÇOMAK
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
Visit website
ORA-39038: Object path “STATISTIC” is not supported for SCHEMA jobs.
BigDBA
by Buğra ÇOMAK
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
Visit website
Unlocking the Power of Oracle APEX: A Step By Step Guide To 19 Version Upgrade Oracle Apex 5.1
BigDBA
by Buğra ÇOMAK
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
Visit website
A Step By Step Guide To Install Oracle Platinum Service Advanced Support Gateway
BigDBA
by Buğra ÇOMAK
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
Visit website
How to Calculate Oracle Undo Retention
BigDBA
by Buğra ÇOMAK
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
Visit website
Oracle Multi tenant Architecture ORA-20000 “12c 12.2.0.1.0” container Schema does not exist or insufficient privileges
BigDBA
by Buğra ÇOMAK
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
Visit website
How to Enable Bluetooth On Linux
BigDBA
by Buğra ÇOMAK
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
Visit website
PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT “ORA-04036”
BigDBA
by Buğra ÇOMAK
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
Visit website
Oracle Database 19c Wait for an Undo Record Event “Wait for a undo record”
BigDBA
by Buğra ÇOMAK
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
Visit website
How to Kill Long Running Transactions In The Goldengate Extract
BigDBA
by Buğra ÇOMAK
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
Visit website

Follow BigDBA on FeedSpot

Continue with Google
Continue with Apple
OR