rboracle.wordpress.com
NoSQL databases – | Simply Oracle...
https://rboracle.wordpress.com/2014/11/14/nosql-databases
My professional notes, Ranit Biswas. NoSQL databases –. November 14, 2014. What is NoSQL (database). 8211; Wikipedia says…. 8211; Couchbase says…. 8211; MongoDB says…. 8211; Planet Cassandra says…. 8211; TechRepublic says…. 8211; Oracle 12c says…. List of NoSQL databases. The MongoDB 2.6 manual. Cassandra 2.1 documentation. 1 Eventual consistency and NoSQL. 2 Difference between Horizontal and Vertical Scaling — Stack Overflow. 3 Horizontal and Vertical Scaling — Blake Smith. Let’s hadoop….
orastory.wordpress.com
Epoch | OraStory
https://orastory.wordpress.com/2015/06/26/epoch
Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). SQL Plan Baseline Manual Evolution. SQL Plan Management Choices →. June 26, 2015. Note to self because it’s just one of those date/timezone-related topics which just doesn’t seem to stick…. Epoch/Unix time – See https:/ en.wikipedia.org/wiki/Unix time. Firstly when converting from Oracle date or timestamp – we need to work from UTC not local time. Assuming that this timestamp is in milliseconds:.
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: May 2011
http://saubbane.blogspot.com/2011_05_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Monday, May 16, 2011. Reading and Writing Excel file (.xls) From PL/SQL Using COM - PART III. For details see Part I. Here is another version of the package ORDExcelSB. The earlier versions has a drawback. If you modify an existing excel file, then you can't save it in the same name. That caused the application to be hanged. You always have to save the modified file with a new name ("save as"). FUNCTION FormatFont...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: February 2011
http://saubbane.blogspot.com/2011_02_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Wednesday, February 23, 2011. Sending Multiple attachment (BLOB) using UTL SMTP. This is an example of sending multiple attachment through PL/SQL using UTL SMTP. This code is posted in OTN. SQL /* My database version */. SQL SELECT * FROM v$version;. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod. PL/SQL Release 10.2.0.3.0 - Production. CORE 10.2.0.3.0 Production. 2 src file BFILE;. SQL /* Checki...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: September 2011
http://saubbane.blogspot.com/2011_09_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Monday, September 5, 2011. Thesee are some scripts I posted in OTN various times. I am trying to collate them together in this thread. Script I: Exporting particular schema(s). L dp handle NUMBER;. L last job state VARCHAR2(30) := 'UNDEFINED';. L job state VARCHAR2(30) := 'UNDEFINED';. L logfilename VARCHAR2(20) := to char(sysdate, 'DDMMRRRR') '.log';. L dp handle := DBMS DATAPUMP.OPEN(operation = 'EXPORT',. L exp...
dbastuff.net
DBAStuff: MySQL Enterprise Backup, Using Incrementals
http://www.dbastuff.net/2015/02/mysql-enterprise-backup-using.html
Notes, thoughts and general wonderings. MySQL Enterprise Backup, Using Incrementals. As an experiment I have been testing MySQL Enterprise Backuip (MEB) and incremental backups. The database we are testing is 4TB. Full backup (4TB) - 16 hours. Cummulative (25GB) - 11 hours 30 mins. Differential (20GB) - 10 hours 50 mins. The process involves new using the following parameters:. Specifies the type of backup. Specifies the backup location. Specifies the base backup. For MEB 3.10 users - there is a bug ...
dbastuff.net
DBAStuff: Opinions and other stuff......Support
http://www.dbastuff.net/p/opin.html
Notes, thoughts and general wonderings. Opinions and other stuff.Support. General Wonderings - Support and it's real costs. My opinion is that few companies get it right and considering we are paying, is this good enough? Do companies realise that support is the interface to the customer and it is worth the effort to get it right and make the experience a good one. Rant over.back to work. Subscribe to: Posts (Atom). Opinions and other stuff.Support. MySQL, is this the beginning of the decline? Quick, whi...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: Listing Operating system disk usages with Oracle External Table PREPROCESSOR feature
http://saubbane.blogspot.com/2015/03/listing-operating-system-disk-usages_10.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Tuesday, March 10, 2015. Listing Operating system disk usages with Oracle External Table PREPROCESSOR feature. This is based on one of my posting in OTN. Database version and directory setups. Now, the OS setups:. Oracle@localhost saubhik]$ # My Operating System. Oracle@localhost saubhik]$ uname -a. Oracle@localhost saubhik]$ cat free space.sh. This shell script is call by External Table's PREPROCESSOR claus.
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: Some interesting Oracle Tuning videos
http://saubbane.blogspot.com/2015/04/some-interesting-oracle-tuning-videos.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Sunday, April 5, 2015. Some interesting Oracle Tuning videos. Subscribe to: Post Comments ( Atom ). 1 The Tom Kyte Blog. Inside the Oracle Optimizer. Inside the Oracle Optimizer - Removing the black magic. Richard Foote's Oracle Blog. Steven Feuerstein on Oracle PL/SQL. The Arup Nanda Blog. Example of downloading a pdf from web (https) and . Some interesting Oracle Tuning videos. View my complete profile.
SOCIAL ENGAGEMENT