Latest Answer: run this query in the sql promptsql> select tablespace_name,file_name from dba_data_files; ...
Latest Answer: HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database. these tables are own by sys.the information in these tables is crypted and cannot ...
Latest Answer: Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed ...
Latest Answer: Oracle Net Services use a centralized directory server as one of the primary methods for storage of connect identifiers. Clients configured directory usage can use the connect identifiers in their connect string. The directory server resolves the ...
Latest Answer: Consider 8K block size. The total bytes 8 x 1024 = 8196 bytesEach block requires approximately 117 bytes for the header. Please note that the header size varies depending upon the block size. The total available bytes for data = ( 8196 – 117) = ...
Latest Answer: The basic diff between a locally managed tablespace and a dictionary managed tablespace is that in the dictionary managed tablespace every time a extent is allocated or deallocated data dictionary is updated which increases the load on data dictionary, ...
This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is
Latest Answer: better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold ...
How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?
One DDL SQL script that has kept at certain location should be run on multiple servers to keep database synchronize. This task has to do in oracle database and this should be done as a job from scheduler. How will you do it?
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
