13,706 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 8 months
seen Aug 26 at 19:00

Oracle DBA, Unix admin.

Available for employment! ;)


Jul
2
comment Find out which client IP and Query using highest network Bandwidth from SQL Server
This question appears to be off-topic because it is about networking
Jul
2
reviewed No Action Needed DB2 LOAD: Poor performance while loading table with large BLOBs
Jul
2
reviewed Close How many Maximum Number of database can be created in single instance of PostgreSQL?
Jul
1
comment Table income and expense is better to have it together or apart
They HAVE to be separate. Google for T-based accounting or accrual vs accounting
Jun
29
reviewed Close SQL Server Logs > Windows NT > Security
Jun
29
reviewed Close Error attaching mdf file to SQL Server 2008 R2
Jun
29
reviewed Close Error when building documentation of Postgres
Jun
29
reviewed Close Need help to create chat application database schema?
Jun
29
reviewed Close What's the most efficient UUID column type
Jun
28
comment How i can solve “ORA-03113” error when i startup oracle 11G database?
It should be recover database;
Jun
27
comment Unable to create Central Inventory
oinstall usually owns the inventory, I think
Jun
27
comment ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
Reboot, then restart everything. What OS are you running on (I realise Windows, but what version?)?
Jun
27
comment Oracle Enterprise Manage “CPU utilization” is confusing
Very well explained. +1
Jun
27
reviewed No Action Needed Partial restore of Progress DB
Jun
27
reviewed Approve suggested edit on Set simple recovery mode and shrink log files for all user created databases
Jun
27
comment Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?
What Oracle version? Are you patched up to the latest patch set (11.2.0.4, for example)? If not, patch. The ORA 600 lookup tool on My Oracle Support should then be the next thing to use. If that's no help, open a support request with Oracle.
Jun
26
reviewed Leave Closed How do you think in NoSQL?
Jun
26
comment The best way to query a partitioned table in Oracle
The optimiser should automatically do partition pruning if your partitioning strategy is sound. Shouldn't need to code around it.
Jun
26
comment SQLNET.ALLOWED_LOGON_VERSION=12 and JDBC thin client
Your best bet is to open a support ticket with Oracle, to be honest
Jun
26
reviewed No Action Needed MySQL: querying for latest messages in flat reply system