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
db_32k_cache_size RHEL RHEL 7.9, Oracle 19.3 By: burkinaone on Tue, 18 May 2021	6	13846	Fri, 21 May 2021 15:27 By: EdStevens
VARCHAR2 Stored in DB in Terms of Bytes Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit By: robh0502 on Sat, 08 May 2021	1	11333	Sat, 08 May 2021 00:45 By: Michel Cadot
Grant Select rights Oracle 12c Win 2008 By: Linou14 on Wed, 05 May 2021	2	13364	Wed, 05 May 2021 15:20 By: EdStevens
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021	4	14902	Mon, 26 April 2021 05:15 By: Michel Cadot
Export and Import of huge schemas 19c By: JackBauer on Fri, 16 April 2021	1	12680	Fri, 16 April 2021 04:02 By: Michel Cadot
ORA-01653: unable to extend table Oracle 11.2.0.4.0 By: ak1900 on Wed, 07 April 2021	1	6479	Wed, 07 April 2021 09:10 By: John Watson
Not able to hot clone remote pdb with same name 19.0.0, Windows 2016 By: juniordbanewbie on Thu, 25 March 2021	5	13832	Mon, 29 March 2021 12:52 By: John Watson
Database resources By: JackBauer on Fri, 26 March 2021	4	10749	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	14448	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	7502	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	13638	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	11613	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	13611	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	7922	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	5197	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	8053	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	8501	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	5437	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	13357	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	8123	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	6411	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	19081	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	9968	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	26568	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	7015	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	9125	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	15854	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	15381	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	5491	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	11975	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	5294	Mon, 19 October 2020 16:12 By: EdStevens
SGA used Oracle 12.2 By: deepakdot on Thu, 15 October 2020	17	9502	Thu, 15 October 2020 09:22 By: John Watson
How to deal with statistics during migration By: burkinaone on Fri, 02 October 2020	3	7273	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	9894	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	6940	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	5820	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	8585	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	6963	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	7071	Fri, 14 August 2020 23:25 By: Michel Cadot
no listener By: oracle@learner on Sat, 25 July 2020	5	11300	Mon, 27 July 2020 06:21 By: EdStevens