MILLION DOLLAR SERVER

Turbocharging Nginx on Oracle Cloud ARM: Zero-Copy HTTPS with Kernel TLS (kTLS) If you run high-concurrency web applications, media assets...

Download Alpine Linux Cloud Image from: https://www.alpinelinux.org/cloud/ Upload the image to OCI and create an instance from it. I ...

Follow Oracle's Offical guide Configuring SPF For Americas Region SPF Record v=spf1 include:rp.oracleemaildelivery.com ~all The fol...

Try to clean up your Oracle Cloud Account and Tenancy? You can delete your Account / Tenancy by following the steps mentioned in the link be...

Normal I use GParted CD boot a VM to growing a Linux ext4 disk partition. Or using LVM. It's way easier on Windows VM. I tried cloud-ut...

Try to clean a large table (non partition, over 5 trillion records) on a old Oracle 10g Database. [TYPE_ID] in the PK. First try: DELETE...

After Someone type the wrong password in the application, the user been locked in Oracle Database. SQL*Plus: Release 10.2.0.5.0 - Production...

Need Setup a PHP Web Server can access to Oracle Database. Configuring PHP with OCI8 First Install Apache and PHP apt-get install php5-my...

Oracle Linux: Maximize Performance / Minimize Downtime http://medianetwork.oracle.com/video/player/2921003278001 Oracle’s Greg Marsden provi...

My 10.2 database crashed suddenly. Can't login by # sqlplus / as sysdba Can't shutdown it I have to reboot the server. Got error aft...

Oracle database logs doesn’t rotate by it self. As time goes by, the server may hold logs that are too big to read and takes too much storag...

If the strings length changes a lot, the rowid could change. it will be safer to do it with PK together: update t set... where rowid = :x ...

1.Install php-pear pecl # yum install php-pear gcc 2.Install oracle-instantclient-devel # rpm -ivh oracle-instantclient-devel-10.2.0.5-1.i38...

Try to remove Streams setting: SQL> exec DBMS_STREAMS_ADM.remove_streams_configuration(); ORA-06564: object "MDS"."BIN$2m0...

SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- /oracle_drives...

$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 16 10:46:20 2013 Copyright (c) 1982, 2010, Oracle. All Rights Re...

tnsping is a very handy tool from Oralce. But it does not include with Oracle Instant Client! To add it, you will need a Oracle Client softw...

This is a guide of Install sqlplus with the minimal oracle-software fingerprint. I try to not install the Oracle Client in my computers, it ...

Just happened today on an new Oracle Build. In Oracle Database, A remote DBA face this because password have reached 180 Default limit for P...

SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece; select sid,user_name...