Tag Info

Hot answers tagged

4

I think as a DBA you will inevitably lose the fight to keep hands out of your database. Having said that I think we owe it to our customers to try and provide a product that they can use. There are dangers and pitfalls of even read-only access that any DBA should be aware of: You admitted that you are working with large record counts in your tables. What ...


1

Some might say depends how big the databases are; I think regardless of the size, accessing the databases directly instead of having a "local" mySQL database to query would be best, for the following reasons: No need for disk/memory/maintenance of the mySQL database If the updates to the various databases happen every few seconds, and the users may only ...


1

The unique names of the databases in a Data Guard configuration are listed in the log_archive_config parameter in the following form: log_archive_config='DG_CONFIG=(PDB10,PDB10_STBY)' You can remove the old one and add the new one as: alter system set log_archive_config='DG_CONFIG=(PDB10,PDB10SBY)'; After this, you can set log_archive_dest_N to the new ...


1

Be happy that your users seem to be going to use SQL to do the analysis, instead of pumping to excel. Make sure you have separated tasks and don't give privs to update the source data. Resource manager is your friend to prevent runaway queries. give them resources that they need, make sure other users don't get pushed out.


1

I think there is no problem, but you need to take care about data. For example, you can grant them privileges to create tables and procedures for their needs in theirs schemas, and privileges to select data from another schemas, but not to grant privileges on insert/update/delete. If they don't have privileges on update and delete data in main tables, ...


1

You should be able to backup an 11.2.0.2 database using RMAN with an RMAN repository that is set to 11.2.0.4. There seems to be some invalid objects in your RMAN repository schema. You may want to try compiling all of the invalid objects in your RMAN repository to see if they become invalid. This probably has nothing to do with you backing up an 11.2.0.2 ...


1

There are a variety of approaches you could take. You should pick the one you feel is most suitable for your application. Include no WHEN OTHERS exception handlers and let the raw Oracle errors propagate to your users. Include WHEN OTHERS exception handlers in the top-level blocks. Include WHEN OTHERS exception handlers in all/most blocks The first ...


1

In your example, you have Autoextend on with 4M as the next extension, but you also have MAXSIZE set to 8G, which means that Oracle is being told that once a tablespace reaches 8G, it will no longer automatically add space. This is for safety purposes, as sometimes administrators want to know when a datafile is growing very large very quickly. In your ...


1

@mbonaci sqlplus / as sysdba then issue command startup; to start the database Also on Linux with this error, you can check first if Oracle background processes are up with ps aux | grep pmon. Pmon is process monitor, or check some other background process. If they are not running then the database is not running.


1

ORDER BY (case when `cat` = 'mgr' then 1 when `cat` = 'dev' then 2 else 3 end) This structure help me in Wordpress. For example to select custom posts first theh other: poster and project is custom SELECT post_type FROM wp_posts ORDER BY (case when post_type = 'poster' then 1 when post_type = 'project' then 2 else 3 end)



Only top voted, non community-wiki answers of a minimum length are eligible