Reputation
429
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 10
Impact
~55k people reached

  • 0 posts edited
  • 0 helpful flags
  • 34 votes cast
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
Jan
9
comment Oracle ASM Failgroup
@user3134198, it means that you have a separate failure group for each asm disk. If, for example, your asm diskgroup contains 3 asm disks, you have 3 failure groups. Note that failure groups are relevant only when asm mirroring is used (i.e. for normal and high redundancy) and nowadays asm seems to be used mainly with external redundancy. For more detailed information check the official documentation.