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
Database resources By: JackBauer on Fri, 26 March 2021	4	14776	Sat, 27 March 2021 08:23 By: BlackSwan
audit use of dynamic sql DB 19.x By: John Watson on Thu, 18 March 2021	3	18930	Fri, 19 March 2021 14:49 By: John Watson
SYS Account locked Oracle 18c Windows 10 By: grh_oracle on Tue, 16 March 2021	1	11916	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	18574	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	15538	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	19172	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	12387	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	8530	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	13094	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	12097	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	8491	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	19583	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	12888	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	9728	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	26438	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	15243	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	39055	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	10088	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	13440	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	24217	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	24870	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	9203	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	16528	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	8861	Mon, 19 October 2020 16:12 By: EdStevens
SGA used Oracle 12.2 By: deepakdot on Thu, 15 October 2020	17	15811	Thu, 15 October 2020 09:22 By: John Watson
How to deal with statistics during migration By: burkinaone on Fri, 02 October 2020	3	11588	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	15570	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	11488	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	9604	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	12858	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	10752	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	10996	Fri, 14 August 2020 23:25 By: Michel Cadot
no listener By: oracle@learner on Sat, 25 July 2020	5	16370	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	18140	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	24038	Fri, 03 July 2020 10:08 By: EdStevens
DBA practice on cloud By: Mark70 on Fri, 26 June 2020	3	16268	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	21654	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	28924	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	16039	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	32668	Thu, 04 June 2020 06:59 By: janakors