Search Results for: Python

Querying Many Databases in Parallel in Python

I have some Python scripts that I use to access a bunch of databases to gather information such as the size of the database. Usually it is not that important how long they take so I have been running queries … Continue reading

Posted in Uncategorized | 2 Comments

Python Formatted Print

I wanted to write a quick post to document how to format nice columns in Python. Mainly I want to remember this myself and if I put it on my blog, I can find it quickly. There are probably better … Continue reading

Posted in Uncategorized | Leave a comment

How to email from Python

I got an email asking how to send an alert email from a Python script. Here is an example based on a script I have setup: You need to replace “PUT YOUR SMTP SERVER HERE” with the host name of … Continue reading

Posted in Uncategorized | Leave a comment

Python Script to Scan Listener Log For Incoming Connections

Wrote a quick and dirty script to scan the listener log for incoming connections and produce a count of how many connections came from which host. Here is the URL: https://github.com/bobbydurrett/miscpython/blob/master/gethostcounts.py All it does is hack out the ip address … Continue reading

Posted in Uncategorized | 4 Comments

Python 3.8.1 Linux Install Without Root

I wanted to install the latest Python on Linux in a low powered user’s home directory and not have the install interfere with the Python that comes with Linux. I wanted my own local copy of Python that I could … Continue reading

Posted in Uncategorized | 2 Comments

Python Script To Backup Linux Directory To Windows

I found out that my blog backup script was failing so I had to rewrite it to handle dropped connections to my remote sftp server. In the process I broke out as much of the code as I could into … Continue reading

Posted in Uncategorized | 1 Comment

Python Practice Produced Pretty Pictures

I wrote a Python program that made some fun pictures so I thought I would share them even though this is not really a database post. I practice Python programming by doing Rosetta Code programming tasks that no one has … Continue reading

Posted in Uncategorized | Leave a comment

New utility Python scripts for DBAs

I pushed out three new Python scripts that might be helpful to Oracle DBAs. They are in my miscpython repository. remotescript.py – run Unix/Linux commands on a remote server dbversion.py – Get the version from a database – i.e. 11.2.0.4 … Continue reading

Posted in Uncategorized | 2 Comments

Hear my Python for the Oracle DBA talk in Scottsdale on November 16th

I am going to giving a talk about why Python is a good programming language for Oracle DBAs in Scottsdale on November 16th for the Arizona Oracle User Group, AZORA. We may get some other speakers together for the meeting … Continue reading

Posted in Uncategorized | Leave a comment

Copy Oracle performance reports to SharePoint using Python

I have a couple of Oracle performance reports that I upload from my work Windows 7 laptop to our corporate SharePoint site on Office 365 on a regular basis. I thought that it would save me time to automate the … Continue reading

Posted in Uncategorized | Leave a comment