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
Truncate SYS.AUD$ Using dbms_audit_mgmt Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: mushy_1983 on Sun, 17 October 2021	7	4365	Mon, 18 October 2021 07:55 By: Michel Cadot
log_archive_dest truncate Oracle12.2 By: Mat44 on Fri, 01 October 2021	2	3841	Fri, 01 October 2021 04:47 By: Mat44
understanding user profile resource parameter CPU_PER_CALL Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 24 September 2021	1	3070	Fri, 24 September 2021 10:27 By: Michel Cadot
RMAN backup hangs Oracle 18.3, OEL 7.7 By: ApnaDBA on Sun, 15 August 2021	4	9763	Tue, 14 September 2021 10:40 By: gazzag
Broken Job Oracle 12 Unix By: tractor_boy on Wed, 11 August 2021	1	8167	Wed, 11 August 2021 05:52 By: John Watson
Unified Auditing Trail to find grants of privileges on an object Oracle Database Version 19.11.0.0.0 By: wtolentino on Tue, 27 July 2021	6	14897	Tue, 27 July 2021 14:54 By: wtolentino
ORA-01805 Timezone files error By: db_senior on Mon, 26 July 2021	4	14239	Mon, 26 July 2021 11:46 By: EdStevens
Too many parse error with error-12850 Oracle, 12.1.0.2, Windows By: patdev on Thu, 15 July 2021	3	4538	Fri, 16 July 2021 07:58 By: Michel Cadot
User process details (merged) By: unna on Wed, 02 June 2021	4	17010	Tue, 08 June 2021 15:04 By: unna
can select on dba_segments view but throwing error when using on a package Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Wed, 26 May 2021	11	13627	Tue, 01 June 2021 12:09 By: Michel Cadot
DISK_ASYNCH_IO=TRUE, FILESYSTEMIO_OPTIONS=SETALL but v$iostat.file=ASYNC_OFF Oracle 19.3 By: burkinaone on Fri, 21 May 2021	7	11649	Tue, 25 May 2021 09:13 By: burkinaone
db_32k_cache_size RHEL RHEL 7.9, Oracle 19.3 By: burkinaone on Tue, 18 May 2021	6	8645	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	7860	Sat, 08 May 2021 00:45 By: Michel Cadot
Grant Select rights Oracle 12c Win 2008 By: Linou14 on Wed, 05 May 2021	2	9427	Wed, 05 May 2021 15:20 By: EdStevens
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021	4	7764	Mon, 26 April 2021 05:15 By: Michel Cadot
Export and Import of huge schemas 19c By: JackBauer on Fri, 16 April 2021	1	9468	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	3263	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	10120	Mon, 29 March 2021 12:52 By: John Watson
Database resources By: JackBauer on Fri, 26 March 2021	4	7008	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	11375	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	4906	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	9788	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	8537	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	10479	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	4112	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	3406	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	4624	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	6414	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	3810	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	8662	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	5436	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	4612	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	14422	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	6835	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	20598	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	5842	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	7816	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	11921	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	10189	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	4293	Tue, 27 October 2020 12:20 By: Darth Waiter