OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
SYS Account locked Oracle 18c Windows 10 By: grh_oracle on Tue, 16 March 2021	1	11744	Tue, 16 March 2021 12:30 By: Michel Cadot
Transactions are failing due to insufficient space in the undo tablespace Oracle 12.2.0.1, Linux 6 By: BalajiDBA on Thu, 11 March 2021	10	18106	Mon, 15 March 2021 10:56 By: EdStevens
Restrict email recipients Oracle Database Standard, 12.1.0.2, RHEL 7 By: jtaylor75 on Wed, 10 March 2021	5	15236	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	18889	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	12019	Tue, 23 February 2021 09:33 By: merouanballout
how many oracle tools do we really need to install for SE2 edition 19.0.0 windows 2016 By: juniordbanewbie on Tue, 09 February 2021	0	8418	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	12627	Tue, 09 February 2021 11:39 By: Michel Cadot
how to manually remove components in 12.1.0.2 CDB Oracle Linux 7.6 By: juniordbanewbie on Tue, 12 January 2021	2	11840	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	8280	Mon, 08 February 2021 14:49 By: Andrey_R
ORA-04031: unable to allocate 4064 bytes of shared memory Oracle 11g XE, MS Windows 7 Enterprise, 8GB RAM By: Littlefoot on Fri, 25 December 2020	4	19132	Mon, 08 February 2021 13:23 By: Littlefoot
Trace non-invokers sessions of a different instance Oracle Database 19c By: Andrey_R on Sun, 07 February 2021	7	12352	Mon, 08 February 2021 08:32 By: Andrey_R
Trying to export a table that contains blobs 11.2.0.1 By: Amine on Sat, 06 February 2021	1	9556	Sat, 06 February 2021 12:27 By: Michel Cadot
How to IMPDP to PDB? DB 19.3, RHEL By: noob2021 on Wed, 13 January 2021	9	25795	Mon, 01 February 2021 18:28 By: EdStevens
sys.x$dbgalertext alert log info text access racle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: wtolentino on Mon, 25 January 2021	3	14803	Mon, 25 January 2021 13:30 By: John Watson
how to verify if Audit Trail is capturing the latest Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Tue, 08 December 2020	24	37473	Thu, 21 January 2021 14:35 By: wtolentino
DB Time spent nowhere in AWR Oracle 12C R1 on Linux By: piripicchio on Thu, 24 December 2020	1	9896	Thu, 24 December 2020 07:46 By: John Watson
Database Upgrade - Minimum Disruption Oracle Database 11.2.0.3 Windows 2008 By: PebbleRock27 on Thu, 03 December 2020	2	13198	Fri, 04 December 2020 06:38 By: gazzag
ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production By: Andrey_R on Thu, 29 October 2020	12	23338	Wed, 18 November 2020 03:26 By: Andrey_R
Did I set up UTL_MAIL correctly and completely? 12c on Windows By: Darth Waiter on Tue, 27 October 2020	22	23791	Thu, 29 October 2020 13:03 By: Darth Waiter
How can I safely limit the amount of memory used by Oracle 12c? 12c on Windows By: Darth Waiter on Tue, 27 October 2020	4	8877	Tue, 27 October 2020 12:20 By: Darth Waiter
Oracle Database Cross Platform Migration from 9i to 11g OS:Sunsolaris to Linux,Database:9i to 11g By: sprakashyz on Mon, 12 May 2014	8	16113	Fri, 23 October 2020 10:49 By: Michel Cadot
How to get size in MB of all objects in a Schema in Oracle? Oracle database, sql By: Vinish on Mon, 19 October 2020	4	8580	Mon, 19 October 2020 16:12 By: EdStevens
SGA used Oracle 12.2 By: deepakdot on Thu, 15 October 2020	17	15132	Thu, 15 October 2020 09:22 By: John Watson
How to deal with statistics during migration By: burkinaone on Fri, 02 October 2020	3	11354	Wed, 07 October 2020 09:35 By: John Watson
Oracle12c Blocking Session Information Oracle 12c By: rohitmathur11@gmail.com on Tue, 06 October 2020	15	14899	Wed, 07 October 2020 02:59 By: rohitmathur11@gmail.com
TEMPORARY TABLESPACE UTILIZATION TREND Oracle Enterprise, 11.2.0.3, AIX 6.1 By: jesuisantony on Mon, 07 September 2020	3	11271	Mon, 07 September 2020 14:46 By: Michel Cadot
Temp Tablespace Issue somehow fixed SQL advisor Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 02 September 2020	4	9360	Thu, 03 September 2020 12:22 By: wtolentino
Empty Datafile ORACLE 12.1.0.2.0 Standard Edition By: wintert on Thu, 27 August 2020	7	12459	Thu, 03 September 2020 11:13 By: EdStevens
UPDATE taking a long time, indication disappeared Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: Andrey_R on Mon, 31 August 2020	5	10427	Mon, 31 August 2020 12:38 By: Andrey_R
histograms in dbms_stats.gather_table_stats Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 14 August 2020	1	10772	Fri, 14 August 2020 23:25 By: Michel Cadot
no listener By: oracle@learner on Sat, 25 July 2020	5	16083	Mon, 27 July 2020 06:21 By: EdStevens
Oracle Data Mining component in 19c Oracle 19c Linux By: mar20 on Mon, 06 July 2020	4	17680	Tue, 07 July 2020 02:34 By: Michel Cadot
Wrongly compile function in SYS user now problem Oracle Forms 6i By: somu4 on Thu, 02 July 2020	10	23609	Fri, 03 July 2020 10:08 By: EdStevens
DBA practice on cloud By: Mark70 on Fri, 26 June 2020	3	16006	Fri, 26 June 2020 09:14 By: EdStevens
Datafile cannot be open by either non cdb or cdb instance 19.0.0, windows 2016 64 bit By: juniordbanewbie on Tue, 16 June 2020	4	21154	Wed, 17 June 2020 04:16 By: juniordbanewbie
How to determine the size of backup increased in last one month oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM By: janakors on Tue, 02 June 2020	12	28356	Wed, 10 June 2020 10:41 By: janakors
SQL text history Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Mon, 08 June 2020	3	15723	Tue, 09 June 2020 00:06 By: Michel Cadot
Ora-48181. no space left on the device oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM By: janakors on Tue, 19 May 2020	13	31874	Thu, 04 June 2020 06:59 By: janakors
how to verify gather schema statistics Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 15 May 2020	4	15541	Fri, 15 May 2020 14:18 By: wtolentino
Oracle DB Upgrade Clarification Oracle 11.1.0.7 Enterprise Edition, AIX 6.1 By: jesuisantony on Fri, 01 May 2020	4	15173	Fri, 08 May 2020 03:10 By: jesuisantony