Browsing: DBA

DBA
0

https://www.funoracleapps.com/2020/09/how-to-get-oracle-sql-output-in-html.html cat > dep.sql SET MARKUP HTML ON SPOOL ONset termout offset pages 999set pagesize…

DBA
0

https://docs.oracle.com/cd/B19306_01/server.102/b14198/scripts.htmhttps://oracle-base.com/articles/misc/install-sample-schemashttps://ahmedfattah.com/2019/12/23/installing-oracle-sample-schemas-19-3/https://github.com/oracle/db-sample-schemas/blob/master/mksample.sql @mksample oracle_4U oracle_4U hr oe pm ix sh bi users temp $ORACLE_HOME/demo/schema/log/ rac-scan:1521/ORCL

DBA
0

https://dbaclass.com/article/how-to-find-the-temp-tablespace-usage/ select a.tablespace_name tablespace, d.TEMP_TOTAL_MB, sum (a.used_blocks * d.block_size) / 1024 / 1024 TEMP_USED_MB, d.TEMP_TOTAL_MB…

DBA
0

http://stepintooracledba.blogspot.com/2012/12/rman-06617-until-time-is-ahead-of-last.html RMAN-06617: UNTIL TIME () is ahead of last NEXT TIME in archived logs ()…

DBA
0

https://rupeshanantghubade.blogspot.com/2017/05/how-to-attach-oracle-home-to-inventory.html $ORACLE_HOME/OPatch/opatch lsinventory export OHOME=/u02/ebs/app/oracle/dbhome/11.2.0.4/hermesexport OHOMENAME=OraDB11204Home1cd $OHOME/oui/bin ./runInstaller -attachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $*Starting Oracle Universal Installer……

DBA
0

select min(maxnc), null from  (select max(next_change#) maxnc from v$backup_redolog group by thread#) col min(maxnc) format…

1 2