Tags » Database

MySQL example databases

So far, I’ve taken one class on Php since I’ve been in this program, and that was over a year ago, so I’ve been wanting to try to build a portfolio piece that shows some level of competence in managing pages backed by a database. 327 more words

Projects

DataTable Row Loop c# Performance Testing (Linq vs. Select vs. Parallel vs. For)

I still find myself using DataTables (from SQL Server, mySQL, etc.) on a regular basis. In an effort to see how some different methods of looping through the data performs and what method might be the fastest, I put together some small, fast tests, below are my test results. 259 more words

.net

Useful SQL Maintenance Scripts

Missing Index Script

You shouldn’t use this to blindly create indexes but it will give you a good idea where you might need them and which columns to include. 356 more words

Programming

Orphaned Clone PDB

I just had some fun with Oracle 12c PDBs and snapshot clones. In the alert.log I found some unexpected errors “ORA-01157: cannot identify/lock data file XX”. 572 more words

Database

OID - ODS Password Resets

# Issue : OID cannot restart, logs show the following messages :


   []     Guardian: Connecting to database, connect string is oiddb

   []     Guardian:  ORA-28002, ORA-28002: the password will expire within 7 days
   []     Guardian: : Unable to connect to database,
will retry again after 10 sec

   []     Guardian: Connecting to database, connect string is oiddb

   []     Guardian:  ORA-28002, ORA-28002: the password will expire within 7 days

… 127 more words

kernel.panic_on_oops: New Oracle 12c Installation Requirement

Hi all,
Do you know what mean the parameters on installing 12c?

This parameter controls the kernel’s behaviour when an oops or bug is encountered: 120 more words

Database