13,956 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen 14 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Apr
28
reviewed Approve suggested edit on Firebird query performance with text search, also some numbers
Apr
27
comment Average CPU utilization oracle database
You'd usually do a sizing exercise and then buy hardware for 120% (say) of the estimated peak workload in N years time, then license appropriately. CPU cores can be disabled, if needs be. Also, it's best to evaluate whether you REALLY need EE - some EE features can be scripted (log shipping to standby, for example), thus saving a large amount of cash.
Apr
25
reviewed Approve suggested edit on Database cache problem
Apr
25
reviewed Approve suggested edit on New query slower even if it has less logical reads than the old one
Apr
24
reviewed Approve suggested edit on What is best way to handle transaction in sql server when inserting in 15 to 20 tables in one batch
Apr
24
comment Schema Migration for application upgrades
If your app is hardcore OLTP you're going to need to do some benchmarking on a test environment. The data gets migrated using the triggers you create - you can do this [if the data is mutually exclusive - new columns, for example] before making the new edition live. (Covered in the blog post linked above, search for "DBMS_SQL").
Apr
24
reviewed Approve suggested edit on MySQL: Access denied messages
Apr
24
answered Schema Migration for application upgrades
Apr
24
comment Two MySQL Server accessing same database over NFS
I wouldn't even think about it, in all honesty
Apr
24
answered How to check for existence of an INDEX on a column independent of used SQL database
Apr
24
comment Why does this simple select statement require quotes?
Never use double quotes when creating objects! It will only lead to pain. Just an observation too... Be careful when dealing with SSNs - don't store them unless you absolutely have to
Apr
24
comment How to make a role from schema A “grantable” in schema B
Sounds like you might want to investigate the WITH GRANT OPTION and WITH ADMIN OPTION clauses of the GRANT command
Apr
23
comment TNS-12535: TNS:operation timeout
Being able to tnsping doesn't rule out a firewall problem. When you actually establish a real connection with a client the connection gets handed off and a random return TCP port is assigned. I've seen it cause firewall issues in the past
Apr
23
reviewed Reject suggested edit on sql-audit tag wiki
Apr
23
reviewed Approve suggested edit on While importing 150 GB file on Amazon RDS, why connection is failing?
Apr
23
comment Importing a different character set export dump into another DB instance
Are you sure the dump file was created with exp and not expdp? Try importing it with impdp
Apr
23
revised App domain is marked for unload due to memory pressure
edited tags; edited title
Apr
23
reviewed Approve suggested edit on Inserting empty string on Windows MySQL doesn't use default value
Apr
22
comment Error while accessing remote mongo db
Sounds like a firewall problem
Apr
21
comment Adding new tables — memory usage increases
What is the exact problem you're having? You've configured mysql to use a certain amount of memory and it's using it. Do you want to restrict the amount if data cached?