Reputation
484
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 11
Impact
~83k people reached

  • 0 posts edited
  • 0 helpful flags
  • 35 votes cast
Mar
30
awarded  Popular Question
May
25
awarded  Notable Question
Feb
22
comment Oracle tsping.exe - where to get/download it
@jmsmcfrlnd, a successful tnsping indicates only that the listener is running. A successful jdbc connection test using username, password and service name indicates that the Oracle instance offering the service is accessible and accepts connections - i.e. pretty much all you need to know when testing a connection to a database.
Dec
22
awarded  Yearling
Nov
6
awarded  Notable Question
Jun
16
awarded  Notable Question
Mar
6
comment Oracle tsping.exe - where to get/download it
It's part of the client (not instant client) and database installations. In SQL Developer you may test a connection using jdbc (new connection -> <insert parameters> -> test.
Jan
14
comment How can I determine the maximum possible number of threads?
@Preston, good job! Thanks for sharing your analysis!
Jan
10
comment Replace MySQL table with data from csv
+1 for the truncate + load approach. I would do it this way: 1. Truncate. 2. Drop indexes. 3. Load (it should be faster without the indexes). 4. Recreate the indexes after the load.
Jan
10
comment How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
I don't fully understand what you mean. What I mean is to separate schema owner and application user. These posts explain the concept: Schema Owners and Application Users and Grants to users.
Jan
10
comment How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
Correct, but I thought that you wanted exactly that. I would do it in a different way: 1. Don't store application code in the sys schema, create another application user, let's say app_owner. 2. Grant app_owner the grants it needs to compile and run the code and then, if user0 is supposed to be able to execute app_owner's procedures, 3. grant execute on app_owner.procedure to user0.
Jan
10
answered How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?
Jan
10
revised How can I determine the maximum possible number of threads?
deleted 19 characters in body
Jan
10
comment How can I determine the maximum possible number of threads?
@Preston, I've updated my post. Thanks!
Jan
10
revised How can I determine the maximum possible number of threads?
added 5053 characters in body
Jan
9
answered How can I determine the maximum possible number of threads?
Jan
9
comment Delete data from huge InnoDB table from MySQL Master and Slaves
I suppose something like this:pt-archiver --source h=localhost,D=<db_name>,t=RTesAll,S=/path/to/socket_file --where "recordDate < current_date - interval 1 year" --limit=50000 --progress=50000 --purge --txn-size=50000 --statistics --bulk-delete --dry-run. You may also consider adding check-slave-lag etc. YOU SHOULD TEST THE COMMAND BEFORE USING IT IN PRODUCTION! Check this post also.
Jan
9
revised “Can't find file mysql/plugin.frm” when starting up MySQL
added 197 characters in body
Jan
9
comment Delete data from huge InnoDB table from MySQL Master and Slaves
Check pt-archiver.
Jan
9
answered “Can't find file mysql/plugin.frm” when starting up MySQL