Cleaning up Oracle Recycle Bin

It is a good idea to keep tabs on the recycle bin in your Oracle database, especially after PeopleSoft upgrades. This info is in the dba_recyclebin view.

To check the size and number of objects
select count(*), sum(space)/1024/1024 AS "Size in MB" from dba_recyclebin;

To empty it
purge dba_recyclebin

Comments

  1. UnknownMarch 10, 2019 at 12:17 AM

    This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle PeopleSoft PUM and Tools 8.55

Image
Hello and welcome. I have started this blog as a reference for myself and if I can help anyone else out in the process, that's usually a good thing. Without further ado, here is the first post. I work with Oracle PeopleSoft and today had to download the first ever PUM appliance based on PeopleTools 8.55. With this update, Oracle has changed the way you load/create the PUM database for applying updates. (i.e. Tax updates). In the past all we did was download the Virtual Box image, extract it and import into Virtual Box.  There are now 2 different options. Use the new Puppet based DPK's which will install and build a PeopleSoft instance/database on a VM you already have. (for example in your VMware environment) Run a Powershell or Bash (depending on your Virtual Box Host OS) that will create an Oracle Linux VM in Virtual Box and then run the DPK's to build a PeopleSoft instance/database inside of that Virtual Box VM. For my purposes I am going to start with option ...
Read more

Active Directory Authentication with an Oracle Database

Image
Wouldn’t it be nice to not have to manage user passwords in your Oracle Databases? Setting up Active Directory aka Kerberos Authentication is a way to avoid having to manage passwords and allows users to authenticate against your Active Directory. Below is a list of useful links and My Oracle references that were used when setting up this example: EDIT - This post gets a lot of hits so I will include some updated information. If you're on 12c you need to add kerberos5pre to your list of services. e.g. SQLNET.AUTHENTICATION_SERVICES= (beq,kerberos5pre,kerberos5) If you are an Oracle Support Customer check out How To Configure Kerberos Authentication In A 12c Database ( Doc ID 1996329.1 ). If not, here is a good 3rd party write up  https://wiki.loopback.org/display/KB/Oracle+Database+12c+Kerberos+Configuration   Master Note For Kerberos Authentication (Doc ID 1375853.1) Configuring ASO Kerberos Authentication with a Microsoft Windows 2008 R2 Active Directory KDC (Doc ...
Read more

Cleanup Oracle ADR trace files on Linux

Here's a nice loop cleanup the Oracle DB trace files on Linux with the adrci utility. #!/bin/bash #cleanup Automatic Diagnostic Repository (i.e trace files) #set oracle_home (have a script with your home info) source ~/OracleHomeScript.sh #list current repo size echo "" echo "##############size before############" du -shx /u01/app/oracle/diag echo "" echo "Listing diag directory homes..." echo "" ADR_HOMES=`adrci exec="show homes" |grep -v "ADR Homes:"` adrci exec="show homes" |grep -v "ADR Homes:" echo "" echo "" #Set-up loop for each home # for f in $ADR_HOMES do echo "purging $f older than 1 week" #Slow ADRCI Execution When Purging Files After Upgrade to 12.2 (Doc ID 2335738.1) adrci exec="set homepath $f; purge -age 10080 -nolog" done #list ADR repo size after echo "" echo "##############size after####...
Read more